![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() |
---|---|---|
![]() ![]() ![]() ![]() | ||
![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() | ![]() ![]()
°ª: YES ¶Ç´Â NO
|
![]() ![]()
db2set DB2_BINSORT = yes ![]() ![]() | ||
![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() | ![]() ![]()
°ª: ¸Å°³º¯¼ö¿¡ Á¾¼ÓµÊ
|
![]() ![]()
ÀÌ ·¹Áö½ºÆ®¸® º¯¼öÀÇ »ç¿ë Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
DB2_BLOCK_BASED_BP=BUFFER POOL ID,BLOCK AREA SIZE,[BLOCK SIZE];...
Ç׸ñÀ» ºÐ¸®ÇÏ´Â ¼¼¹ÌÄݷаú ÇÔ²² µ¿ÀÏ º¯¼ö¸¦ »ç¿ëÇÏ¿© ´ÙÁß ¹öÆÛ Ç®À» ºí·Ï ±â¹ÝÀ¸·Î Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù.
BLOCK SIZE °ªÀº 2 - 256 ¹üÀ§°¡ µÉ ¼ö ÀÖ½À´Ï´Ù. BLOCK SIZE°¡ ÁÖ¾îÁöÁö ¾ÊÀ» °æ¿ì, ±âº»°ªÀ¸·Î 32°¡ »ç¿ëµË´Ï´Ù.
ÁöÁ¤µÈ BLOCK AREA SIZE°¡ ÃÑ ¹öÆÛ Ç® Å©±âÀÇ 98%º¸´Ù Ŭ °æ¿ì, ¹öÆÛ Ç®Àº ºí·Ï ±â¹ÝÀÌ µÇÁö ¾Ê½À´Ï´Ù.
¹öÆÛ Ç®ÀÇ ÆäÀÌÁö ±â¹Ý ¿µ¿ª¿¡ ¹öÆÛ Ç®ÀÇ ÀÏÁ¤ ºÎºÐÀ» º¸À¯ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
ºñ·Ï ´ëºÎºÐÀÇ ½Ã½ºÅÛ ÀÔÃâ·ÂÀÌ ¼øÂ÷ ÇÁ¸®ÆäÄ¡¶ó°í ÇÏ´õ¶óµµ °³º° ÆäÀÌÁö°¡ ¿ä±¸µÉ ¼ö Àֱ⠶§¹®ÀÔ´Ï´Ù.
BLOCK AREA SIZE¿¡ ÁöÁ¤ÇÑ °ªÀÌ BLOCK SIZEÀÇ ¹è¼ö°¡ ¾Æ´Ñ °æ¿ì¿¡´Â °¡Àå ±Ù»çÄ¡ÀÇ ºí·Ï Å©±â °æ°è°¡ °ªÀÌ
µË´Ï´Ù. ºí·Ï ±â¹Ý I/O¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â 10.2.1, ºí·Ï ±â¹Ý ¹öÆÛ Ç®À» ÂüÁ¶ÇϽʽÿÀ.
| ||
![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() | ![]() ![]()
°ª: ON ¶Ç´Â OFF
|
![]() ![]() ![]() ![]() | ||
![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() | ![]() ![]()
°ª: YES ¶Ç´Â NO
|
![]() ![]()
¶§·Î ÃÖÀûÈ ¾Ë°í¸®ÁòÀº ¸ñ·Ï ÇÁ¸®ÆäÄ¡°¡ ÀûÀýÇÑ ¾×¼¼½º ¹æ¹ýÀÎÁö ÆǺ°Çϱâ À§ÇÑ Á¤È®ÇÑ Á¤º¸¸¦ °¡Áö°í ÀÖÁö ¾Ê½À´Ï´Ù. ¼ú¾î ¼±Åüº¿¡ ÃÖÀûÈ ¾Ë°í¸®ÁòÀÌ Ä«Å»·Î±× Åë°è¸¦ »ç¿ëÇÏ¿© ¼±ÅüºÀ» ÆǺ°ÇÏÁö ¸øÇϵµ·Ï ÇÏ´Â ¸Å°³º¯¼ö Ç¥½Ã±â ¶Ç´Â È£½ºÆ® º¯¼ö°¡ µé¾î ÀÖ´Â °æ¿ì ÀÌ·¯ÇÑ Çö»óÀÌ ¹ß»ýÇÕ´Ï´Ù.
ÀÌ ·¹Áö½ºÆ®¸® º¯¼ö´Â ÃÖÀûÈ ¾Ë°í¸®ÁòÀÌ ±×·¯ÇÑ »óȲ¿¡¼
¸ñ·Ï ÇÁ¸®ÆäÄ¡¸¦ °í·ÁÇÏÁö ¾Êµµ·Ï ÇÕ´Ï´Ù.
| ||
![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() | ![]() ![]()
°ª: YES ¶Ç´Â NO
|
![]() ![]()
SELECT * FROM EMPLOYEE WHERE DEPTNO IN ('D11', 'D21', 'E21')´ÙÀ½°ú °°ÀÌ ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
SELECT * FROM EMPLOYEE, (VALUES 'D11', 'D21', 'E21) AS V(DNO) WHERE DEPTNO = V.DNO
DEPTNO¿¡ ´ëÇÑ »öÀÎÀÌ ÀÖ´Â °æ¿ì, ÀÌ¿Í °°ÀÌ ¼öÁ¤Çصµ ¼º´ÉÀÌ ÁÁ¾ÆÁöÁö ¾Ê½À´Ï´Ù. °ª ¸ñ·Ï¿¡ ¸ÕÀú ¾×¼¼½ºÇÏ¿© Á¶ÀÎ ¼ú¾î¿¡ Àû¿ëÇÒ »öÀÎÀ» »ç¿ëÇÏ¿© EMPLOYEE¸¦ Áßø ·çÇÁ Á¶Àο¡ Á¶ÀÎÇϽʽÿÀ.
¶§·Î ÃÖÀûÈ ¾Ë°í¸®ÁòÀº ÀçÀÛ¼ºµÈ Á¶È¸ ¹öÀüÀÇ ÃÖÀû Á¶ÀÎ ¹æ¹ýÀ»
ÆǺ°Çϱâ À§ÇÑ Á¤È®ÇÑ Á¤º¸¸¦ °¡Áö°í ÀÖÁö ¾Ê½À´Ï´Ù.
IN ¸ñ·Ï¿¡ ÃÖÀûÈ ¾Ë°í¸®ÁòÀÌ
Ä«Å»·Î±× Åë°è¸¦ »ç¿ëÇÏ¿© ¼±ÅüºÀ» ÆǺ°ÇÏÁö ¸øÇϵµ·Ï ÇÏ´Â
¸Å°³º¯¼ö Ç¥½Ã±â ¶Ç´Â È£½ºÆ® º¯¼ö°¡ µé¾î ÀÖ´Â °æ¿ì ÀÌ·¯ÇÑ Çö»óÀÌ ¹ß»ýÇÕ´Ï´Ù.
ÀÌ ·¹Áö½ºÆ®¸® º¯¼ö´Â ÃÖÀûÈ ¾Ë°í¸®ÁòÀÌ IN ¸ñ·ÏÀ»
Á¶ÀÎÀÇ ³»ºÎ Å×À̺í·Î Æ÷ÇÔ½ÃÅ°´Â Å×À̺íÀ» »ç¿ëÇÏ¿©
Áßø ·çÇÁ Á¶ÀÎÀ» È°¿ëÇÏ¿© °ª ¸ñ·ÏÀ» Á¶ÀÎÇϵµ·Ï ÇÕ´Ï´Ù.
|
DB2_NEWLOGPATH2 ·¹Áö½ºÆ®¸® º¯¼ö´Â ¸ðµç ¿î¿µ üÁ¦¿¡ ´ëÇØ »ç¿ë °¡´ÉÇÕ´Ï´Ù. »õ º¯¼ö(DB2_ROLLFORWARD_NORETRIEVE)°¡
Ãß°¡µÇ¾ú½À´Ï´Ù. µÎ º¯¼ö¿¡ ´ëÇÑ ¿Ã¹Ù¸¥ Á¤º¸´Â ´ÙÀ½°ú °°½À´Ï´Ù.
»õ º¯¼ö(DB2_REDUCED_OPTIMIZATION)°¡ Ãß°¡µÇ¾ú½À´Ï´Ù.
![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() |
---|---|---|
![]() ![]() ![]() ![]() | ||
![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() | ![]() ![]()
°ª: YES, NO ¶Ç´Â ÀÓÀÇÀÇ Á¤¼ö
|
![]() ![]()
°ü¸® ¾È³»¼: ¼º´ÉÀÇ "ÃÖÀûÈ Å¬·¡½º Á¶Á¤"¿¡¼ ¼³¸íÇÑ ´ë·Î DB2_REDUCED_OPTIMIZATIONÀÌ YES·Î
¼³Á¤µÇ¾úÀ» ¶§ ÃÖÀûÈ ·¹º§ 5¿¡¼ µ¿Àû ÃÖÀûÈÀÇ °¨¼Ò´Â ÃÖÀûÈ ·¹º§ 5¿¡ ´ëÇØ ¼³¸íÇÑ µ¿ÀÛº¸´Ù ¿ì¼±Çϸç
Á¤¼ö ¼³Á¤¿¡ ´ëÇØ ¼³¸íÇÑ µ¿ÀÛº¸´Ùµµ ¿ì¼±ÇÕ´Ï´Ù.
|