I have the following select statement:
select distinct trans_id, 241
from trans
where schedule_date >= sysdate-10/1440
and schedule_date <= sysdate+1/24
The table trans has an index on schedule date, but it doesn't use the index.
I am sure it won't use the index due to the calulation after sysdate, am I right? Or should it be using the index?Thanks.