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 the purpose of design view?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Is primary key a clustered index?
How do you declare a constant?
What is the purpose of a sql?
What does a pl/sql package consist of?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
what is the different between now() and current_date()? : Sql dba
Write a query to display the current date in sql?
what is a relationship and what are they? : Sql dba
How do you get column names only for a table (sql server)?
Can we delete column in sql?
How do I partition in sql?
What is sql query optimization?
What is nosql vs sql?