Home Forums SQL Server 2005 Administering Stored Procuders which has multiple execution plans RE: Stored Procuders which has multiple execution plans

  • by default query processor generates multiple execution plan for any query that you submit and chooses one of them based on least cost. This is by design and you cannot control it. There are some cases where in if query processor determines that choosing amongst various execution plan is going to take more time, it generates one plan and executes the query as per that plan.

    you can click on include actual execution plan to see what is the plan selected by the query processor.



    Pradeep Singh