
-- gb_1b.sql

set autotrace off echo off

select   deptno, count(*)
from (
	select  /*+ gather_plan_statistics */ deptno
	from scott.emp
	order by deptno
) e
group by deptno

l

/

@showplan_last


