[DATABASE/ORACLE] LEADING 힌트 : 테이블 접근 순서 설정하기

icodebroker ORACLE 2024-06-18

■ LEADING 힌트를 사용해 테이블 접근 순서를 설정하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT /*+ LEADING(B A) */
    A.CUSTOMER_ID
   ,A.CUSTOMER_NAME
   ,B.ORDER_DATE
   ,B.ORDER_NAME
FROM CUSTOMER A, ORDER B
WHERE A.CUSTOMER_ID   = B.CUSTOMER_ID
AND   A.CUSTOMER_NAME = '홍길동'
AND   B.ORDER_DATE    = '20200201'

1

2

3

4

5

6

7

8

9

10

11

SELECT /*+ LEADING(B A) */

A.CUSTOMER_ID

,A.CUSTOMER_NAME

,B.ORDER_DATE

,B.ORDER_NAME

FROM CUSTOMER A, ORDER B

WHERE A.CUSTOMER_ID = B.CUSTOMER_ID

AND A.CUSTOMER_NAME = '홍길동'

AND B.ORDER_DATE = '20200201'

※ /*+ LEADING(테이블명 [테이블명 …]) */