Re: Can Oracle use Multiple indexes at once on a single table?

dba_222_at_yahoo.com wrote:
> Dear Experts,
>
> Can Oracle use Multiple indexes at once on a single table?
>
> Say we make a single table with multiple indexes on it.
> A single field index on Field_A. Another index on Field_B.
> Another index on Field_C.
>
> And we do a query on the one table, and have filter conditions
> on each of these fields.
>
> I do know in the old versions of Oracle, filters on all three
> fields could only use one index. Oracle would choose the
> best index to use, and filter on one field. Then linear search
> through the subset of records on the other filters.
>
> However, in 10g, can Oracle use multiple indexes at once?

In 9, I've seen "Bitmap conversion from rowids", "bitmap and", and "Bitmap conversion to rowids". I assume 10 still has the capability, but I haven't had the need to look into it. Knowing Oracle they probably named it something different.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
The costs of publication of this article were defrayed in part by the
payment of page charges. This article must therefore be hereby marked
advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
this fact.