Re: how come oracle is using only one of my indexes?

In article <dc7ccafd.0107231136.5952d415_at_posting.google.com>, turboridelover_at_yahoo.com says...
>
>I have a table with 12 columns, and there is an index on each of them.
> Now I have a query that involves all the 12 columns. However, oracle
>only makes use of one of the indexes. Why is it? What should I do to
>make oracle uses more of my indexes?
>
>Thank you.

lets see a simple example of your table, indexes and the type of query you use. version information, whether you collect stats|not, what optimizer goal you use, etc are very useful as well.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp