Re: How many is too many

From: Morten Egan <oracle_at_dbping.com>
Date: Thu, 11 Aug 2011 23:17:53 +0200
Message-ID: <CAMP1=tuNFJe4CasQP1JTkM3riTn_sP+6ppjfyC554k2bw=2kvA_at_mail.gmail.com>



The number that is considered a no-no, is the number where things start to go unacceptably slow :)

Joking aside, if your program does what it is supposed to do, in an acceptable time, then it really doesn't matter.

2011/8/11 Ram Raman <veeeraman_at_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.
>

-- 
Regards,
Morten Egan
http://www.dbping.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 11 2011 - 16:17:53 CDT

Original text of this message