-
index usage in sql 2000
Hello,
I need to find out how the indexes being used in the database, SQL 2000. Is it being used or not? If not, we can drop them to save up some spaces. Do you know of anyway we can do to get this inventory info.? I know there are features in SQL server 2005 and 2008. But I couldn't find for SQL 2000. Thanks in advance for your help.
Thanks,
Sunny,
-
Not easy in sql2k, may need trace with profiler.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|