@Grant Fritchey

Thanks Grant and hope you are doing well, we had chats several times some time back.

I have one query if we want to force the sql server to use the same plan will it give some performance ? what will be options in front of me. The procedure runs little faster after intial compilation , how can we avoid recompilation on this procedure or any method we can achieve the same.

Anyway we are trying to break down the proc, but we need an immediate solution to satisfy some non technical management people over here, so atleast a temporary solution will suffice for now will get some time window to break down the proc and investigate on the same.

Thanks

MJ