首页 > 代码库 > 【测试】在hr用户下自行创建T1和T2表写一条SQL语句，（NL连接）
【测试】在hr用户下自行创建T1和T2表写一条SQL语句，（NL连接）
SQL> select t1.* from t1,t2 where t1.object_id=t2.object_id;
99 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 1506669289
--------------------------------------------------------------------------------
-------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Tim
e |
--------------------------------------------------------------------------------
-------
| 0 | SELECT STATEMENT | | 99 | 16929 | 201 (0)| 00:
00:03 |
| 1 | NESTED LOOPS | | 99 | 16929 | 201 (0)| 00:
00:03 |
| 2 | NESTED LOOPS | | 99 | 16929 | 201 (0)| 00:
00:03 |
| 3 | TABLE ACCESS FULL | T2 | 99 | 1287 | 3 (0)| 00:
00:01 |
|* 4 | INDEX RANGE SCAN | IDX_T1 | 1 | | 1 (0)| 00:
00:01 |
| 5 | TABLE ACCESS BY INDEX ROWID| T1 | 1 | 158 | 2 (0)| 00:
00:01 |
--------------------------------------------------------------------------------
-------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("T1"."OBJECT_ID"="T2"."OBJECT_ID")
Note
-----
- dynamic sampling used for this statement (level=2)
Statistics
----------------------------------------------------------
8 recursive calls
0 db block gets
135 consistent gets
4 physical reads
0 redo size
6108 bytes sent via SQL*Net to client
589 bytes received via SQL*Net from client
8 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
99 rows processed
【测试】在hr用户下自行创建T1和T2表写一条SQL语句，（NL连接）
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。