What Is The Purpose Of Update Statistics?

1.	What Is The Purpose Of Update Statistics?
Answer» UPDATE STATISTICS- it updates information about the DISTRIBUTION of KEY values for ONE or more statistics groups (collections) in the specified table or indexed VIEW. UPDATE STATISTICS- it updates information about the distribution of key values for one or more statistics groups (collections) in the specified table or indexed view.

Answer»

UPDATE STATISTICS- it updates information about the DISTRIBUTION of KEY values for ONE or more statistics groups (collections) in the specified table or indexed VIEW.

UPDATE STATISTICS- it updates information about the distribution of key values for one or more statistics groups (collections) in the specified table or indexed view.

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?

What Is The Purpose Of Update Statistics?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment