How to Update all statistics on a table or what is the syntax?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 259 | Points: 40
Answer:

Use below script:-
Update Statistics Tbl_Name.

For Example:-
If we want to update all statistics on a Table called Employee_Master,then we will write as:-
Update Statistics Employee_Master.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response