Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Finding sql's that are doing FTS.

Re: Finding sql's that are doing FTS.

From: Andreas Michler <Andreas.Michler_at_adicom.de>
Date: Tue, 25 Jan 2000 14:31:50 +0100
Message-ID: <388DA5C6.2156811E@adicom.de>


Use the explain plan .........
as described in Tuning Guide.
Its very easy.

screwbai_at_my-deja.com wrote:

> How do I easily find sql's that are doing full table scans (FTS).
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--



ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
Received on Tue Jan 25 2000 - 07:31:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US