[PERFORM] Query is slow when executing in procedure

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

Re: [PERFORM] Query is slow when executing in procedure

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

Re: [PERFORM] Query is slow when executing in procedure

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.

Re: [PERFORM] Query is slow when executing in procedure

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

Re: [PERFORM] Query is slow when executing in procedure

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