What is the purpose of UPDATE STATISTICS?
By admin on Mar 14, 2007 in Ms Sql Server Interview Questions
Updates information about the distribution of key values for one or more statistics groups (collections) in the specified table or indexed view.
Current Article
Related Posts
- What are statistics, under what circumstances they go out of date, how do you update them?
- Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size. Based on the standard naming convention, you have determined that the record is a temporary record since it ends with _TAOYou look into the database and decide that that the data is not required any more. You ask the DBA to delete the data in the table.Next day you get a call from an irritated user who says that a daily process that took only 1 minute to run is taking about 2 hours today. You look into his process and find that it uses PS_ABC_TAO as a temporary table.What would you suggest the DBA to do?
- What is the use of ANALYZE command?
- What are the steps you will take to improve performance of a poor performing query?
- The Update Statement
