how to use index for this query situation?

[xuxc1120]

table:
each col with local index(col1......coln), 
when i select data such as :
select col1,col2 from table where col1="test", the index works,
but if there are 2 or more conditions after "where" clause,the query will full 
scan the table;
is there any way to use index for such query?


thanks.
xuxc