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 -> Explain Plan Question

Explain Plan Question

From: Parris Geiser <parris_at_douglas.esp.bellcore.com>
Date: 1997/06/20
Message-ID: <5oes7a$dco@athos.cc.bellcore.com>#1/1

Here are two results from Explain plan. Does anyone know the exact meanings of the rows? Which format of the query is the "best"?

---> QUERY 1

SELECT wcClli, houseNoPart1, suffix, houseNoPart2, houseNoPart3, prinumad.houseNoType, elevType, elevId, structType, structId, unitType, unitId, SvcLoc.objectId
FROM StrRng, PriNumAd, SvcLoc
where
svcloc.prinumaddr_objectid = prinumad.objectid AND prinumad.strrng_objectid = strrng.objectid AND strrng.objectid = 2628

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: RULE
     47   NESTED LOOPS
     29    NESTED LOOPS
      1     TABLE ACCESS   GOAL: ANALYZED (BY ROWID) OF 'STRRNG'
      1      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_006_STRRNG' 
                 (UNIQUE)
     29     TABLE ACCESS   GOAL: ANALYZED (BY ROWID) OF 'PRINUMAD'
     30      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'AK_033_PRINUMAD' 
                 (UNIQUE)
     47    TABLE ACCESS   GOAL: ANALYZED (BY ROWID) OF 'SVCLOC'
     76     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'AK_044_SVCLOC' 
                (UNIQUE)

---> QUERY 2
SELECT wcClli, houseNoPart1, suffix, houseNoPart2, houseNoPart3, prinumad.houseNoType, elevType, elevId, structType, structId, unitType, unitId, SvcLoc.objectId
FROM StrRng, PriNumAd, SvcLoc
where
PriNumAd.strRng_objectid = 2628 AND
SvcLoc.priNumAddr_objectId = PriNumAd.objectId AND StrRng.objectId = PriNumAd.strRng_objectId

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: RULE
     47   NESTED LOOPS
     29    NESTED LOOPS
     29     TABLE ACCESS   GOAL: ANALYZED (BY ROWID) OF 'PRINUMAD'
     30      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'AK_033_PRINUMAD' 
                 (UNIQUE)
     29     TABLE ACCESS   GOAL: ANALYZED (BY ROWID) OF 'STRRNG'
     29      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_006_STRRNG' 
                 (UNIQUE)
     47    TABLE ACCESS   GOAL: ANALYZED (BY ROWID) OF 'SVCLOC'
     76     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'AK_044_SVCLOC' 
                (UNIQUE)
Received on Fri Jun 20 1997 - 00:00:00 CDT

Original text of this message

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