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
Does view store data in sql?
Difference between truncate, delete and drop commands?
How do you explain an index number?
what is transaction? : Sql dba
Why do we need view in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Explain the uses of a database trigger?
What can you do with pl sql?
What pl/sql package consists of?
What is the example of procedure?
What is a native sql query?
What is difference between pl and sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can ddl statements be used in pl/sql?