Search notes:
Oracle SQL Plan operation INDEX FULL SCAN (MIN/MAX)
create table tq84_tab (
id varchar2(10) not null,
val number(4,1) not null,
--
constraint tq84_tab_pk primary key (id)
);
insert into tq84_tab
select
dbms_random.string('U', 2) || '.' || to_char(level, 'fm99999'),
dbms_random.value(1, 999)
from
dual connect by level <= 10000;
begin
dbms_stats.gather_table_stats(user, 'tq84_tab');
end;
/
explain plan for
select
max(id)
from
tq84_tab
;
select * from table(dbms_xplan.display(format=>'basic'));
--
-- --------------------------------------------------
-- | Id | Operation | Name |
-- --------------------------------------------------
-- | 0 | SELECT STATEMENT | |
-- | 1 | SORT AGGREGATE | |
-- | 2 | INDEX FULL SCAN (MIN/MAX)| TQ84_TAB_PK |
-- --------------------------------------------------
drop table tq84_tab;