Oracle db would decide whether it needs full table scan or use indexes based on certain set parameters.