Oracle SQL Plan operation: MATCH RECOGNIZE

create table tq84_test_data (id integer, letter char(1));
insert into tq84_test_data
select
   level,
   chr(64+level)
from
   dual connect by level < 10;

explain plan for
select
   *
from
   tq84_test_data
match_recognize (
   order by id
   measures
      first(id    ) as id,
      first(letter) as letter
   pattern(ptrn*)
   define
      ptrn as 1=1
);

select * from dbms_xplan.display(format=>'basic');
--
-- -------------------------------------------------------------------------------
-- | Id  | Operation                                            | Name           |
-- -------------------------------------------------------------------------------
-- |   0 | SELECT STATEMENT                                     |                |
-- |   1 |  VIEW                                                |                |
-- |   2 |   MATCH RECOGNIZE SORT DETERMINISTIC FINITE AUTOMATON|                |
-- |   3 |    TABLE ACCESS FULL                                 | TQ84_TEST_DATA |
-- -------------------------------------------------------------------------------