SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

function based index not working?

JyshSep 1 2015 — edited Sep 4 2015

select interestrate FROM interest_acc where TO_DATE(:B2,'DD-MM-RRRR') BETWEEN TO_DATE(fromdate,'DD-MM-RRRR') and NVL(ToDate,TO_DATE(:B2,'DD-MM-RRRR')) AND conutercolumn=:B1

above this query i tune using oem they recommendation create function based index

create index fbi_frdt on interest_acc(to_date(fromdate,'DD-MM-RRRR'))

create index fbi_frdt on interest_acc(to_date(ToDate,'DD-MM-RRRR'))

so i created but

my query execution not used index they used full access table.

so can anyone help?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2015

Added on Sep 1 2015

22 comments

3,028 views