Interested to Buy Any Domain ? << Click Here >> for more details...
What is de-normalization and when do you do it?
- 3 Answers
- 9207 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
As the name indicates, denormalization is the reverse
process of normalization. It's the controlled introduction
of redundancy in to the database design. It helps improve
the query performance as the number of joins could be
reduced.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / praveen
Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / praveen
If the database developer might want a reversal of
normalization to improve performance is called
denormalization.
| Is This Answer Correct ? | 0 Yes | 1 No |
i want table name basis on column name.
Explain about system database?
What are the limitation of the Online Index Rebuild Operation?
Can an entity have two primary keys?
what is integrated security (SSPI). why we use in the connection string?
wat new abt truncate in sql server
Define left outer join in sql server joins?
What Are Three Rules to Use UNION IN SQL SERVER
List out the differences between global and local temp tables in sql server?
What is plan freezing?
What are basics of policy management?
What are triggers? How do you invoke a trigger on demand?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
