search in a B+ tree with secondary index

I cannot find the answer in the Oracle documentation (http:// download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a88856/c11schem. htm#3239) or in a search with google. And this must be easy to solve for most of you experts.

I need to do an applet that make some SQL queries to a Oracle db. One of them is to query an indexed table. It is a secondary index and the key is on multiples columns: {command, article}. I guess the index was created with something like:

create index i on commands(command, article);

I need to do a query of the form:

select * from commands where command = 10;

And i need to know if the index will be internally used to perform the query or all the table will be scanned. In other words, is it possible to use a single column to perform a search in a multiple columns index?

Thanks, X. Received on Sun Apr 28 2002 - 21:39:28 CEST