execution plan

• CooLDBA

  Hall of Fame

  Points: 3301

  More actions

  November 10, 2004 at 5:08 pm

  #109333

  Can someone explain to me what is the meaning of the percentage % after you did a show execution plan like Cost 100% or 96% or 4% or 0%. Lower Cost % is better???

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 11, 2004 at 1:08 am

  #529726

  This might give you a start:

  http://www.sql-server-performance.com/query_execution_plan_analysis.asp

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• CooLDBA

  Hall of Fame

  Points: 3301

  More actions

  November 12, 2004 at 12:51 pm

  #529998

  Thanks for the link but in the article it didn't explain what the cost really mean.