you could look at the Concepts Guide and the Performance documents at http://tahiti.oracle.com for details of the optimizer.

Have a look at index hints also ... you might find that you have to prompt the use of an index to get the optimizer to use it.