Dear all,
The query is slow when executing in the stored procedure(it is taking
around 1 minute). when executing as a sql it is taking 4 seconds.
basically i am selecting the varchar column which contain 4000 character. We
have as iindex on the table. We have analyzed the table also. What cou
2009/11/24 ramasubramanian :
> Dear all,
> The query is slow when executing in the stored procedure(it is taking
> around 1 minute). when executing as a sql it is taking 4 seconds.
> basically i am selecting the varchar column which contain 4000 character. We
> have as iindex on the table. We h
In response to ramasubramanian :
> Dear all,
> The query is slow when executing in the stored procedure(it is taking
> around 1 minute). when executing as a sql it is taking 4 seconds.
> basically i am selecting the varchar column which contain 4000 character. We
> have as iindex on the table.
Thanks a lot Pavel . i will try it .
- Original Message -
From: "Pavel Stehule"
To: "ramasubramanian"
Cc:
Sent: Tuesday, November 24, 2009 11:40 AM
Subject: Re: [PERFORM] Query is slow when executing in procedure
2009/11/24 ramasubramanian :
Dear all,
Th
Thanks a lot Kretschmer. i will try it .
Regards,
Ram
- Original Message -
From: "A. Kretschmer"
To:
Sent: Tuesday, November 24, 2009 11:45 AM
Subject: Re: [PERFORM] Query is slow when executing in procedure
In response to ramasubramanian :
Dear all,
The query is