explain plan for select * from dual model dimension by (dummy ) measures (42 num) () ; select * from dbms_xplan.display(format=>'basic'); -- -- --------------------------------------- -- | Id | Operation | Name | -- --------------------------------------- -- | 0 | SELECT STATEMENT | | -- | 1 | SQL MODEL ORDERED FAST| | -- | 2 | TABLE ACCESS FULL | DUAL | -- ---------------------------------------