
-- gb_4.sql
-- derived from 7-8

set autotrace on statistics

with emps as (
	select /*+ gather_plan_statistics */ 
		ename
		, deptno
	from scott.emp
	group by cube(ename,deptno)
)
select rownum
	, ename
	, deptno
from emps

l

/

@showplan_last
