What is de-normalization and when do you do it?

Answers were Sorted based on User's Feedback



What is de-normalization and when do you do it?..

Answer / swapna

As the name indicates, denormalization is the reverse
process of normalization. It's the controlled introduction
of redundancy in to the database design. It helps improve
the query performance as the number of joins could be
reduced.

Is This Answer Correct ?    7 Yes 3 No

What is de-normalization and when do you do it?..

Answer / praveen

Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access.

Is This Answer Correct ?    1 Yes 0 No

What is de-normalization and when do you do it?..

Answer / praveen

If the database developer might want a reversal of
normalization to improve performance is called
denormalization.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What types of replication are supported in sql server?

0 Answers  


How do I find the size of a sql server database?

0 Answers  


Explain having clause and where clause?

0 Answers  


Describe in brief authentication modes in sql server.

0 Answers  


What are “lost updates”?

0 Answers  






When we can say that is in BCNF?

3 Answers   BitWise,


List out the difference between union and union all in sql server?

0 Answers  


What are the elements of dbms?

0 Answers  


How to loop through result set objects using odbc_fetch_row()?

0 Answers  


What happens if time-only values are provided as date and time literals?

0 Answers  


What is raid and what are different types of raid levels?

0 Answers  


How many types of objects are there?

0 Answers  


Categories