Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Explain Plan Question
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