Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
miranwar
Posting Yak Master
125 Posts |
 Posted - 2007-03-01 : 09:25:00
|
| 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.38069The thing I am confused about is how comes the stats were updated on the 19th of feb? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-01 : 10:03:12
|
| i know it might be obvious butdoes your manual process also update this statistic?Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
sp_updatestatistics not working as expected