Manual Update statistics on small tables may provide a big impact
This is an interesting thing to know. It seems that automatic update of statistics doesn't work for small tables (up to 500 rows) on SQL server 2000.
More here.
Legacy Comments
|
Tara
2006-05-12 |
re: Manual Update statistics on small tables may provide a big impact Posting the same comment from the forums: You aren't supposed to rely on the auto update statistics anyway. You are supposed to have it enabled plus also have a job that runs UPDATE STATISTICS. I believe this information can be found at sql-server-performance.com. |
|
Jen
2006-05-13 |
re: Manual Update statistics on small tables may provide a big impact very informative, it seems doing it automatic doesn't ensure that statistics gets updated have you tried it on your system yet? did you get the same result? ;) |