Re: Dynamic Query

From: The Magnet <art_at_unsu.com>
Date: Thu, 10 Sep 2009 11:40:28 -0700 (PDT)
Message-ID: <ef73d66d-f6a0-4cb1-acaa-4614b07b2af3_at_37g2000yqm.googlegroups.com>



On Sep 10, 1:24 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> The Magnet wrote:
>
> > Hi,
>
> > We have some applications that put together dynamic queries.  One
> > thing I noticed is that all of the queries put an UPPER function at
> > the end of it, assuming that the value passed will be alphanumeric.
> > Although something like UPPER('123') makes no sense, it does it
> > anyways.
>
> > Is Oracle smart enough to know this and not execute the function
> > call?  I ran a simple query and the plan was exactly the same......
>
> How would not executing this function, modify the plan?

Would it not speed it up, as it would not have to do the function call convert whatever to upper case? Received on Thu Sep 10 2009 - 13:40:28 CDT

Original text of this message