Question on 8.1.7

Hello,

We hit a strange problem on version 8.1.7.

select col1,col2,col3 from tab1,view1,tab2.. where col5 >= '08-Sep-07'

select col1,col2,col3 from tab1,view1,tab2.. where col5 >= to_date(to_char(sysdate-1,'YYYYMMDD'),'YYYYMMDD')

These two queries behave differently. The first one takes less than 2 secs and the second one takes 15 minutes.

I dont have more details. Just trying my luck here to check if someone has faced such problem in the past.

Any ideas ?

PS: '08-Sep-07' and (sysdate - 1) are same.

Rgds,
Gokul Received on Sun Sep 09 2007 - 11:20:36 CDT