Bhuvnesh (12/28/2012)
So here the chosen plan is the stored plan (stored at the time of previous runs) ?
Huh? I already said that the optimiser will not return the previous cached plan (if one exists) if it terminates early.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability