自己做的测试SQL> set autotrace traceonly
SQL> select col2 from test.happy1 where col1=200;
Execution Plan
----------------------------------------------------------
Plan hash value: 176943205-----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 26 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID| HAPPY1 | 1 | 26 | 2 (0)| 00:00:01 |
|* 2 | INDEX UNIQUE SCAN | HAPPY1_PK | 1 | | 1 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------Predicate Information (identified by operation id):
--------------------------------------------------- 2 - access("COL1"=200)
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
3 consistent gets
0 physical reads
0 redo size
318 bytes sent via SQL*Net to client
370 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processedSQL> select /*+full(e)*/ col2 from test.happy1 e where col1=200;
Execution Plan
----------------------------------------------------------
Plan hash value: 2659932512----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 49 | 1274 | 15 (0)| 00:00:01 |
|* 1 | TABLE ACCESS FULL| HAPPY1 | 49 | 1274 | 15 (0)| 00:00:01 |
----------------------------------------------------------------------------Predicate Information (identified by operation id):
--------------------------------------------------- 1 - filter("COL1"=200)
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
22 consistent gets
0 physical reads
0 redo size
407 bytes sent via SQL*Net to client
381 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
请问问执行计划返回中的ROWS是什么含义!也就是那个49的含义。
SQL> select col2 from test.happy1 where col1=200;
Execution Plan
----------------------------------------------------------
Plan hash value: 176943205-----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 26 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID| HAPPY1 | 1 | 26 | 2 (0)| 00:00:01 |
|* 2 | INDEX UNIQUE SCAN | HAPPY1_PK | 1 | | 1 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------Predicate Information (identified by operation id):
--------------------------------------------------- 2 - access("COL1"=200)
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
3 consistent gets
0 physical reads
0 redo size
318 bytes sent via SQL*Net to client
370 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processedSQL> select /*+full(e)*/ col2 from test.happy1 e where col1=200;
Execution Plan
----------------------------------------------------------
Plan hash value: 2659932512----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 49 | 1274 | 15 (0)| 00:00:01 |
|* 1 | TABLE ACCESS FULL| HAPPY1 | 49 | 1274 | 15 (0)| 00:00:01 |
----------------------------------------------------------------------------Predicate Information (identified by operation id):
--------------------------------------------------- 1 - filter("COL1"=200)
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
22 consistent gets
0 physical reads
0 redo size
407 bytes sent via SQL*Net to client
381 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
请问问执行计划返回中的ROWS是什么含义!也就是那个49的含义。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货