
-- gb_1a.sql

set autotrace off echo off

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

l

/

@showplan_last

