Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2002-11-08 : 05:48:01
|
| Can you tell me value of the defaul sample interval for updating statistics in sql server 2000 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-11-08 : 16:36:35
|
The basic algorithm for auto update statistics is: - If the cardinality for a table is less than six and the table is in the tempdb database, auto update with every six modifications to the table.
- If the cardinality for a table is greater than 6, but less than or equal to 500, update status every 500 modifications.
- If the cardinality for a table is greater than 500, update statistics when (500 + 20 percent of the table) changes have occurred.
- For table variables, cardinality changes does not trigger auto update statistics.
NOTE: In this strictest sense, SQL Server counts cardinality as the number of rows in the table. INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work[url]http://support.microsoft.com?kbid=195565[/url]Statistics Used by the Query Optimizer in Microsoft SQL Server 2000[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp[/url]HTHJasper Smith |
 |
|
|
|
|
|
Sample interval