该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
SQL> create table test01.tt as select * from dba_objects;
表已创建。
已用时间: 00: 00: 03.14
SQL> select count(1) from test01.tt;
COUNT(1)
----------
71893
已用时间: 00: 00: 00.06
执行计划
----------------------------------------------------------
Plan hash value: 3133740314
-------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 287 (1)| 00:00:04 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| TT | 78633 | 287 (1)| 00:00:04 |
-------------------------------------------------------------------
Note
-----
- dynamic sampling used for this statement (level=2)
统计信息
<