Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disadvantages of excessive indexes

USER101Apr 15 2008 — edited Feb 25 2010
Guys,

I am writing a paper that outlines disadvantages excessive use of indexes or other indexes. I found these points.

Do you think i've missed any ?

Indexes consume disk space
Excessive use of indexes can pay serious performance penalty
And Queries can use wrong index plans, causing the queries to slow down

Anything else you think can be added ?

Cheers
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2010
Added on Apr 15 2008
14 comments
4,420 views