How to check for statistics information on the tables

• kiran-670359

  SSC Eights!

  Points: 853

  More actions

  March 28, 2008 at 12:59 am

  #188551

  Hi all,

  :).I have a table called table_a.i need to know the statistics information on this table.

  i checked like this

  ANALYZE table kiranaddress.table_a compute statistics;but it is not working

  here kiranaddress is my schema name.

  Can anyone suggest me correct syntax for computing statistics.

  Thanks,

  Kiran

• SQLZ

  SSChampion

  Points: 12872

  More actions

  March 28, 2008 at 1:59 am

  #795008

  Kiran,

  Try dbcc show_statistics.

  dbcc show_statistics('kiranaddress.table_a', )

  --you can supply statistics name or column name (assuming there are stats on the column you specify) in place of index_name.

  Karl
  source control for SQL Server