RE: Problem with statistics

From: Willaert Doris <doris.willaert@suzuki.be> > >The batch program does updates on one of the tables mentioned. This table >contains =/- 1.600.000 records and the program changes approximately 2000 - >3000 records (including index values). This should not cause any change to the index access paths, unless it includes an update statistics somewhere within the code...? And even then, I'd be very sceptical. >What does your script ? Does it perform update statistics high or low ? Get it and try it. It does a "proper", by the book US. >If I use only selects that follow index path, isn't a simple update >statistics enough and why not ? No. The optimiser doesn't just use the table size, it also considers the distribution of the data. Get the script, and try it tonight. Don't do your update stats in the morning, and see what happens. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com