distinguish single-block vs multi-block reads in Oracle explain plan If I am looking at a query plan in Oracle 11g, is there any way I can tell which operations will result in single-block reads and which will result in multi-block?
TABLE ACCESS FULL and INDEX FAST FULL SCAN use multi-block I/O, other kind of access paths use single-block I/O.