Oracle SQL Plan operation: TABLE ACCESS SAMPLE

create table tq84_smp as
select
   level id,
   dbms_random.string('a', 10) txt
from
   dual connect by level <= 1000;

explain plan for
select
   *
from
  tq84_smp sample(1);

select * from dbms_xplan.display(format=>'basic');
--
-- ----------------------------------------
-- | Id  | Operation           | Name     |
-- ----------------------------------------
-- |   0 | SELECT STATEMENT    |          |
-- |   1 |  TABLE ACCESS SAMPLE| TQ84_SMP |
-- ----------------------------------------

drop table tq84_smp;