How to find full table scan?

Question:

How do I easily find sql's that are doing full table scans (FTS)?

Answer 1:

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

Answer 2:

Or you could in Sqlplus, just
set autotrace on
and run the query.
Be sure to have the plan_table installed first though.
 
 
 

Hosted by www.Geocities.ws

1