Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Query cost   (RSS)

What's this cost?

Oftentimes when people include actual execution plan (Ctrl-M, see previous posts for a good primer on execution plans) while executing a batch in SQL Server Management Studio, and they see this "Query cost (relative to the batch)" thing on top of each query in the batch, they start to ask: What does this mean? But when I run this batch, the first query runs a faster than the second, and yet this crazy SQL Server says the second has a higher cost, what are they talking about?
Posted by queryproc | 2 Comments
Filed under: ,

Attachment(s): ExecutionPlan.JPG
 
Page view tracker