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;