Just wanted to say a heartfelt thanks for this support and solution, and to apologise again for the mistake with the hijack on the post.

Your solution has solved the issue...

Ok thanks.  I will do that now.

Double posted

• This reply was modified 10 months, 3 weeks ago by paul27uk. Reason: Dupe

I have a question, and it comes up where I work a lot and finding a way to process through like the above feels like a challenge for me.

It's the...

vidya_pande (3/18/2010)

---

Execution plan is prepared based on indexes on table. It depends on the memory availability whether it will keep in memory or not.

If the plan is cached in memory...