What is the purpose of UPDATE STATISTICS?

What is the purpose of UPDATE STATISTICS?

As like as UPDATE STATISTICS have a many purposes but right now we have a main purpose which is explain here :
> It is main;y use for the Updates information about the distribution of key values for one or more statistics groups or collections in the specified table or indexed view.

By:UMANG
Date:2013-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher