create table tq84_tab ( val number, grp varchar2(5) ); explain plan for select * from tq84_tab ; select * from table(dbms_xplan.display(format=>'basic')); -- -- -------------------------------------- -- | Id | Operation | Name | -- -------------------------------------- -- | 0 | SELECT STATEMENT | | -- | 1 | TABLE ACCESS FULL| TQ84_TAB | -- -------------------------------------- drop table tq84_tab;
TABLE ACCESS FULL
is INDEX FAST FULL SCAN
which is used if all referenced columns of a table are found in an index.