Hi,

Issue resolved, our database has the auto create and update statistics on, so first time it was slow due to statistics creation and thereon since the optimum plan was generated to it use to be very fast.

I am planning to manually update stats to avoid the first time slow execution. Thanks for the suggestion

thanks,

Mrinal