Re: SQL statistics

Zernan Martinez wrote:
>
> Does anybody know how to display statistics on a SQL request?
> I would like to know how Oracle processed my query any hopefully be
> able to optimize my request.

  You can use EXPLAIN PLAN to check the execution plan and SQL_TRACE to trace the statistics on SQL statement execution.  

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841