Re: oracle full table scan

From: Alex Andriyashchenko <alex_a_at_pisem.net>
Date: Thu, 03 Apr 2003 06:14:04 -0800
Message-ID: <F001.0057949B.20030403061404@fatcity.com>

Hello Arvind,

Thursday, April 3, 2003, 5:58:38 AM, you wrote:

AK> Dear All,

AK>       is there any way to find which tables (table name) are suffering from
AK> full table scan ,so that  i can create indexes on them to enhance the
AK> performance.

AK> Thanks

AK> Arvind 
AK> -- 
AK> Please see the official ORACLE-L FAQ: http://www.orafaq.net

Use SQL_TRACE feature to find all statements which used FTS.

--

Best regards,

 Alex                            mailto:alex_a_at_pisem.net

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Alex Andriyashchenko
  INET: alex_a_at_pisem.net

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 - 08:14:04 CST