We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 4_3_17 || /*+ INDEX_ASC */ HINT »ç¿ë ¿¹SELECT /*+ INDEX (INSA INSA_PK) */ SABUN, ENG_NAME, JOIN_GBN_CODE, SALARYFROM INSAWHERE 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, SALARYFROM INSAWHERE SABUN LIKE '2013%'AND JOIN_GBN_CODE='RGL';
¡á¿¹ 4_3_19 || /*+ INDEX_DESC */ HINT »ç¿ë ¿¹(¼¹ö INSA °èÁ¤¿¡¼ µ¿ÀÛ, µ¥ÀÌÅÍ °Ç¼ö)SELECT /*+ INDEX_FS(INSA INSA_PK) */ COUNT(SABUN)FROM INSAWHERE JOIN_GBN_CODE='RGL';
¡á¿¹ 4_3_20 || /*+ INDEX_FFS */ HINT »ç¿ë ¿¹CREATE INDEX INSA_GBN_SABUNON INSA(JOIN_GBN_CODE,SABUN);
SELECT /*+ INDEX_FFS(INSA INSA_GBN_SABUN) */ JOIN_GBN_CODE, COUNT(JOIN_GBN_CODE)FROM INSAGROUP BY JOIN_GBN_CODE;
¡á¿¹ 4_3_21 || LEADING HINT »ç¿ë ÀüSELECT I.SABUN, I.ENG_NAME, I.JOIN_GBN_CODE, C.CMP_NAMEFROM INSA I, INSA_COMPANY CWHERE I.CMP_REG_NO = C.CMP_REG_NOAND 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_NAMEFROM INSA I, INSA_COMPANY CWHERE I.CMP_REG_NO = C.CMP_REG_NOAND 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_NAMEFROM INSA I, INSA_COMPANY CWHERE I.CMP_REG_NO = C.CMP_REG_NOAND C.CMP_REG_NO='2222222206'AND I.SABUN='2012010101';
¡á¿¹ 4_3_24 || /*+ ALL_ROWS */ HINT »ç¿ëSELECT /*+ ALL_ROWS */ SABUN, ENG_NAME, JOIN_GBN_CODE, SALARYFROM INSAWHERE SABUN LIKE '2013%'AND JOIN_GBN_CODE='RGL';