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

Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: xplan row source 9i

Fwd: xplan row source 9i

From: Barbara Baker <barb.baker_at_gmail.com>
Date: Fri, 10 Dec 2004 10:18:03 -0700
Message-ID: <47a6f72b041210091864a59026@mail.gmail.com>


Chris:
The explain plans are the same for 8i and 9i. What I do not have is a full-up trace for 8i.

Here's 8i:
Execution Plan



  0 SELECT STATEMENT Optimizer=RULE (Cost=4 Card=4 Bytes=228)   1 0 CONCATENATION
  2    1     INDEX (RANGE SCAN) OF 'PK_WOD' (UNIQUE) (Cost=4 Card=2 Bytes=114)
  3    1     INDEX (RANGE SCAN) OF 'PK_WOD' (UNIQUE) (Cost=4 Card=2 Bytes=114)

here's 9i:



| Id | Operation | Name | Rows | Bytes | Cost (%CPU)|
|   0 | SELECT STATEMENT     |             |     4 |   228 |     4  (50)|
|   1 |  CONCATENATION       |             |       |       |            |
|*  2 |   INDEX RANGE SCAN   | PK_WOD      |     2 |   114 |     4   (0)|
|*  3 |   INDEX RANGE SCAN   | PK_WOD      |     2 |   114 |     4   (0)|

-------------------------------------------------------------------------

Predicate Information (identified by operation id):


  2 - access("WOD"."WO_KEY"='099999126CLSS000000012004112809990099' AND
             "WOD"."XRF_KEY">='7003549682---01')
      filter("WOD"."XRF_KEY">='7003549682---01')
  3 - access("WOD"."WO_KEY">'099999126CLSS000000012004112809990099')
      filter("WOD"."WO_KEY">'099999126CLSS000000012004112809990099' AND
             (LNNVL("WOD"."WO_KEY"='099999126CLSS000000012004112809990099') OR
             LNNVL("WOD"."XRF_KEY">='7003549682---01')))

20 rows selected.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 10 2004 - 11:19:22 CST

Original text of this message

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