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/prodtechnol/sql/2005/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,|||On Fri, 11 Nov 2005 18:28:39 -0500, "Andrew J. Kelly"
<sqlmvpnooospam@.shadhawk.com> wrote:
>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/prodtechnol/sql/2005/qrystats.mspx
>Even though this is for 2005 it has some really great info and a lot still
>applies to 2000.
Good stuff!
And this Yukon/2005 thing may just be hot!
.. as Paris Hilton would say ...
J.sql