Execution Plan

  • Good Day, I sometime see in the Execution plan's output it displays the solution chk**** . what does this chk*** mean ? Should I pay any attention to it ?

    Thanks .

    Lian

  • In what context and where?

    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
  • What kind of execution plan are you seeing that in? A graphical plan, a text plan or something else?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • It is in the graphic execution plan where one clicks on an icon e.g tablescan or index scan.

  • And you see that where, in the properties? No, I can't say that's one I've run into. It sounds like something might be broken. Can you save the execution plan to a .sqlplan file and post here?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply