Update USage

• Mkumari

  Hall of Fame

  Points: 3498

  More actions

  August 13, 2002 at 11:03 am

  #79557

  Hi all,

  Is there a way i can know when was the last time the statistics were updated on a database.

  Thanks,

  M

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  January 9, 2003 at 10:29 am

  #445959

  It is a bit complicated, but it's feasible:

  first of all you update the statistics on a table not on a DB.

  To see all the statistics enter:

  sp_helpstats YourTableName, 'ALL'

  after you can check the statistics by typing

  dbcc show_statistics (YourTableName, StatName)

  
  
  Bye
  Gabor