indexing
From: Zelli, Brian <Brian.Zelli_at_RoswellPark.org>
Date: Tue, 19 Feb 2013 16:08:47 +0000
Message-ID: <7DCF5A73984B85409A1FB7B957E590ED347C043E_at_EXMB4wsh.roswellpark.org>
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
Date: Tue, 19 Feb 2013 16:08:47 +0000
Message-ID: <7DCF5A73984B85409A1FB7B957E590ED347C043E_at_EXMB4wsh.roswellpark.org>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 19 2013 - 17:08:47 CET