O'Reilly logo
  • Lucas Reis thinks this is interesting:

Indexes aren't free; they consume disk space and database processing resources. Creating an index can actually have a detrimental performance impact if the index is infrequently or never used.

From

Cover of Pro Oracle Database 11g Administration

Note

Problem with indexes