Database Tuning (MOSC)

MOSC Banner

how to read an explain plan

edited Feb 3, 2010 3:06AM in Database Tuning (MOSC) 20 commentsAnswered
 OK. I am not seeing it clearly. Here is my SQL

SELECT a.RECM_ID FROM capp.CRD_ACCT_CNTCT_RECM a, capp.CHAN_ORG_RECM b
 WHERE a.ACCT_NBR=:g1 AND a.RECM_ID = b.RECM_ID
 AND b.RECM_GRP_CDE in ('RW1','RW2','RW3','RW4','RWM');

and here is the explain plan

select plan_table_output from table(dbms_xplan.display('PLAN_TABLE',null,'ALL'))

----------------------------------------------------------------------| Id  | Operation               | Name                   | Rows  | Bytes | Cost  | Pstart| Pstop |
--------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |                        |     1 |    |   1 |  NESTED LOOPS           |                        |     1 |    |*  2 |   TABLE ACCESS FULL     | CHAN_ORG_RECM          |     3 |    |   3 |   PARTITION RANGE SINGLE|                        |     1 |    |*  4 |    INDEX UNIQUE SCAN    | CRD_ACCT_CNTCT_RECM_PK |     1 |    ----------------------------------------------------------------------

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