Viewing 2 posts - 1 through 2 (of 2 total)
The similar issue occurs due to parameter sniffing. You may find many explanations about parameter sniffing and different ways to handle it. One of the method is to use "OPTMIZE...
June 1, 2014 at 4:12 pm
#1718092
I did try that... On few occasions i did not get accurate results. And it gives results only from one database i believe
August 12, 2013 at 8:42 am
#1640621