Re: Dynamic Query

From: Gerard H. Pille <>
Date: Thu, 10 Sep 2009 21:42:32 +0200
Message-ID: <4aa956a6$0$2868$>

The Magnet wrote:
> On Sep 10, 1:24 pm, "Gerard H. Pille"<> 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?

It would save executing that function only once. I will need very precise measuring techniques to notice the differenc. Received on Thu Sep 10 2009 - 21:42:32 CEST

Original text of this message