CODEWITHSUNDEEP
sqlperformance-estimation
user177777
user177777

Reputation: 9

SQL Server : Estimated Execution Plan

I am using SQL Server Execution plan for analysing the performance of a stored procedure. I have two results with and without the index. In both these results the estimated cost shows the same value (.0032831) but the cost % differs from one another as first, without index is 7% and with Index is 14%.

What does it really means?

Please help me with this.,

Thanks in advance.

Upvotes: 1

Views: 243

Answers (1)

Martin Smith
Martin Smith

Reputation: 453807

It means that the plan without the index is costed as being doubly expensive.

For the first one the total plan cost is .0032831/0.07 = 0.0469, for the second one the total plan cost is .0032831/0.14 which is clearly going to be half that number.

Upvotes: 0

Related Questions