What is de-normalization and when do you do it?
- 3 Answers
- 7405 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 |
how many types of store procedre in sqlserver 2000?
How to delete multiple rows with one delete statement in ms sql server?
What is the difference between Procedure and Function
4 Answers Accenture, Nagarro, TCS,
How to stop log file growing too big?
What are the basic features of a trigger in ms sql server?
how to take backup bcp out for a column in table in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
What is indexing explain it with an example?
What are different type of Collation Sensitivity?
How to write a script for upate the data in prod , i have 50000 row are there
What should be the fill factor for indexes created on tables? : sql server database administration
can an automatic recovery be initiated by a user? : Sql server administration
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
