SQL Performance (MOSC)

MOSC Banner

Filter predicate seems unnecssary

edited May 5, 2014 12:00PM in SQL Performance (MOSC) 5 commentsAnswered

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):

Tagged:

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