Filter predicate seems unnecssary
Hi,
there is an index:
CREATE INDEX I_AMS_HIS_PTF_VAL$4 ON AMS_HIS_PTF_VAL
(C_FUND, D_NAV, C_N_ACC, C_INVEST_CCY, A_MARKET_VALUE, N_SUFF)
And a query:
select "C_FUND","D_NAV","A_MARKET_VALUE","C_INVEST_CCY","C_N_ACC","N_SUFF"
FROM "AMS_HIS_PTF_VAL" "AAA" WHERE
"A_MARKET_VALUE">0 AND
"D_NAV">to_date(:N1, 'MM/DD/YYYY HH24:MI:SS')-120 AND
"C_FUND"=:N2 AND
"C_INVEST_CCY"=:N3 AND
"C_N_ACC"=:N4 AND
"N_SUFF"=:N5;
Now I see in the plan (dbms_xplan.display_cursor):