Bhuvnesh (11/11/2013)
Lynn Pettis (11/11/2013)
The cost values you see in the execution plan are basically arbitrary values.Does this the same case with profiler trace stats too?
Profiler trace doesn't show optimiser costs anywhere.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability