■예 4_3_17  ||  /*+ INDEX_ASC */ HINT 사용 예
SELECT /*+ INDEX (INSA INSA_PK) */
 SABUN, ENG_NAME,  JOIN_GBN_CODE, SALARY
FROM INSA
WHERE SABUN LIKE '2013%'
AND JOIN_GBN_CODE='RGL';

■예 4_3_18  ||  /*+ INDEX_DESC */ HINT 사용 예
SELECT /*+ INDEX_DESC (INSA INSA_PK) */
 SABUN, ENG_NAME,  JOIN_GBN_CODE, SALARY
FROM INSA
WHERE SABUN LIKE '2013%'
AND JOIN_GBN_CODE='RGL';

■예 4_3_19  ||  /*+ INDEX_DESC */ HINT 사용 예(서버 INSA 계정에서 동작, 데이터 건수)
SELECT /*+ INDEX_FS(INSA INSA_PK) */
        COUNT(SABUN)
FROM INSA
WHERE JOIN_GBN_CODE='RGL';

■예 4_3_20  ||  /*+ INDEX_FFS */ HINT 사용 예
CREATE INDEX INSA_GBN_SABUN
ON INSA(JOIN_GBN_CODE,SABUN);

SELECT  /*+ INDEX_FFS(INSA INSA_GBN_SABUN) */
       JOIN_GBN_CODE, COUNT(JOIN_GBN_CODE)
FROM INSA
GROUP BY JOIN_GBN_CODE;

■예 4_3_21  ||  LEADING HINT 사용 전
SELECT I.SABUN, I.ENG_NAME, I.JOIN_GBN_CODE, C.CMP_NAME
FROM INSA I, INSA_COMPANY C
WHERE I.CMP_REG_NO = C.CMP_REG_NO
AND I.SABUN='2012010101'
AND C.CMP_REG_NO = '2222222206';

■예 4_3_22  ||  LEADING HINT 사용
SELECT  /*+ LEADING(I C) */
       I.SABUN, I.ENG_NAME, I.JOIN_GBN_CODE, C.CMP_NAME
FROM INSA I, INSA_COMPANY C
WHERE I.CMP_REG_NO = C.CMP_REG_NO
AND I.SABUN='2012010101'
AND C.CMP_REG_NO = '2222222206';

■예 4_3_23  ||  ORDERED HINT 사용
SELECT /*+ ORDERED */
 I.SABUN, I.ENG_NAME, I.JOIN_GBN_CODE, C.CMP_NAME
FROM INSA I, INSA_COMPANY C
WHERE I.CMP_REG_NO = C.CMP_REG_NO
AND C.CMP_REG_NO='2222222206'
AND I.SABUN='2012010101';

■예 4_3_24  ||  /*+ ALL_ROWS */ HINT 사용
SELECT  /*+ ALL_ROWS */
      SABUN, ENG_NAME,  JOIN_GBN_CODE, SALARY
FROM INSA
WHERE SABUN LIKE '2013%'
AND JOIN_GBN_CODE='RGL';