To access the execution plan for a table:
All-table Scan: Table ACCESS full
ROWID Scan: Table access by user ROWID (ROWID from the user's specified in where condition) or table access by index ROWID (ROWID from index)
Execution plan related to the B-Tree index:
Index unique scanning: index unique scan
Index Range Scan:
Index Full scan: Index
Index fast full scan: Index fast fully scan
Index Hop Scan: Index skip Scan
Execution plan related to bitmap indexing:
Bitmap index single-key-value scan: BITMAP Index One value
Bitmap Index Range Scan: BITMAP Index range scan
Bitmap index Full scan: BITMAP index fully scan
Bitmap index Fast full scan: BITMAP index fast Complete scan
Bitmap Index bitwise with: BITMAP and
Bitmap Index bitwise OR: BITMAP or
Bitmap Index bitwise minus: BITMAP minus
After the bitmap index is used, the result of the last bitmap operation is usually converted into Rowid:bitmap CONVERSION to ROWIDS
Execution plans related to table joins:
Sorting merge joins: Sort join and Merge Join
Nested loops join: NESTED LOOPS
Hash connection: Hash join
Anti-Connection: ANTI
Half Connection: SEMI
Common execution plans for Oracle