i need a help. i have a query which took around 2 days to complete .
i have tuned a query by creating some index.
one such index is on date field. the query is written in one of the xml file.
date_terminated = :from_date
but the field is not using an index. the reason is if i use date_terminated ='01-APR-2013' only then it will use index .
but the thing is i am submitting a concurrent program and date i am giving is 01-APR-2013 but it is taking 01/04/2013 00:00:00
any idea on this ?
select contract_number ,start_date from view1
where date_terminated <=:from_date;
view 1-> select * from view2;
view2-> select * from tab3;
in tab3 i have index on id and date_terminated.
i want to use my main query to use this index but it is not. any way out.
cannot recreate the view :(