Re: Measuring index usage

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 26 Sep 2000 09:05:06 +0100
Message-ID: <969958077.2130.0.nnrp-12.9e984b29@news.demon.co.uk>

Two problems with that:

First - the supplier will probably say you must not change the indexing.

Second - the supplier MIGHT let you drop an index, and not be aware that one of their developers has written a piece of SQL that (illegally) assumes that the data will return in a given order that happens to be dependent on a specific index.

You need nerves of steel, a fine-tooth comb, and a good text-analysis tool before taking the risk. (Or an exceptionally good supplier).

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Jantah wrote in message ...


>On Mon, 25 Sep 2000 19:20:23 GMT, oratune_at_aol.com wrote:

>

>

>Don't worry, I'll consult the supplier about _every_ change, either

>before or after changing anything. If they don't approve, I won't

>change anything, or revert the changes I made (and let _them_ handle

>the angry users ;-).

>

>--

>Jan

>

>jantah_at_hot.mail.com

>...and you know what to do with "hot.mail", right?

Received on Tue Sep 26 2000 - 03:05:06 CDT