Gokul wrote:
> 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
EXPLAIN PLAN
Post it.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Sep 09 2007 - 11:58:13 CDT
