Link to home
Get AccessLog in
Avatar of anwarmir
anwarmir

asked on

Sp_Updatestatistics not updating stats correctly

Hi, we are updating the statistics manually each night for our sql server 2000 database  which holds our webplatforms. I've just checked the stats on one table which is having significant performance problems by running the following query
dbcc SHOW_STATISTICS  (Sign_Ons,
 [VAR_SO_Logon-VAR_SO_Password-K_SOT_ID])

It gives me the following output :
Statistics for INDEX 'VAR_SO_Logon-VAR_SO_Password-K_SOT_ID'.
Updated              Rows                 Rows Sampled         Steps  Density                  Average key length      
-------------------- -------------------- -------------------- ------ ------------------------ ------------------------
Feb 19 2007  3:05AM  14194950             128475               200    3.2002646E-2             21.38069

The thing I am confused about is how comes the stats were updated on the 19th of feb.
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access