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
What is memory optimized?
Explain the difference between rename and alias?
List the different type of joins?
What is sql procedures and functions?
how to see the create table statement of an existing table? : Sql dba
What is a natural join?
Name three sql operations that perform a sort.
how to increment dates by 1 in mysql? : Sql dba
What are the different dcl commands in sql?
What is multiple columns?
What is the difference between microsoft access and sql?
What are user defined functions?
How can you get sql*loader to commit only at the end of the load file? : aql loader
How do you use collections in procedure to return the resultset?
How to start the command-line sql*plus?