Can I get information when was the last update statistics of index on partition ?

• tklimczak

  Old Hand

  Points: 321

  More actions

  October 25, 2007 at 5:50 am

  #120929

  Hi,

  I have no problem with get information when statitsics of index was last time updated if index on all partitions was rebuild.

  But when i rebuild index on one partition, and i try to get last time of update statistics of index using STATS_DATE - function return null.

• VaiydeyanathanVS

  Hall of Fame

  Points: 3053

  More actions

  October 25, 2007 at 6:20 am

  #745341

  Please find the links to utilize related with statistics for index creation !!!!!!!!!!!

  http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx