Re: search in a B+ tree with secondary index

Yes, the index will be used if the optimizer thinks it is efficient to use. Yes, in a multi column index the leading columns can be searched on. Jim
"Xe Neve" <xeneve_at_hotmail.com> wrote in message news:%dYy8.1613$sh6.263655_at_news20.bellglobal.com...
> 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 - 22:12:26 CEST