Too many indexes?

Hi Gurus,

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

Thanks!

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.