Re: Optimize Query

From: valigula <valigula_at_gmail.com>
Date: Mon, 08 Oct 2007 08:49:50 -0000
Message-ID: <1191833390.718220.26510@v3g2000hsg.googlegroups.com>

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.

Thanks Received on Mon Oct 08 2007 - 03:49:50 CDT