Re: Puzzling execution plan

From: <Jared.Still_at_radisys.com>
Date: Thu, 17 Jun 2004 09:10:43 -0700
Message-ID: <OF9CD0B2A5.55348178-ON88256EB6.0058C8A4-88256EB6.0058DD27@radisys.com>

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_at_freelists.org wrote on 06/17/2004 06:33:32 PM:

> Full table scan.
>
> ----- Original Message -----
> From: "Jared Still" <jkstill_at_cybcon.com>
> To: "Oracle-L Freelists" <oracle-l_at_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
> >

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Thu Jun 17 2004 - 11:08:42 CDT