Xplain plan of a sql statement - oracle database script

-- Generate explain plan -- Syntax EXPLAIN PLAN FOR < SQL STATEMENT> ; explain plan for select count(*) from aodba; -- View explain plan  select * from table(dbms_xplan.display);