ANALYZE TABLE T COMPUTE STATISTICS;
ANALYZE TABLE T ESTIMATE STATISTICS SAMPLE 1000 ROWS;
EXPLAIN PLAN FOR
SELECT empno, ename
FROM emp
WHERE ename LIKE 'S%';
SELECT *
FROM TABLE(DBMS_XPLAN.DISPLAY);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/154324/viewspace-1009259/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/154324/viewspace-1009259/