S
steve pittman
Guest
The suggestion from both Libor and Gus is good. After 11.1, there were changes to sql statistics to make the optimizer work better with non-uniform data distributions, and with situations with many duplicate key values (uniform or non-uniform). So the statistics have a slightly different content now. The old content should be OK, but the old statistics won't get the best optimizer performance. So definitely do UPDATE STATISTICS. And do UPDATE INDEX STATISTICS - which gives very useful statistics for joining and searching. Note that the base UPDATE STATISTICS does not create index stats. For detailed syntax, the sql reference manual is a good resource (it is avaliable onlline). hope this helps, ....steve pittman [sql development software architect]
Continue reading...
Continue reading...