SQL Tunning - result of set autot traceonly

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Mon, 11 Jul 2011 20:39:50 -0300
Message-ID: <CAJdDhaOMmvbRnGwfBuZqtiW=rgFn+hqddgbMYmD5Npkb4JsrKQ_at_mail.gmail.com>



Hi Friends,

  I have the Result from traceonly, as below.   My doubt is:

   1.) oracle ran the query from 4 to 25 or it ran from 25 to 4

   2.) What does it mean : 'access'

        Means that the oracle process went to the disk to retrieve data ?

   3.) What does it mean : 'filter'

        Means that oracle process performed a filter in the data that was in memory (cached) ?

   4.) Considering that the item 21 is more selective for query, where must I put it in the statment:

        at the begin of the WHERE CLAUSE or
        at the eng of the WHERE CLAUSE ?


Predicate Information (identified by operation id):


   4 - access("T1"."NUM_DOCUMENTO"="SPL"."NUM_DOCUMENTO" AND "SPL"."NUM_ACIONAMENTO"="VW_COL_1")    5 - access("NUM_DOCUMENTO"="T1"."NUM_DOCUMENTO")

   9 - filter("T1"."UF"='XX')

  10 - access(ROWID=ROWID)

  11 - access(ROWID=ROWID)

  12 - access(ROWID=ROWID)

  13 - access(ROWID=ROWID)

  14 - access(ROWID=ROWID)

  15 - access("T1"."UF"='RS')

  21 - filter("SPL"."STATUS"=2 AND "SPL"."DATA">=TO_DATE(' 2003-12-19 00:00:00', 'syyyy-mm-dd

              hh24:mi:ss') AND "SPL"."DATA"<=TO_DATE(' 2011-07-06 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))

  23 - access("T1"."NUM_DOCUMENTO"="SC"."NUM_DOCUMENTO"(+))

  24 - filter("TC"."N1"='BRT')

  25 - access("T1"."NUM_DOCUMENTO"="TC"."NUM_DOCUMENTO")

Regards
Eriovaldo

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 11 2011 - 18:39:50 CDT

Original text of this message