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: 1000 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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

Bookmark It

< Previous : How to update the statistics for an index?

Next > : When does the UPDATE_STATISTICS command used?

Comments or Responses

More Interview Questions by vishalneeraj-24503

When does the UPDATE_STATISTICS command used?
Which Database is a system Database which is used as a Template whenev ...
How To Reset MySQL Auto_Increment Column?
How to Create a New Table From Another Table in Sql Server or Copy Tab ...
How to Create a New Table From Another Table in Sql Server or Copy Tab ...
How to Create Unique Key on the columns?
Why do we use Unique Key?
Which statement is TRUE about Constructors?

Latest Interview Questions

In C#, the keyword used to pass the arguments by reference is?
In C#, the keyword used to access the base class members from the deri ...
In C#, the following keyword used to allocate the for a class's in ...
In C#, the keyword used to create an object to a class or struct is?
In C#, the process of grouping the related methods and variables (memb ...
C# doesn't support one of the following features. Find that?
In C#, the method used to sort an array in the descending order is?
In C#, the method used to sort an array in the ascending order is?
More ...