Hi Gurus, Will to many indexes on a table/view adversely affect performance on queries? Thanks!
Hemant
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
Forum Rules