Auto update statistics - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Auto update statistics

Author

Topic

gsolares
Starting Member

7 Posts

Posted - 2006-04-05 : 09:59:16

Hi all,

I'm using SQL 7, there is a setting on DB properties called "Auto update statistics", what kind of statistics does this refers to and how can this stats be accessed?

Thanks for your help!

Gustavo

Thanks,

GS

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-04-05 : 10:12:43

this is for sql server 2k but it's same for 7.0
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/statquery.htm

http://www.sql-server-performance.com/statistics.asp

Go with the flow & have fun! Else fight the flow

Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources