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
In which table collections errors are stored.
What is DB Development software?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is database design and development?
Explain about the relational database?
What is an application role and explain a scenario when you would use one?
How can you fix a poorly performing query?
Why does this query return 0?
How can I detect whether a given connection is blocked?
Explain about network model?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Explain the role of indexing in databases?
Explain about relational database management systems?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS