Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to avoid fast full scan of index?
"Tanel Poder" <tanel@@peldik.com> wrote in message
news:3f33dc13$1_1_at_news.estpak.ee...
> There is an event: "10120 CBO Disable index fast full scan", but it didn't
> work in my test env (9.2.0.1 W2k).
and BTW: in 9.2 the event is 10156 .. not 10120. I would use it as a last resort only. Oracle can change event number's purpose in subsequent versions.
Anurag Received on Fri Aug 08 2003 - 22:09:07 CDT