When would you denormalize?

Answer Posted / prasi

de-normalize is used, when their,, is main benefit of
denormalization is improved performance with simplified
data retrieval and manipulation. This is done by reduction
in the number of joins needed for data processing.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger in sql?

582


How does rowid help in running a query faster?

970


How to run pl sql program in mysql?

513


How do you rank data in sql?

517


What is character functions?

558






what is auto increment? : Sql dba

576


What is the difference between left and left outer join?

518


What is dba in sql? : SQL DBA

537


what is a materialized view? : Sql dba

575


What is sql basics?

586


Why do we use %rowtype & %type in plsql?

610


How many databases can sql express handle?

536


What is an example of translating a date into julian format?

582


What is difference between db2 and sql?

533


What are different types of sql?

565