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 the process of the user request and data generating?
Which data type cannot be used as a parameter in a udf?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What is dbms explain in brief?
What is the database development process?
What is an application role and explain a scenario when you would use one?
Explain about the database management systems.
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What is DB Development software?
What is the physical representation for a many-to-many relationship?
I have a few records all are same structures data, I want to store data in multiple targets how
State the acid rules?
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?
Explain about the relational database?
What are the three basic rules which are to be followed for the relational model of the database?