Optimiser choosing Wrong Index
Hello All,
Oracle 9i
I have a query based on three tables, and looks like it is not choosing correct index and taking
long time to execute
1. Here index TRA_IND_CP is chosen and the query takes a very long time.
EXPLAIN PLAN FOR
SELECT SIT_CORR_SIT_ID, SIT_ID
FROM DCSW_OWNER.PEC_ACC_LOCAL P, CRIS.TRA T, CRIS.SIT S
WHERE P.ACC_TYPE = 'LC'
AND P.STATUS = 'P'
AND P.PEC_CLI_ID = 2
AND P.EX_INTRADAY_CASH = 'N'
AND T.TRA_SIT_ID = P.CLI_SIT_ID
AND T.TRA_TRANSACT_TYPE NOT IN ('L', 'Y')
Oracle 9i
I have a query based on three tables, and looks like it is not choosing correct index and taking
long time to execute
1. Here index TRA_IND_CP is chosen and the query takes a very long time.
EXPLAIN PLAN FOR
SELECT SIT_CORR_SIT_ID, SIT_ID
FROM DCSW_OWNER.PEC_ACC_LOCAL P, CRIS.TRA T, CRIS.SIT S
WHERE P.ACC_TYPE = 'LC'
AND P.STATUS = 'P'
AND P.PEC_CLI_ID = 2
AND P.EX_INTRADAY_CASH = 'N'
AND T.TRA_SIT_ID = P.CLI_SIT_ID
AND T.TRA_TRANSACT_TYPE NOT IN ('L', 'Y')
0