¡á¿¹ 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';