Whta is the difference between
1).INDEX RANGE SCAN 2.)INDEX FAST FULL SCAN 3.)TABLE ACCESS BY INDEX ROWID
3) Using EXPLAIN PLAN Table 12-3 OPERATION and OPTIONS Values Produced by EXPLAIN PLAN
Are differents ways to access to the row. Which is better? It depends.
HTH - Antonio NAVARRO