EXPERT RESPONSE
Your query uses a character string value for TRDATE, whose datatype is DATE; Oracle performs an implicit datatype conversion, which means that the index can't be used. Change the last clause in your query to
c.trdate between to_date('01-jun-05','dd-mon-yy')
and to_date('12-jun-05','dd-mon-yy')
AND d.roster_date between to_date('01-jun-05','dd-mon-yy')
and to_date('12-jun-05','dd-mon-yy')
|