Search notes:

Oracle SQL Plan operation SORT ORDER BY

create table tq84_tab (
   id    number,
   val   varchar2(10)
);

insert into tq84_tab
select
   mod(rownum * 7, 11),
   rpad('*', rownum, '*')
from
   dual connect by level <=10;

explain plan for
select * from tq84_tab order by id;

select * from table(dbms_xplan.display(format=>'basic'));
--
-- ---------------------------------------
-- | Id  | Operation          | Name     |
-- ---------------------------------------
-- |   0 | SELECT STATEMENT   |          |
-- |   1 |  SORT ORDER BY     |          |
-- |   2 |   TABLE ACCESS FULL| TQ84_TAB |
-- ---------------------------------------

drop table tq84_tab;

See also

Plan operations

Index