Re: oracle full table scan

Hi Arvind,

A little test for you.

You have a table that contains 10,000,000 rows that is packed tightly into 1,000,000 data blocks.

You have an index that has a level of 4 and has 10,000 leaf blocks.

The table is well striped across a number of devices and you have 4 CPUs on the box.

You write a simple select statement that queries the table based on the indexed column and *just 10%* of the data needs to be retrieved.

You determine that the CBO has performed a full table scan.

Do you break out into a nervous sweat or do you sigh thank goodness and worry about something else instead ?

Cheers

Richard (let me know if you want to know the comparative costs ;)

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, April 03, 2003 2:58 PM

> Dear All,
>
> is there any way to find which tables (table name) are
suffering from
> full table scan ,so that i can create indexes on them to enhance the
> performance.
>
>
> Thanks
>
> Arvind
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arvind Kumar
> INET: arvindk_at_sqlstarintl.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: Richard Foote
  INET: richard.foote_at_telstra.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).