March 5, 2008 at 12:52 am
hello,
when i'm programming a maintenance plan with reindexation on sql serveur 2000. Could you say me if statistic is updating ?
yann.
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 5, 2008 at 8:39 am
yann.larvor (3/5/2008)
hello,when i'm programming a maintenance plan with reindexation on sql serveur 2000. Could you say me if statistic is updating ?
yann.
Not sure I follow, but are you asking to as if how you can verify whether an index's statistics were updated?
If this is SQL2000, give this a shot ...
SELECT
o.[name]
,i.[name]
,CASE [indid]
WHEN 0 THEN 'HEAP'
WHEN 1 THEN 'CLUSTERED'
ELSE'NON CLUSTERED'
ENDAS [IndexType]
,STATS_DATE(i.[id], i.[indid])AS [LastStatsUpdate]
FROM sysobjects o
INNER JOIN sysindexes i
ON o.[id] = i.[id]
WHERE o.[type] = 'U'
AND i.[indid] > 0
AND i.name not like '_WA%'
March 5, 2008 at 11:05 am
ok, i look tomorrow. thanks
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 6, 2008 at 6:30 am
the rebuild index task will update stats, reorganise index will not
---------------------------------------------------------------------
March 6, 2008 at 6:34 am
It will update stats, but not with FULLSCAN ...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply