What is denormalization and when would you go for it?
Answer Posted / sd
Denormalization is introcution of controlled redundancy in
the database.
Use denormalization generally to optimize performace of
select query. to minimize joins used in the query.
| Is This Answer Correct ? | 53 Yes | 16 No |
Post New Answer View All Answers
How can I detect whether a given connection is blocked?
What is DB Development software?
What are the three basic rules which are to be followed for the relational model of the database?
How can you log an error to the server event log from a stored procedure?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Which four data types cannot be used as a return type from a user-defined function?
How to use online Backups?
Explain about relational operator join?
What is normalization? Explain different levels of normalization?
What are data modelling techniques?
Explain what a database is?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the types of database model?
Explain the cube operator?
Which data type cannot be used as a parameter in a udf?