Re: Question on 8.1.7

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 09 Sep 2007 18:55:33 +0200
Message-ID: <fc1dc9$dfb$1@news4.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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
>

What is the data type of col5? Is it varchar2 or date? (or :shock: something different than that?!?)

Oh, and '08-sep-07' is *not* the same as (sysdate - 1), just so you know. Anything between quotes is called string. A date is not a string. (but can be presented as a string).

Do you understand why your queries behave differently now? - --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG5CWFLw8L4IAs830RAoESAJ4ygXGLNxyPxtglV67AkG3oN52+AwCeLvln Q+GYXjIW4TskXvte0y8E2tc=
=Kp59
-----END PGP SIGNATURE----- Received on Sun Sep 09 2007 - 11:55:33 CDT