What Is De-normalization? When Do You Do It And How?

1.	What Is De-normalization? When Do You Do It And How?
Answer» De-normalization is the process of ATTEMPTING to optimize the performance of a database by adding REDUNDANT DATA. It's used To introduce redundancy into a table in order to incorporate data from a related table. The related table can then be ELIMINATED. De-normalization can improve EFFICIENCY and performance by reducing complexity in a data warehouse schema. De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It's used To introduce redundancy into a table in order to incorporate data from a related table. The related table can then be eliminated. De-normalization can improve efficiency and performance by reducing complexity in a data warehouse schema.

Answer»

De-normalization is the process of ATTEMPTING to optimize the performance of a database by adding REDUNDANT DATA. It's used To introduce redundancy into a table in order to incorporate data from a related table. The related table can then be ELIMINATED. De-normalization can improve EFFICIENCY and performance by reducing complexity in a data warehouse schema.

De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It's used To introduce redundancy into a table in order to incorporate data from a related table. The related table can then be eliminated. De-normalization can improve efficiency and performance by reducing complexity in a data warehouse schema.

Discussion

No Comment Found

Related InterviewSolutions

What Does It Mean To Have Quoted_identifier On? What Are The Implications Of Having It Off?
What Is Task?
How Does You Handle This Com Components Developed In Other Programming Languages In .net?
How Do U Call And Execute A Stored Procedure In .net?
How Do You Find The Error, How Can You Know The Number Of Rows Affected By Last Sql Statement?
What Is The Stuff Function And How Does It Differ From The Replace Function?
Explain Differences Between Framework 1.0 And Framework 1.1?
What Are The Differences Between User Control And Web Control And Custom Control?
How Do Sql Server 2000 And Xml Linked? What Is Sql Server Agent?
If We Write Any Code For Datagrid Methods, What Is The Access Specifier Used For That Methods In The Code Behind File And Why And How? Give An Example?