Using the My Oracle Support Portal (MOSC)

MOSC Banner

Please explain how to avoid TABLE ACCESS BY INDEX ROWID.

edited Feb 26, 2015 4:37AM in Using the My Oracle Support Portal (MOSC) 4 commentsAnswered ✓

HI

Please explain how to avoid TABLE ACCESS BY INDEX ROWID.

Please find the query and explain plan.

IdOperationNameRowsBytesTempSpcCost (%CPU)TimePstartPstopTQIN-OUTPQ Distrib
0SELECT STATEMENT 1263 (100)
1   PX COORDINATOR
2     PX SEND QC (ORDER):TQ100022071K215M 1263 (2)00:00:16 Q1,02P->SQC (ORDER)
3       SORT ORDER BY 2071K215M289M1263 (2)00:00:16 Q1,02PCWP
4         PX RECEIVE Q1,02PCWP
5           PX SEND RANGE:TQ10001 Q1,01P->PRANGE
6             FILTER Q1,01PCWC
7               NESTED LOOPS Q1,01PCWP
8                 NESTED LOOPS 2071K215M 1245 (1)00:00:15 Q1,01PCWP
9                   BUFFER SORT Q1,01PCWC
10                     PX RECEIVE Q1,01PCWP
11                       PX SEND ROUND-ROBIN:TQ10000 S->PRND-ROBIN
12                         TABLE ACCESS BY INDEX ROWID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center