MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

Re: table indexes



fixed

On 10-Jul-2014 13:16 -0500, Dave wrote:

I have a table with an index already on Columns 1, 2, 3 and 4.

Now I've been told we need another one on Columns 1, 2 and 3.

Is that necessary? I don't see why.


Likely the second is redundant, but as the party being "told", the /need/ is indeterminate without further discussion; what you do or "don't see" with regard to "why" may not be relevant, yet there may be value in consulting with whomever originated the request, about their reasoning for an apparent redundant definition.

There are a variety of nuanced reasons for which some seemingly redundant INDEX [or simply Access Path] definitions are desirable separately; possibly even for more reasons, may be desirable as separate database *FILE objects. If the second merely effects a /shared/ access path of the first, then there is [effectively no additional performance impacts [i.e. only the original AccPth is /maintained/ for insert and update] and there is [effectively] no additional storage requirements [effectively just the additional storage for the *FILE and the *MEM objects], so its addition is unexceptional beyond a separate entity to track.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact