Query Optimization FAQ
Some of the common questions asked by DBAs about SQL Server Query Optimization are as follows:
| Q1: | Does UPDATE STATISTICS need be run on a frequent basis? |
| A1: | UPDATE STATISTICS does not need to be run on a frequent basis because the query optimizer automatically notices that statistics are out of date and automatically rebuilds the statistics. This is significantly different from previous versions, which required that the UPDATE STATISTICS command run on a frequent basis. It does not hurt anything to run UPDATE STATISTICS, but you might not gain anything. In certain rare occurrences, you might need to run UPDATE STATISTICS if you feel that you are getting a poor query optimization plan or if the data is changing rapidly ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
