Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out1.nntp.be!propagator2-sterling!news-in-sterling.nuthinbutnews.com!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc01.gnilink.net.POSTED!53ab2750!not-for-mail
From: "Anurag Varma" <avarmadba.skipthis@yahoo.com>
Newsgroups: comp.databases.oracle.server
References: <894b11eb.0308080802.65850337@posting.google.com> <0TPYa.268$aE1.186@nwrddc01.gnilink.net> <3f33dc13$1_1@news.estpak.ee>
Subject: Re: how to avoid fast full scan of index?
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <nBZYa.1149$aE1.283@nwrddc01.gnilink.net>
Date: Sat, 09 Aug 2003 03:09:07 GMT
NNTP-Posting-Host: 151.198.147.137
X-Complaints-To: abuse@verizon.net
X-Trace: nwrddc01.gnilink.net 1060398547 151.198.147.137 (Fri, 08 Aug 2003 23:09:07 EDT)
NNTP-Posting-Date: Fri, 08 Aug 2003 23:09:07 EDT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240161


"Tanel Poder" <tanel@@peldik.com> wrote in message
news:3f33dc13$1_1@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