Analyze index

[marina_sirota]

Hello, friends!
sorry for the stupid question:
I created a new index on table and I'm looking to a command equal to "Analyze table ", "Compute statistics "in Oracle
to check if that index is usefull.

Thank you very much in advance.

[DNAunion2000]

DNAunion: Darned, I forgot to bring my SQL Server books home!

I saw that in SQL Server 7.0 that there is a command similar to:


DBCC SHOW_STATISTICS


(I wish I had the book so I'd be sure to get it right).

Also, in both SQL Server 7 and SQL Server 2000 there is an "Index Analyzer Wizard" (that name may not be exact).


*************************************

DNAunion: Came back to add...I got the command right. Here's one link: many more came up with a Google search on "DBCC SQL Server statistics".

http://www.databasejournal.com/features/mssql/article.php/1441301

*************************************

DNAunion: Back again. I guess one out of two isn't bad! I messed up the other term. Doing a Google search on "SQL Server wizard index" turned up lots of hits for "Index Tuning Wizard".

[marina_sirota]

thank you very much friends!!!!

[marina_sirota]

thank you very much, friends!!!!