RE: Data warehouse

>> Herouth Maoz wrote:
>>
>> > Maybe I'm missing the point here, but it seems to me that if
>> > you simply use indices not as key definitions but as query
>> > accelerators (as in "index the living daylights out of"), then
>> > you may as well define a separate index on each and every
>> > field. Why do multiple-field indices in such a case?
>>
>> Why do multi-field indexes? Umm. How about to avoid doing a sequential
>> scan? If your query depends on multiple fields then once you've found
>> the set based on the first index you would have to sequential scan that
>> subset based on the second condition, unless you have a multi-field
>> index.
I suspect that Herouth was being a little facetious here. The bottom line
is that multi-column indices are necessary for indices other than the
primary
key, and shouldn't be limited to seven fields. However, in creating a
database
that can handle more than 7 fields in indices, there is some overhead built
in.
Thus, it should be something that the administrator can decide. There are
normally quite special reasons for wanting more than 7 fields in an index,
and
if you make it a pain to add the functionality to a PGSQL server, then
people will
rather design their dbs properly. However, in those cases where it is
absolutely
necessary, the functionality will at least be available.

And I daresay that this option will be used when compiling a server to
handle
warehouses.

MikeA