Is there any way to check for stats or indexes being out of date ? Using SQL
server 2000STATS_DATE
Returns the date that the statistics for the specified index were last
updated.
Syntax
STATS_DATE ( table_id , index_id )
Also DBCC SHOW_STATISTICS ( table , target )
See BOL for details
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O8pAMwRcDHA.616@.TK2MSFTNGP11.phx.gbl...
Is there any way to check for stats or indexes being out of date ? Using SQL
server 2000
没有评论:
发表评论