135-1821-9792

oracleexplain

EXPLAIN PLAN FOR SELECT * FROM TB_USER;

    select * from table(dbms_xplan.display);

Plan hash value: 1576953371

-----------------------------------------------------------------------------
| Id  | Operation         | Name    | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |         |   389K|   103M|  4075   (1)| 00:00:49 |
|   1 |  TABLE ACCESS FULL| TB_USER |   389K|   103M|  4075   (1)| 00:00:49 |
-----------------------------------------------------------------------------

分享文章:oracleexplain
URL地址:http://www.wtcwzsj.com/article/ppedcg.html

其他资讯



Copyright © 2009-2022 www.wtcwzsj.com 青羊区广皓图文设计工作室(个体工商户) 版权所有 蜀ICP备19037934号