Post reply

Missing Index Hints is...missing.

  • July 13, 2011 at 9:32 am

    #241486

    Hi,

    I have noticed that the Missing Index Hints feature in SQL 2008 is not showing when the execution plans are shown on one of my servers. This happens when using the local SSMS or from a remote SSMS, so it appears it's something on the server. Does anyone know where this can be enabled? From what I have read, it should always show when using SSMS.

    Thanks.

    Craig

  • July 13, 2011 at 9:33 am

    #1352248

    if that server has the SSMS tools installed with SQL 2005, you'll see that issue;

    it's the GUI that decides to show the missing indexes, even though they might actually exist int eh .sqlplan file if you read it as raw text.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 13, 2011 at 9:35 am

    #1352251

    Well it's a new-ish SQL2008 SP1 x86 box so there shouldn't be any 2005 there. I'll have more of a poke about, thanks.

  • July 13, 2011 at 2:19 pm

    #1352454

    That feature is solely a SSMS feature. The exec plans from both 2005 and 2008 have missing index info in them, whether it's displayed or not depends on the version of the client tools. 2005 doesn't, 2008 does.

    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

Viewing 4 posts - 1 through 3 (of 3 total)

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