Missing Indexes

  • Kendra.Little

    SSC Veteran

    Points: 281

    Comments posted to this topic are about the item Missing Indexes

  • HappyGeek

    SSCoach

    Points: 18661

    Excellent question, many thanks Kendra.

    ...

  • George Vobr

    SSCrazy Eights

    Points: 8935

    Great question and clear explanation, thanks Kendra.πŸ™‚

  • Jeff Moden

    SSC Guru

    Points: 994289

    While I absolutely agree with what has been stated in the explanation, the question was (emphasis is mine)...

    How many missing index requests are in the execution plan below, seen in SQL Server Management Studio?

    Even the explanation says you can only see one here. πŸ˜‰  You do have to look elsewhere if you want to see more but, in the "execution plan below", only one is visible.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. πŸ˜‰

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Kendra.Little

    SSC Veteran

    Points: 281

    Jeff Moden - Monday, December 3, 2018 7:51 AM

    While I absolutely agree with what has been stated in the explanation, the question was (emphasis is mine)...

    How many missing index requests are in the execution plan below, seen in SQL Server Management Studio?

    Even the explanation says you can only see one here. πŸ˜‰  You do have to look elsewhere if you want to see more but, in the "execution plan below", only one is visible.

    Ah, but the point is that we can't tell what *is* in the plan based on what is *visible* in the graphic plan.  The question didn't ask what was visible -- it just referenced what is shown in SSMS.

  • Jeff Moden

    SSC Guru

    Points: 994289

    Kendra.Little - Monday, December 3, 2018 7:58 AM

    Jeff Moden - Monday, December 3, 2018 7:51 AM

    While I absolutely agree with what has been stated in the explanation, the question was (emphasis is mine)...

    How many missing index requests are in the execution plan below, seen in SQL Server Management Studio?

    Even the explanation says you can only see one here. πŸ˜‰  You do have to look elsewhere if you want to see more but, in the "execution plan below", only one is visible.

    Ah, but the point is that we can't tell what *is* in the plan based on what is *visible* in the graphic plan.  The question didn't ask what was visible -- it just referenced what is shown in SSMS.

    I beg to differ but "macht nichts".  Heh... it's just proof as to why I hate taking tests.  It's sometimes up to how you try to interpret the meaning that the author of the question was inferring.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. πŸ˜‰

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • HappyGeek

    SSCoach

    Points: 18661

    Jeff Moden - Monday, December 3, 2018 8:03 AM

    I beg to differ but "macht nichts".  Heh... it's just proof as to why I hate taking tests.  It's sometimes up to how you try to interpret the meaning that the author of the question was inferring.

    I think the intent was clear but wholeheartedly agree with Jeff on how questions can be misinterpreted!

    ...

  • chris geswein

    Old Hand

    Points: 372

    Well, I fell trap to semantics. I held tight to the keyword "seen" and all that could truly be seen in what was provided was the one index. Oh well.

  • MattF

    SSCrazy

    Points: 2283

    I agree there is an issue with this question - I think it is one of how much does the poster expect the answerers to know? I knew that that there could be further missing indexes than just the one shown in SSMS - but is that what the poster is looking for? Perhaps they expect minimal knowledge of the topic and are posting an easy question? In that the case then yes, there is only 1 missing index suggestion shown in SSMS.

    I think the question should have been phrased more clearly - testing people should not be about trying to trick them, but seeing how much they know - with clear expectations.

  • Lokesh Vij

    SSChampion

    Points: 10836

    chris geswein - Monday, December 3, 2018 9:00 AM

    Well, I fell trap to semantics. I held tight to the keyword "seen" and all that could truly be seen in what was provided was the one index. Oh well.

    Same here πŸ˜€

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71320

    Nice question, thanks Kendra

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    β€œlibera tute vulgaris ex”

  • Shayn Thomas

    SSCertifiable

    Points: 5392

    nice Q

    Ta

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

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

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