Re: Problem with statistics

From: Willaert Doris <doris.willaert@suzuki.be> > >We have a problem with statistics on 2 tables. We run update statistics on >a >regular basis. (once every morning and once in the evening). Why so often? Does the table really grow that often? >We have a select on the 2 tables and in sqexplain.out we see that this >select the optimiser uses a sequential scan instead of using the index. We >do an update statistics on this 2 tables and the optimiser takes an index >path. > >How is this possible ? We have 2 ours between the first update statistics >and the time that the optimiser takes the wrong path. Are you saying that the optimiser changes path *without* an update statistics? That can't be right? What update statistics are you doing? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com