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
What are the operating modes in which database mirroring runs?
Determine when an index is appropriate?
How to grant a permission in ms sql server using "grant execute" statements?
How to download microsoft sql server 2005 express edition?
What is Sqlpaging in SqlServer 2005 ?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What are key constraints?
Can you leave a union at any time?
Can a synonym name of a table be used instead of a table name in a select statement?
What are commonly used mssql functions in php?
What is filter index?
How to select an exiting database using mssql_select_db()?
What is clr ddl trigger?
Tell me what is de-normalization and what are some of the examples of it?
Detail about the hardware which is supported by SQL server?