DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Too many indexes?

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi Gurus,

    Will to many indexes on a table/view adversely affect performance on queries?

    Thanks!
    Hemant

  2. #2
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    It might affect the DML operations as it has to update all the indexes during DML operations.

    In fact, queries would get boost up if you have indexes with the columns, which are part of your joins in the where clause.

    Hope this helps.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width