SELECT * FROM TEST
WHERE OBJECT_ID = :B2 AND :B1 >= DAYTIME AND :B1 < NVL(END_DATE,:B1 +1)
so when I run SQL tuning advisor, below is what OEM found:
The predicate NVL("TEST"."END_DATE",:B1+1)>:B2 used at line ID 1 of the execution plan contains an expression on indexed column "END_DATE". This expression prevents the optimizer from efficiently using indices on table "BLAH"."TEST".
1. how OEM picked NVL("TEST"."END_DATE",:B1+1)>:B2
2. what does OEM really recommend to improve the query?