Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 39259 Views
- NBP, I also Faced
- E-Mail Answers
Answer Posted / sivaraman (gasc)
Denormalization is the process of attempting to optimize
the performance of a database by adding redundant data or
by grouping data. In some cases, denormalization helps
cover up the inefficiencies inherent in relational database
software. A relational normalized database imposes a heavy
access load over physical storage of data even if it is
well tuned for high performance
| Is This Answer Correct ? | 22 Yes | 5 No |
Post New Answer View All Answers
Explain about normal forms?
What are the 18 schemas?
Who are end users in dbms?
Explain what a database is?
Which four data types cannot be used as a return type from a user-defined function?
What is normalization? Explain different levels of normalization?
How to replace not in with not exist?
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?
What is an application role and explain a scenario when you would use one?
Explain about the hierarchical model of the database?
Why does this query return 0?
I have a few records all are same structures data, I want to store data in multiple targets how
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain about a primary key?
What is the maximum length of an extended property?
