What is denormalization and when would you go for it?
Answer Posted / abarna(cts)
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 ? | 34 Yes | 7 No |
Post New Answer View All Answers
What is an application role and explain a scenario when you would use one?
What is database design and development?
What is dbms and its application?
Why does this query return 0?
Which data type cannot be used as a parameter in a udf?
How to read and create .LDC data files which are used by linguatic dictionary.
How is data stored in dbms?
What are the types of database model?
What are the key features of dbms?
In which table collections errors are stored.
What are the constraints on severity level in raiseerror?
Explain about normal forms?
Explain the process of the user request and data generating?
Write the fastest query to find out how many rows exist in a table?
How can I detect whether a given connection is blocked?