Oracle-L: RE: oracle full table scan

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 03 Apr 2003 07:18:36 -0800
Message-ID: <F001.005795E3.20030403071836@fatcity.com>

Tables are not suffering, they're rather cruel and coldhearted. As in the Tom Godwin's story, "The Cold Equations", it's always the users who pay the price. You might try with tuning the SQL statements that access tables. Occasionally, that does the trick.

-----Original Message-----
Sent: Wednesday, April 02, 2003 11:59 PM To: Multiple recipients of list ORACLE-L

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: Gogala, Mladen
INET: MGogala_at_oxhp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------