RE: indexing

From: Jackie Brock <>
Date: Tue, 19 Feb 2013 16:34:45 +0000
Message-ID: <>

Why not monitor indexes for usage? :)

-----Original Message-----
From: [] On Behalf Of Taral Desai Sent: Tuesday, February 19, 2013 9:20 AM To: Brian Zelli
Cc: oracle-l ( Subject: Re: indexing

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:34:45 CET

Original text of this message