Post reply

Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

  • February 26, 2014 at 11:06 pm

    #1692530

    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

  • February 26, 2014 at 11:06 pm

    #1692531

    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

  • March 11, 2014 at 10:21 am

    #1696058

    second this.

  • January 8, 2016 at 12:16 pm

    #1850641

    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

  • February 23, 2016 at 11:03 pm

    #1860627

    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 19 (of 19 total)

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