Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Indices
If I have a multi-column index on a table, and I only use a subset of the index's columns in a query, will the index be used? What are the rules?