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
Which four data types cannot be used as a return type from a user-defined function?
What is the maximum length of an extended property?
What is database design and development?
Explain about a primary key?
Who are end users in dbms?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain about xml databases?
What are the main phases of database development?
How can you log an error to the server event log from a stored procedure?
How you can make a parameterized view?
What are the constraints on severity level in raiseerror?
Where is dbms used?
What are the three types of database design?
Explain about the storage and physical database design?