SELECT STATEMENT
is one of the root operations. create table tq84_tab ( id integer, val number, txt varchar2(20) ); explain plan for select * from tq84_tab where txt = 'xyz'; select * from table(dbms_xplan.display(format=>'basic')); -- -- -------------------------------------- -- | Id | Operation | Name | -- -------------------------------------- -- | 0 | SELECT STATEMENT | | -- | 1 | TABLE ACCESS FULL| TQ84_TAB | -- -------------------------------------- drop table tq84_tab;
SELECT STATEMENT REMOTE
.