查询优化
依据:查看sql执行计划
EXPLAIN PLAN FOR
SELECT * FROM T_USER1 t where t.user_name = 'Admin';
SELECT * FROM TABLE(dbms_xplan.display);
执行计划的结果查看
查询优化
依据:查看sql执行计划
EXPLAIN PLAN FOR
SELECT * FROM T_USER1 t where t.user_name = 'Admin';
SELECT * FROM TABLE(dbms_xplan.display);
执行计划的结果查看