what is normalization?
what is denormalization?
Answer Posted / abdul quadir parihar
Normalization is the process of decomposition of complex
data in to simple way.
Denormalization is basically applied in the case the
database is over-normalised and no. of joins required to
fetch the data are too much. It is a purposeful redundancy
of some of the data to avoid the overhead of joins.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How can sql injection be stopped? : sql server security
How to provide default values to stored procedure parameters?
In case you have filters in your report, when filters will be applied in cached report instance?
Can sql server be linked with other servers like oracle?
Explain throw statement in sql server 2008?
What are the differences between web role and worker role?
What are functions in the sql server?
What are cursors in ms sql server?
How you can get the list of largest tables in a database?
What are views used for?
What is normalization and what are the advantages of it?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How do I delete a sql server database?
Do you know hot add cpu in sql server 2008?
How to execute a stored procedure in ms sql server?