how to read an explain plan
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 | ----------------------------------------------------------------------