Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

  • SQLRNNR

    SSC Guru

    Points: 281205

    OldCursor (2/25/2014)


    Thanks Grant

    Now . . . if you enjoy it so much perhaps you could pop round and sort out my clients problems - it would save all that studying.

    Is that an open invitation? 😀

    Execution plans and internals can be a load of fun.:cool:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281205

    Nice job Darren.

    Nice clarifications by Grant.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • liver.larson

    SSC Veteran

    Points: 236

    second this.

  • Robert Sterbal

    SSChampion

    Points: 10969

    Grant Fritchey (2/25/2014)


    The Execution Plans book is free as a download from here[/url] if you don't want a paper copy.

    Thank you!

    412-977-3526 call/text

  • etheral1980

    SSC Enthusiast

    Points: 151

    When you wrote low selectivity maybe you meant high selectivity? It is when optimizer can decide to scan the index/table, because result set is large in % terms ?

Viewing 5 posts - 16 through 20 (of 20 total)

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