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
Explain about post-relational databases?
Who are end users in dbms?
How would you design a database for an online site, which would average a million hits a day?
How can you fix a poorly performing query?
What are the types of database model?
How is data stored in dbms?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
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 data modeling with example?
How to customize error conditions.
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What are the main phases of database development?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Write the fastest query to find out how many rows exist in a table?