RE: indexing
- From: Jackie Brock <J.Brock@xxxxxxxxxxxxx>
- To: Brian Zelli <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Tue, 19 Feb 2013 16:34:45 +0000
Why not monitor indexes for usage? :)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Taral Desai
Sent: Tuesday, February 19, 2013 9:20 AM
To: Brian Zelli
Cc: oracle-l (oracle-l@xxxxxxxxxxxxx)
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
<Brian.Zelli@xxxxxxxxxxxxxxx>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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Thanks & Regards,
Taral Desai
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
