RE: RE: FULL TABLE SCAN?

I think you are new to the list.

All '_' parameters given as a solution without a warning that their use can be dangerous, are meant as fun and nothing else.

Regards
Naveen

-----Original Message-----
Sent: Wednesday, January 08, 2003 8:44 AM To: Multiple recipients of list ORACLE-L

Is it good to use this (_full_table_scan=FALSE)? If there are less than (say about 1 lakh records), a full scan of table is better. How efficient is the usage of the above by setting it to false.

Rgds,
Satya

On Tue, 07 Jan 2003 Koivu, Lisa wrote :
>_full_table_scan=FALSE
>
>-----Original Message-----
>Sent: Tuesday, January 07, 2003 11:29 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi
>How to avoid FULL TABLE SCAN?
>Thx
>-seema
>
>
>
>
>
>_________________________________________________________________
>MSN 8 with e-mail virus protection service: 2 months FREE*
>http://join.msn.com/?page=features/virus
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Seema Singh
> INET: oracledbam_at_hotmail.com
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting
>services
>---------------------------------------------------------------------
>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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Satya V Prakash
  INET: prakash801_at_rediffmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).