RE: oracle full table scan

From: <Jared.Still_at_radisys.com>
Date: Thu, 03 Apr 2003 10:05:11 -0800
Message-ID: <F001.00579967.20030403100511@fatcity.com>

Comparing users to Marilyn Cross.

Naive, not overly bright, sentenced to death.

Is that too harsh for users?

Jared

"Gogala, Mladen" <MGogala_at_oxhp.com>
Sent by: root_at_fatcity.com
 04/03/2003 07:18 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: oracle full table scan

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
---------------------------------------------------------------------

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:
  INET: Jared.Still_at_radisys.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). Received on Thu Apr 03 2003 - 12:05:11 CST