• 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass