R

Hi

I am using SQL Server 2005 Enterprise Edition. On this friday i was doing performance tunning for one if queries where i found that Estimated Execution Plan Costs Greater Than 100%.

On http://support.microsoft.com/kb/274643/en-us#appliesto MS says that it applies to

?

Microsoft SQL Server 7.0 Standard Edition

?

Microsoft SQL Server 2000 Standard Edition

Does any one knows if it's issue with SQl Server 2005 as well?

Regards;
Rakesh

Execution plans are never exact and will probably always have rounding errors which make it add up to greater than 100%.

They are only useful to find the parts of the query which have the largest cost, not for the total percentages.|||

Hi

I my case it's more than 200% :(

Regards;
Rakesh

|||It is a bug. Please file one with repro scripts at http://connect.microsoft.com/sqlserver.