What is de-normalization and when do you do it?
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 |
What types of replication are supported in sql server?
How do I find the size of a sql server database?
Explain having clause and where clause?
Describe in brief authentication modes in sql server.
What are “lost updates”?
When we can say that is in BCNF?
List out the difference between union and union all in sql server?
What are the elements of dbms?
How to loop through result set objects using odbc_fetch_row()?
What happens if time-only values are provided as date and time literals?
What is raid and what are different types of raid levels?
How many types of objects are there?