What is denormalization and when would you go for it?
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
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?
What is a database development?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Write the fastest query to find out how many rows exist in a table?
Explain about the database management systems.
Explain about the hierarchical model of the database?
Explain about a primary key?
In which database can extended stored procedures be added?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
What is dbms and its application?
Who are end users in dbms?
Which data type cannot be used as a parameter in a udf?
What are the types of database model?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to customize error conditions.