Function based indexes is only a feature in enterprise edtion on oracle 9i
"Robert Klemme" <shortcutter_at_googlemail.com> skrev i en meddelelse
news:5mv8r0Ffe867U2_at_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 Fri Oct 12 2007 - 11:12:45 CDT
