What is de-normalization and when do you do it?

Answer Posted / swapna

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 ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a sql query to get zero records from a table having n number of records?

705


What is public role in sql server?

532


Is INSTEAD OF trigger directly applicable to Table ?

569


What is a primary index?

520


How are the exceptions handled in sql server programming?

603






How real and float literal values are rounded?

580


How would you go about developing a ssrs report?

110


Is it possible for a stored procedure to call itself or recursive stored procedure?

502


How to fine-tune reports?

151


What are the difference between clustered and a non-clustered index?

582


What are synonyms?

523


What is blocking and how would you troubleshoot it? : sql server database administration

584


What is join query?

495


What is a recursive stored procedure in sql server?

565


How to convert numeric expression data types using the cast() function?

542