concern... wishlist item...

[Fairlight]

At Tue, Sep 26, 2006 at 07:18:37PM -0400 or thereabouts, 
suspect Kenneth Brody was observed uttering:
> 
> I would suggest that having indexes built differently, depending on
> which qualifier you're in, is a "Bad Thing[tm]".
> 
> For example, having indexfoo.A built on last_name and indexbar.A built
> on zipcode makes no sense to me, nor would I suspect that it would make
> sense to anyone else.

I can think of a situation in which it may make sense.

People have claimed there are an insufficient number of automatic indexes
for quite some time.  Is it not quite possible that someone wrote a
database that uses qualifiers to store identical data, but with all but one
index differing?  This would in effect give you unlimited indexes, although
at the cost of multiplying your storage space by the number of times plus
one that you need more than 16 indexes.

Just one thought off the cuff on why it might actually make sense
somewhere, in some context.

mark->
-- 
Try our new SPF-0 lotion, SunScream[tm].  Get it while it's hot!