|
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 could be the reason. How to improve it?
Thanks in Advance
Ram
|
