SQL Server Performance

About Execution Plan

Discussion in 'SQL Server 2005 General Developer Questions' started by shankbond, Dec 3, 2009.

  1. shankbond New Member

    Hi,
    Can anyone please explain these terms coming in the excecution plan.
    Physical Operation
    Logical Operation
    Estimated I/O cost
    Estimated CPU cost
    Estimated Subtree cost
    Actual Rebinds
    Actual Rewinds
    Estimated Rowsize
    Node Id
    I want to optimise my table structure, also suggest which values should be low for a better performance?
    shankbond, Dec 3, 2009
    #2

  2. FrankKalis Moderator

    FrankKalis, Dec 4, 2009
    #3

  3. satya Moderator

    satya, Dec 7, 2009
    #4

  4. balaganapathy.n New Member

    you may find the book, [Dissecting SQL Server Execution Plans] by Grant Fritchey useful.http://www.amazon.com/Dissecting-Server-Execution-Plans-ebook/dp/B0018PCIFG
    balaganapathy.n, Jan 2, 2010
    #5

Share This Page