Hi, I am on SQL 2000 SP4 with latest SQL patches. I am running the UPDATE STATISTICS WITH FULL SCAN on all tables twice a week. The time taken on each run is different every time. On 23rd Sep it took 14.5 hrs, 28th Sep it tool 15 hrs, on 1st Oct it took 11 hrs. Checked the Locks/Blocks, CPU counters, Memory Counter and Waits at table levels but could not see a pattern for the behaviour. Have not done any re-org or re-indexing since 23rd Sep, however doing a Index Defrag everyday. Please could anyone let me know how to figure out what might be the reason. Thanks in advance..