When would you denormalize?

Answer Posted / priya

Denormalization is the process of putting one fact in
numerous places (its vice-versa of normalization).Only one
valid reason exists for denormalizing a relational design -
to enhance performance.The sacrifice to performance is that
you increase redundancy in database.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of desc in sql?

496


How do I trace sql profiler?

493


discuss about myisam index statistics collection. : Sql dba

531


What is the purpose of a secondary key?

513


What are the different parts of a package?

635






What is use of term?

626


Advantages and disadvantages of stored procedure?

583


Is pl sql and postgresql same?

574


Why is partition used in sql?

552


Where the sql database files are stored?

496


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1647


What are the different sql languages?

544


What is multiple columns?

575


What is the main difference between sql and pl/sql?

567


What is data type in sql?

556