--创建执行计划
explain plan for select * from users where id=336538
explain plan for select * from users partition(part_2012) where id=336538
--查看计划执行情况
select * from table(dbms_xplan.display)
explain plan for select * from users where id=336538
explain plan for select * from users partition(part_2012) where id=336538
--查看计划执行情况
select * from table(dbms_xplan.display)