Post reply

Indexes

  • January 19, 2011 at 6:54 am

    #142180

    Hi,

    Why indexes are missing in a Database,when we perform DML operations?

    subha

  • January 19, 2011 at 7:02 am

    #1275279

    I'm not sure I understand the question. Did you actually create the indexes? If so, are you sure they actually created and didn't just error out?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 19, 2011 at 7:06 am

    #1275283

    Are you talking about the warnings in the execution plan that creating extra indexe(s) would improve performance?

  • January 19, 2011 at 7:15 am

    #1275292

    Hi,

    Iam asking why indexes are missing?

    How?

    Subha

  • January 19, 2011 at 7:18 am

    #1275295

    An index can't be missing.

    Are you talking about an index you created and now is deleted?

  • January 19, 2011 at 7:21 am

    #1275300

    Missing in what context?

    What makes you think an index is missing?

    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

  • January 19, 2011 at 7:30 am

    #1275304

    subha.mcts2005 (1/19/2011)

    I am asking why indexes are missing?

    As the others have indicated, you need to give us more information. How did you find out indexes were missing? What process, error message, job or query made you think you have missing indexes?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 19, 2011 at 7:35 am

    #1275309

    ok,

    what is the purpose of Missing indexes feature in sql server 2005?

    i didn't understand the missing indexes concept properly.

    is there any chance to missing indexes in a Database?

    if Yes!

    please let me know.

  • January 19, 2011 at 7:40 am

    #1275311

    The Missing Index feature of SQL Server is just recommendations by the server and is not necessarily something to follow. Sometimes, based on bad statistics and other stuff, it can completely steer you in the wrong direction.

    Look at the recommendations with a grain of salt, and test a few of them in your Dev db to see if they help, hinder, or do nothing. If the later two, ignore the recommendations. If the former, then by all means add the index in question. But don't go adding all the indexes recommended by SQL Server because you'll likely hose your performance.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 19, 2011 at 7:41 am

    #1275312

    I'd start by reading this if I were in your shoes:

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    A "missing" index is an index that if created, could improve performance.

    The article link shows you how to find problem queries in your system and 1 exemple of how to fix it.

Viewing 10 posts - 1 through 9 (of 9 total)

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