What is denormalization and when would you go for it?
Answer Posted / sd
Denormalization is introcution of controlled redundancy in
the database.
Use denormalization generally to optimize performace of
select query. to minimize joins used in the query.
| Is This Answer Correct ? | 53 Yes | 16 No |
Post New Answer View All Answers
Explain what a database is?
Who are end users in dbms?
What is dbms and its application?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain about the database management systems.
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?
State the acid rules?
What is an application role and explain a scenario when you would use one?
How to customize error conditions.
Explain the rollup operator?
In which database can extended stored procedures be added?
How to use online Backups?
How can you fix a poorly performing query?
Write the fastest query to find out how many rows exist in a table?