How many is too many
From: Ram Raman <veeeraman_at_gmail.com>
Date: Thu, 11 Aug 2011 15:45:08 -0500
Message-ID: <CAHSa0M1bc8KR-7=aYewB0=PS7UWz1+OrAkZE4g2wPR464qCEeg_at_mail.gmail.com>
Listers,
Date: Thu, 11 Aug 2011 15:45:08 -0500
Message-ID: <CAHSa0M1bc8KR-7=aYewB0=PS7UWz1+OrAkZE4g2wPR464qCEeg_at_mail.gmail.com>
Listers,
I am looking at a table in our system and it has 12 indexes, we are planning on adding another one. I am aware of the effects of having too many indexes, but in this case adding an extra index helps a certain query that runs slow. Other queries and most other operations against the table are acceptable too. I see a few tables like this; is there a number above which is considered a no-no when it comes to adding more indexes.
PS. The tables and queries are structured in a way that seem to require several indexes - it is a third party product.
TIA,
Ram.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 11 2011 - 15:45:08 CDT