SQL Server 2000 - list the current Statistics names that exist on a table

Published 05 November 07 08:00 AM | SQL Master 

Using Query Analyzer you can list an execution plan for a query , where you can find/get any statistics that are missing for that query. So to see the create missing statistics you will get further information such as Statistics name and so on and further information on statistics you could use DBCC SHOW_STATISTICS statement.

To get the same with TSQL you can simply run :

SELECT name, id from sysindexes where name like '%WA_Sys%'

Comments

# Other SQL Server Blogs around the Web said on November 5, 2007 8:09 AM:

Using Query Analyzer you can list an execution plan for a query , where you can find/get any statistics

# SSQA.net - SqlServer-QA.net said on November 5, 2007 8:12 AM:

Using Query Analyzer you can list an execution plan for a query , where you can find/get any statistics

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.