When Oracle has a choice of more than one index to use to select rows from the driving table, it will use the most recently created index.