DBCC SHOW_STATISTICS

I would like detail information that goes along with DBCC SHOW_STATISTICS
within SQL Server 2000. I am trying compare indexes within a table to see
which indexes were used the most.
Thanks,DBCC SHOW_STATISTICS will not give you any information about how much
indexes are used or even if they are used at all. There is no really good
way in 2000 to do that but 2005 does add some features along those lines.
But to answer your question about the details look in BooksOnLine and here.
http://www.microsoft.com/technet/pr...5/qrystats.mspx
Even though this is for 2005 it has some really great info and a lot still
applies to 2000.
Andrew J. Kelly SQL MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:BB5E2F12-D312-4CF4-AD7C-AC364CAF6C43@.microsoft.com...
> I would like detail information that goes along with DBCC SHOW_STATISTICS
> within SQL Server 2000. I am trying compare indexes within a table to see
> which indexes were used the most.
> Thanks,