sarangzigi.com

Prune의 사전적 의미

1.〔필요 없는 가지·뿌리 따위〕를 잘라내다,〔나무〕의 가지를 치다(i back, away, down, off i0); 전정(剪定)[전지]하다(i back i0).

2. (…에서)〔군더더기〕를 제거하다, (여분을) 제거하다(i away, down i0)[i of, from i0];〔비용〕을 절감하다;〔문장 따위〕를 간결하게 다듬다(i down i0).

SELECT COUNT(*)
FROM ACTUAL_SALES
WHERE PART_ID < 1600
AND QUANTITY < 500;

COUNT(*)
----------
29245

Elapsed: 00:07:04


----------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
----------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 6 | 1015 |
| 1 | SORT AGGREGATE | | 1 | 6 | |
|* 2 | TABLE ACCESS FULL | ACTUAL_SALES | 29188 | 171K| 1015 |
----------------------------------------------------------------------

SELECT COUNT(*)
FROM ACTUAL_SALES_PR
WHERE PART_ID < 1600
AND QUANTITY < 500;

COUNT(*)
----------
29245

Elapsed: 00:00:02.04

----------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Pstart| Pstop |
----------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 6 | 204 | | |
| 1 | SORT AGGREGATE | | 1 | 6 | | | |
| 2 | PARTITION RANGE ITERATOR| | | | | 1 | 2 |
|* 3 | TABLE ACCESS FULL | ACTUAL_SALES_PR | 29188 | 171K| 204 | 1 | 2 |
----------------------------------------------------------------------------------------------

Partition Iterator Information:
partition level = PARTITION
call time = RUN
order = ASCENDING
Partition iterator for level 1:
iterator = RANGE [0, 1]
index = 0
current partition: part# = 0, subp# = 65535, abs# = 0
current partition: part# = 1, subp# = 65535, abs# = 1