°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
ÀÌ ¸í·ÉÀº DB2 »ç¿ëÀÚ Å×ÀÌºí ¶Ç´Â Áö¼ÓÀû ij½Ã¿¡ Àִ ij½Ã Å×À̺íÀ» Ȱ¼ºÈÇÕ´Ï´Ù. Ȱ¼ºÈ°¡ ¿Ï·áµÇ¸é ½ºÅä¾îµå ÇÁ·Î½ÃÀú¸¦ »ç¿ëÇÏ´Â °Ë»ö Á¶ÀÛÀÌ °¡´ÉÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»ö ÇÔ¼ö¸¦ ÂüÁ¶ÇϽʽÿÀ.
ÀÌ ¸í·ÉÀº CACHE TABLE ¿É¼ÇÀ» »ç¿ëÇÏ¿© À妽º¸¦ ÀÛ¼ºÇÑ °æ¿ì¿¡¸¸ »ç¿ëÇÒ ¼ö ÀÖÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â CREATE INDEX¸¦ ÂüÁ¶ÇϽʽÿÀ.
±ÇÇÑ ºÎ¿©
DB2 īŻ·Î±× ºä¿¡ µû¶ó ÀÌ ¸í·ÉÀÇ »ç¿ëÀÚ ID´Â Àüü ÅØ½ºÆ® À妽º°¡ ÀÛ¼ºµÈ Å×ÀÌºí¿¡ ´ëÇÑ CONTROL Ư±ÇÀ» °®°í ÀÖ¾î¾ß ÇÕ´Ï´Ù.
¸í·É ±¸¹®
>>-ACTIVATE CACHE FOR INDEX--+------------------+--index-name---> '-index-schema-"."-' >--FOR-TEXT--+----------+--+----------------------+------------>< '-RECREATE-' '-|connection-options|-' connection-options: |--+--------------------------------------------------------------+--| '-CONNECT-TO--database-name--+-------------------------------+-' '-USER--userid--USING--password-'
¸í·É ¸Å°³º¯¼ö
¿ëµµ
À妽º¿¡¼ ´ÙÀ½ ¸í·É Áß Çϳª°¡ ½ÇÇà ÁßÀÌ¸é ¸í·ÉÀ» ¹ßÇàÇÒ ¼ö ¾ø½À´Ï´Ù.
Âü°í |
---|
ij½Ã Å×À̺íÀ» Ȱ¼ºÈÇÏ·Á¸é Áö¼ÓÀû ij½Ã°¡ »ç¿ëµÇ°í ÀÖ´õ¶óµµ ½ºÅ©·¡Ä¡·ÎºÎÅÍ Ä³½Ã Å×À̺íÀ» ÀçÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù. ÀÌ´Â Áö¼ÓÀû ij½Ã°¡ ºñȰ¼ºÈµÇ¾î ÀÖ´Â µ¿¾È °»½Å Á¶ÀÛÀ» ¼öÇàÇÒ °æ¿ì¿¡ ¹ß»ýÇÕ´Ï´Ù. |
ij½Ã¸¦ ºôµåÇÏ´Â µ¥ »ç¿ëµÇ´Â ¸Þ¸ð¸® ¾çÀº ÇöÀç ¹®¼ ¼ö¿Í °á°ú Ä÷³ Å©±â¿¡¼ µ¿ÀûÀ¸·Î °è»êµË´Ï´Ù. PCTFREE °ªÀ» »ç¿ëÇÏ¿© 100/(100-PCTFREE) Àμö Å©±â ¸¸Å °è»êµÈ ÃÖ¼Ò ¸Þ¸ð¸® ¾çÀ» ´Ã¸®½Ê½Ã¿À. PCTFREE °ªÀº CREATE ¶Ç´Â ALTER INDEX ¸í·É¿¡ ÁöÁ¤µÇ¾î ÀÖ½À´Ï´Ù.
PCTFREE¿¡¼´Â ij½Ã°¡ Ȱ¼ºÈµÇ¾î ÀÖ´Â µ¿¾È »ðÀÔ Á¶ÀÛ¿¡ ¿¹¾àµÈ ÇÒ´çµÈ ij½ÃÀÇ ¹éºÐÀ²¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. °¢ ACTIVATE CACHE ¸í·É¿¡ ´ëÇØ ½ÇÁ¦ ¸Þ¸ð¸® Å©±â¸¦ ´Ù½Ã °è»êÇÕ´Ï´Ù.