sqlnes (1/16/2013)
Could anyone get idea of why SQL Server did not use the "correct" plan as the one when FORCEPLAN was set ON?
from BOL SQL Server query optimizer processes a join in the same order as the tables appear in the FROM clause of a query. So thats the reason the selected plan didnt provide optimal performance.
Also post the index definition along with opc.three request.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)