Post reply

too many indexes - question

  • August 6, 2015 at 12:23 pm

    #319561

    Team:

    Can you tell me the disadvantage of having too many indexes

  • August 6, 2015 at 12:40 pm

    #1817956

    Check this, it should cover the all.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • August 7, 2015 at 4:27 am

    #1818047

    The main issue is that you'll be slowing down performance of INSERT/UPDATE/DELETE queries to maintain all your indexes. The "too many" label can be hard to define. If you need, and use, six indexes, is that too many?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 7, 2015 at 10:12 am

    #1818197

    Grant is right on the main issue. Secondary ones are more disk space, potentially lots more. Some systems have more index data than real data.

    Also, slows down backup/restore with more space.

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

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