Re: Creating Indexes

From: Greg Stark <greg-spare-1_at_mit.edu>
Date: Thu, 18 Nov 1999 04:19:05 GMT
Message-ID: <87pux8mnys.fsf@HSE-Montreal-ppp19485.qc.sympatico.ca>

"Steve McDaniels" <steve.mcdaniels_at_sierra.com> writes:

> The fastest possible INDEX strategy (in this context) is to index each field
> separately.

why is this useful? I have queries that use two or three fields each of which are indexed separately but Oracle just does a range scan using one of them ignoring the rest. I would love to be able to combine multiple indexes but I can't see how Oracle could do that with B-tree indexes. Can it?

--
greg Received on Wed Nov 17 1999 - 22:19:05 CST