From oracle-l-bounce@freelists.org Thu Jun 17 11:08:42 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5HG8Ro30263 for ; Thu, 17 Jun 2004 11:08:37 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5HG8G630224 for ; Thu, 17 Jun 2004 11:08:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7039672C229; Thu, 17 Jun 2004 10:52:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20620-56; Thu, 17 Jun 2004 10:52:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A835772C34C; Thu, 17 Jun 2004 10:52:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 17 Jun 2004 10:50:20 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA3A072C1EE for ; Thu, 17 Jun 2004 10:50:17 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18966-97 for ; Thu, 17 Jun 2004 10:50:17 -0500 (EST) Received: from mx10.radisys.com (mx10.radisys.com [206.102.10.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7AF4872C35D for ; Thu, 17 Jun 2004 10:50:17 -0500 (EST) Received: by mx10.radisys.com (Postfix, from userid 5) id 6916A142DF3; Thu, 17 Jun 2004 09:10:52 -0700 (PDT) Received: from UNKNOWN(206.103.52.194), claiming to be "dcblackberry.radisys.com" via SMTP by mx10, id smtpdAAArz.3M_; Thu Jun 17 09:10:45 2004 In-Reply-To: <001201c454d4$4458b280$6401a8c0@dilbert> To: oracle-l@freelists.org Subject: Re: Puzzling execution plan MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.1 January 21, 2004 Message-ID: From: Jared.Still@radisys.com Date: Thu, 17 Jun 2004 09:10:43 -0700 X-MIMETrack: Serialize by Router on DCBlackBerry/Radisys_Corporation/US(Release 6.0.3|September 26, 2003) at 06/17/2004 09:04:14 AM, Serialize complete at 06/17/2004 09:04:14 AM Content-Type: multipart/alternative; boundary="=_alternative 0058DD2488256EB6_=" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2888 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jared.Still@radisys.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --=_alternative 0058DD2488256EB6_= Content-Type: text/plain; charset="US-ASCII" Thanks Don. I've seen differences in execution plans with to_date() versus date literals, though I think it was on 8i, not 9i. Jared oracle-l-bounce@freelists.org wrote on 06/17/2004 06:33:32 PM: > Full table scan. > > ----- Original Message ----- > From: "Jared Still" > To: "Oracle-L Freelists" > Sent: Sunday, June 13, 2004 12:28 PM > Subject: Re: Puzzling execution plan > > > > On Sat, 2004-06-12 at 13:17, Don Granaman wrote: > > > > > (Oracle 9.2.0.4) This doesn't make sense to me... > > > > > > Query 2: select PK_ID from MYTAB where INSERT_DATE > > > > to_date('11-JUN-2004','DD-MON-YYYY') > > > > > > Don, > > > > What kind of execution plan do you get with > > select PK_ID from MYTAB where INSERT_DATE > date '2004-06-11'; ? > > > > > > Jared > > --=_alternative 0058DD2488256EB6_= Content-Type: text/html; charset="US-ASCII"
Thanks Don.

I've seen differences in execution plans with to_date() versus date literals,
though I think it was on 8i, not 9i.

Jared


oracle-l-bounce@freelists.org wrote on 06/17/2004 06:33:32 PM:

> Full table scan.
>
> ----- Original Message -----
> From: "Jared Still" <jkstill@cybcon.com>
> To: "Oracle-L Freelists" <oracle-l@freelists.org>
> Sent: Sunday, June 13, 2004 12:28 PM
> Subject: Re: Puzzling execution plan
>
>
> > On Sat, 2004-06-12 at 13:17, Don Granaman wrote:
> >
> > > (Oracle 9.2.0.4) This doesn't make sense to me...
> > >
> > > Query 2:  select PK_ID from MYTAB where INSERT_DATE >
> > > to_date('11-JUN-2004','DD-MON-YYYY')
> >
> >
> > Don,
> >
> > What kind of execution plan do you get with
> >  select PK_ID from MYTAB where INSERT_DATE > date '2004-06-11';  ?
> >
> >
> > Jared
> >
--=_alternative 0058DD2488256EB6_=-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------