17,082
社区成员
发帖
与我相关
我的任务
分享
SQL> select /*+ FIRST_ROWS */ count(*) from emp,emp,emp,emp,emp,emp,emp;
已用时间: 00: 00: 00.04
执行计划
----------------------------------------------------------
Plan hash value: 2048615215
-------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 1786K (1)| 05:57:13 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | MERGE JOIN CARTESIAN | | 105M| 1786K (1)| 05:57:13 |
| 3 | MERGE JOIN CARTESIAN | | 7529K| 127K (1)| 00:25:32 |
| 4 | MERGE JOIN CARTESIAN | | 537K| 9121 (1)| 00:01:50 |
| 5 | MERGE JOIN CARTESIAN | | 38416 | 657 (1)| 00:00:08 |
| 6 | MERGE JOIN CARTESIAN | | 2744 | 51 (0)| 00:00:01 |
| 7 | MERGE JOIN CARTESIAN | | 196 | 6 (0)| 00:00:01 |
| 8 | INDEX FULL SCAN | PK_EMP | 14 | 1 (0)| 00:00:01 |
| 9 | BUFFER SORT | | 14 | 5 (0)| 00:00:01 |
| 10 | INDEX FAST FULL SCAN| PK_EMP | 14 | 0 (0)| 00:00:01 |
| 11 | BUFFER SORT | | 14 | 51 (0)| 00:00:01 |
| 12 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
| 13 | BUFFER SORT | | 14 | 657 (1)| 00:00:08 |
| 14 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
| 15 | BUFFER SORT | | 14 | 9120 (1)| 00:01:50 |
| 16 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
| 17 | BUFFER SORT | | 14 | 127K (1)| 00:25:32 |
| 18 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
| 19 | BUFFER SORT | | 14 | 1786K (1)| 05:57:13 |
| 20 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
-------------------------------------------------------------------------------
SQL> select /*+ FIRST_ROWS */ count(1) from emp,emp,emp,emp,emp,emp,emp;
已用时间: 00: 00: 00.03
执行计划
----------------------------------------------------------
Plan hash value: 2048615215
-------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 1786K (1)| 05:57:13 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | MERGE JOIN CARTESIAN | | 105M| 1786K (1)| 05:57:13 |
| 3 | MERGE JOIN CARTESIAN | | 7529K| 127K (1)| 00:25:32 |
| 4 | MERGE JOIN CARTESIAN | | 537K| 9121 (1)| 00:01:50 |
| 5 | MERGE JOIN CARTESIAN | | 38416 | 657 (1)| 00:00:08 |
| 6 | MERGE JOIN CARTESIAN | | 2744 | 51 (0)| 00:00:01 |
| 7 | MERGE JOIN CARTESIAN | | 196 | 6 (0)| 00:00:01 |
| 8 | INDEX FULL SCAN | PK_EMP | 14 | 1 (0)| 00:00:01 |
| 9 | BUFFER SORT | | 14 | 5 (0)| 00:00:01 |
| 10 | INDEX FAST FULL SCAN| PK_EMP | 14 | 0 (0)| 00:00:01 |
| 11 | BUFFER SORT | | 14 | 51 (0)| 00:00:01 |
| 12 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
| 13 | BUFFER SORT | | 14 | 657 (1)| 00:00:08 |
| 14 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
| 15 | BUFFER SORT | | 14 | 9120 (1)| 00:01:50 |
| 16 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
| 17 | BUFFER SORT | | 14 | 127K (1)| 00:25:32 |
| 18 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
| 19 | BUFFER SORT | | 14 | 1786K (1)| 05:57:13 |
| 20 | INDEX FAST FULL SCAN | PK_EMP | 14 | 0 (0)| 00:00:01 |
-------------------------------------------------------------------------------
SQL> select count(*) from ysgl_compile_reqsub;
COUNT(*)
----------
5288265
已用时间: 00: 00: 07.51
SQL> select count(1) from ysgl_compile_reqsub;
COUNT(1)
----------
5288265
已用时间: 00: 00: 00.68
SQL> select count(id) from ysgl_compile_reqsub;
COUNT(ID)
----------
5288265
已用时间: 00: 00: 00.68
SQL> select count(rowid) from ysgl_compile_reqsub;
COUNT(ROWID)
------------
5288265
已用时间: 00: 00: 01.01
SQL> select count(rowid) from ysgl_vdata_his;
COUNT(ROWID)
------------
5299458
已用时间: 00: 00: 09.98
SQL> select count(*) from ysgl_vdata_his;
COUNT(*)
----------
5299458
已用时间: 00: 00: 00.93
SQL> select count(1) from ysgl_vdata_his;
COUNT(1)
----------
5299458
已用时间: 00: 00: 00.71
SQL> select count(1) from ysgl_excelbasic;
COUNT(1)
----------
3755052
已用时间: 00: 00: 04.60
SQL> select count(*) from ysgl_excelbasic;
COUNT(*)
----------
3755052
已用时间: 00: 00: 00.50
SQL>