Oracle用EXPLAIN PLAN分析SQL语句的实例解析
发布时间：2025-11-05 02:36:45 来源：创站工坊 作者：域名
复制 SQL> list 1 SELECT * 2 FROM dept,用EL语 emp 3* WHERE emp.deptno = dept.deptno SQL> set autotrace traceonly /*traceonly 可以不显示执行结果*/ SQL> / 14 rows selected. Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 NESTED LOOPS 2 1 TABLE ACCESS (FULL) OF EMP 3 1 TABLE ACCESS (BY INDEX ROWID) OF DEPT 4 3 INDEX (UNIQUE SCAN) OF PK_DEPT (UNIQUE) Statistics ---------------------------------------------------------- 0 recursive calls 2 db block gets 30 consistent gets 0 physical reads 0 redo size 2598 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 14 rows processed 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.
亿华云IT技术网源码库企商汇益华科技服务器租用香港云服务器源码下载IT资讯网创站工坊亿华云计算亿华智慧云亿华智造编程之道智能时代亿华科技云站无忧益强编程堂亿华云亿华互联益强资讯优选极客编程益华科技益强智囊团益强IT技术网汇智坊益华科技益强科技技术快报思维库益强科技多维IT资讯益强前沿资讯码力社极客码头科技前瞻全栈开发亿华灵动IT资讯网益强数据堂码上建站益强智未来运维纵横
- Copyright © 2025 Powered by Oracle用EXPLAIN PLAN分析SQL语句的实例解析,创站工坊 滇ICP备2023006006号-44sitemap