Search notes:

Oracle SQL Plan operation: SELECT STATEMENT

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;

See also

Other plan operations such as SELECT STATEMENT REMOTE.

Index