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 are the types of indexes?
What is indexed view? How to create it?
what is normalization? : Sql server database administration
Which virtual table does a trigger use?
Describe the functionalities that views support.
When is the use of update_statistics command?
List some of the rules that apply to creating and using a ‘view’
Do you know what is difference between index seek vs. Index scan?
Explain about system database?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Explain the properties of the relational tables?
What does the automatic recovery do?