November 23, 2006 at 3:06 pm
I have more than 500 Tables for just one DB. my question is how i can find details info about unused/neverused NON-CLUSTERED INDEX for those individual Tables with there INDEX Names some more info. Any help is appreciated & thanking in advance.
November 23, 2006 at 9:19 pm
If you are using SQL 2005, have a look at the output from the DMV called sys.dm_db_index_usage_stats.
If you are using SQL 2000, you cannot definitively find what indexes have never been used. I have a vague recollection that some information is available about an index but this is not stored permanently (i.e. it would only be based on activity since the SQL Server service last started). I may be wrong on this - as I said it is a vague recollection and I can't find any info about it at present.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply