ORACLE 查看执行计划

EXPLAIN PLAN for SELECT count(*) AS "totalCnt"
FROM TRADE t
WHERE 1 = 1 AND t.CRT_TIME >= to_date('2016-01-10 00:00:00', 'yyyy-MM-dd hh24:mi:ss') AND t.CRT_TIME <= to_date('2016-09-10 23:59:59', 'yyyy-MM-dd hh24:mi:ss');

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);