explain plan for
select *
from t2,
(select /*+ dynamic_sampling(t1 4) */
c1, c2
from t1
where t1.c2 = 'A' and
t1.c3 = 'b'
) v
where t2.c1 = v.cl;
--------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 16 | 9 (0)| 00:00:01 |
| 1 | NESTED LOOPS | | | | | |
| 2 | NESTED LOOPS | | 1 | 16 | 9 (0)| 00:00:01 |
|* 3 | TABLE ACCESS FULL | T1 | 1 | 8 | 7 (0)| 00:00:01 |
|* 4 | INDEX RANGE SCAN | T2_N1 | 1 | | 1 (0)| 00:00:01 |
| 5 | TABLE ACCESS BY INDEX ROWID| T2 | 1 | 8 | 2 (0)| 00:00:01 |
--------------------------------------------------------------------------------------
select
*
from
t1
where
c2 = 'A' and
c3 = (select max(c2) from t3)
;
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 5000 | 40000 | 10 (0)| 00:00:01 |
|* 1 | TABLE ACCESS FULL | T1 | 5000 | 40000 | 7 (0)| 00:00:01 |
| 2 | SORT AGGREGATE | | 1 | 2 | | |
| 3 | TABLE ACCESS FULL| T3 | 2 | 4 | 3 (0)| 00:00:01 |
----------------------------------------------------------------------------
select
*
from
t1, t2
where
t1.c1 = t2.c1+100000
;
---------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 11000 | 171K| 15 (7)| 00:00:01 |
|* 1 | HASH JOIN | | 11000 | 171K| 15 (7)| 00:00:01 |
| 2 | TABLE ACCESS FULL| T1 | 11000 | 88000 | 7 (0)| 00:00:01 |
| 3 | TABLE ACCESS FULL| T2 | 11000 | 88000 | 7 (0)| 00:00:01 |
---------------------------------------------------------------------------
- 강좌 URL : http://www.gurubee.net/lecture/3953
- 구루비 강좌는 개인의 학습용으로만 사용 할 수 있으며, 다른 웹 페이지에 게재할 경우에는 출처를 꼭 밝혀 주시면 고맙겠습니다.~^^
- 구루비 강좌는 서비스 제공을 위한 목적이나, 학원 홍보, 수익을 얻기 위한 용도로 사용 할 수 없습니다.