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

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? Say, use all three indexes at the same time, in the same query on the single table?

If so, what is this feature called?

Sorry, I should know this. But mostly I struggle with odd data, and try to create things for the business that the schema was not designed to do. Not much time to read about all the new Oracle features.

Thanks a lot! Received on Wed Nov 05 2008 - 15:32:14 CST