|
SQL에서 where 조건이 없으므로 당연히 모드 건이 답일꺼 같은데
sort order by에서 건이 줄어듭니다.
왜 그런걸까요???
버전 8.1.7
select col1
from ABC
order by col1;
call count cpu elapsed disk query
current rows
------- ------ -------- ---------- ---------- ----------
---------- ----------
Parse 1 0.00 0.00 0 0
0 0
Execute 2 0.01 0.01 0 0
0 0
Fetch 2852 0.19 0.09 8 15
6 2852
------- ------ -------- ---------- ---------- ----------
---------- ----------
total 2855 0.20 0.10 8 15
6 2852
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
2852 SORT (ORDER BY)
5355 TABLE ACCESS (FULL) OF 'ABC'
|
