Re: Optimize Query

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 08 Oct 2007 19:48:15 +0200
Message-ID: <5mv8r0Ffe867U2@mid.individual.net>

On 08.10.2007 10:49, valigula wrote:

> On 8 oct, 09:28, valigula <valig..._at_gmail.com> wrote:

>> Hi All,
>> I have a question,
>>
>> I have a Stored Procedure in Oracle 9i, is being call from an ASPX
>> application.
>> When execute from Toad F9 (on toad 8.6, "Execute as Sql" ) the query
>> takes a few minutes but when i call the "Execute immediate" from the
>> ASPX application it gives me Time Out.
>>
>> My question: what are the differences between those two executions??,
>> Has anyone found a similar problem??
>>
>> thansks ..
>>
>> A.

> 
> The query contain many "lower" once i have remove then it is working
> fine.

I suggest you read about "function based indexes". Just in case you discover you need those LOWER in there.

Kind regards

        robert Received on Mon Oct 08 2007 - 12:48:15 CDT