Re: Dynamic Query

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



The Magnet wrote:
> 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?

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 - 14:42:32 CDT

Original text of this message