[DATABASE/ORACLE] FULL 힌트 : 테이블 FULL SCAN 사용하기

icodebroker ORACLE 2024-06-18

■ FULL 힌트를 사용해 테이블을 FULL SCAN 하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT /*+ FULL(ORDERS) */
    ORDER_ID
   ,ORDER_DATE
   ,ORDER_AMOUNT
FROM  ORDERS
WHERE ORDER_DATE BETWEEN TO_CHAR('2020-01-01', 'YYYY-MM-DD') AND TO_CHAR('2020-01-31', 'YYYY-MM-DD')
ORDER BY ORDER_ID;

1

2

3

4

5

6

7

8

9

SELECT /*+ FULL(ORDERS) */

ORDER_ID

,ORDER_DATE

,ORDER_AMOUNT

FROM ORDERS

WHERE ORDER_DATE BETWEEN TO_CHAR('2020-01-01', 'YYYY-MM-DD') AND TO_CHAR('2020-01-31', 'YYYY-MM-DD')

ORDER BY ORDER_ID;

※ /*+ FULL(테이블명) */