Re: indexing

From: Taral Desai <>
Date: Tue, 19 Feb 2013 10:19:59 -0600
Message-ID: <>

Well. this might be too much but still depends. You need to provide some more information Like
1. How many approximately rows this table has
2. No. of columns
3. How frequently int's updated/deleted or data is inserted.
4. What kind of indexes it has and what are the layout

And most importantly is you need to ask Is this index is going to help some query if so then can it be combined with other index.

So, it's not easy to answer this question without any information.

On Tue, Feb 19, 2013 at 10:08 AM, Zelli, Brian <>wrote:

> I have developers who are able to create indexes thru their application
> builder. On one table they have 30 indexes. I've often said to them that
> they are creating too many but I get overruled by their manager. Are they
> creating too many? Can oracle handle many, many indexes? Is there a way
> I can at least minimize any depreciation of performance if they are going
> to be allowed to do this?
> ciao,
> Brian
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
> --


Thanks & Regards,
Taral Desai

Received on Tue Feb 19 2013 - 17:19:59 CET

Original text of this message