| 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
![]() |
![]() |