Re: Fast Full Index Scan in 8.1.7

The alternative is probably a full table scan.

Are you sure you want to turn it off?

I think you need to hint your SQL to do that.

Jared

On Thursday 06 September 2001 13:21, Cherie_Machler_at_gelco.com wrote:
> I had been using the FAST_FULL_SCAN_ENABLED initialization parameter in an
> 8.0.4 database.
>
> Apparently this parameter is now obsolete in 8.1.7.2. Seems as though I
> am getting the fast full index
> scans automatically now. I'm not sure if I want them in all cases. Is
> there a way to turn them off?
>
> Thanks,
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).