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

Is sql a case sensitive language?

512


Is full outer join same as cross join?

501


what's the difference between a primary key and a unique key? : Sql dba

504


What plvcmt and plvrb does in pl/sql?

872


how can we submit a form without a submit button? : Sql dba

534






What is sql deadlock?

562


Does sql backup shrink transaction log?

551


What are the disadvantages of not performing database normalization?

593


What is type and rowtype in pl sql?

534


How can one get sql*loader to commit only at the end of the load file? : aql loader

561


How to use sql statements in pl/sql?

578


How sql query is executed?

550


How do I run a sql trace?

518


Is sql the best database?

498


What is sql and db2?

531