Execution Plan

• peloke

  SSC-Addicted

  Points: 409

  More actions

  June 7, 2002 at 3:50 am

  #58268

  Could someone tell me how sql server decides what query plan to use? We looked at a select statement at work that had several joins and date ranges. It was taking several minutes to run. We were trying to clean it up and we took out a few 'upper' statement not thinking it would do anything. The query now returns in a matter of seconds. The Execution plan is completely different for the two queries. Why would an 'upper' cause a different execution plan and such different performance?

  Thanks,

  Eddie

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 7, 2002 at 5:27 am

  #430496

  Please do not crosspost. Responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4682&FORUM_ID=23&CAT_ID=2&Topic_Title=execution+plan%3F&Forum_Title=General

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)