[DATABASE/ORACLE] ORDERED 힌트 : FROM절의 테이블 순서대로 접근하기

icodebroker ORACLE 2024-06-18

■ ORDERED 힌트를 사용해 FROM절의 테이블 순서대로 접근하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT /*+ ORDERED */
    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 /*+ ORDERED */

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'