°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
½ºÅä¾îµå ÇÁ·Î½ÃÀú¸¦ »ç¿ëÇÏ¿© ºä¿¡ ´ëÇÑ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ÇÑ °¡Áö Áß¿äÇÑ ´ÜÁ¡Àº ºä¿¡ ´ëÇÑ Æ®¸®°Å¸¦ ÀÛ¼ºÇÒ ¼ö ¾ø±â ¶§¹®¿¡ ±âÃʰ¡ µÇ´Â ±âº» Å×À̺íÀÇ º¯°æ»çÇ×À» ÀνÄÇÒ ¼ö ¾ø´Ù´Â °ÍÀÔ´Ï´Ù.
±×·¯¹Ç·Î ÁõºÐ À妽º °»½Å¿¡¼ ÅØ½ºÆ® À妽º¸¦ µ¥ÀÌÅͺ£À̽º¿Í µ¿±âÈÇÏ·Á¸é ¾î¶² ¹®¼°¡ Ãß°¡, °»½Å ¶Ç´Â »èÁ¦µÇ¾ú´ÂÁö¸¦ ¾Ë¾Æ¾ßÇÕ´Ï´Ù. À̸¦ ¼öÇàÇÏ·Á¸é ¸ðµç º¯°æ»çÇ×À» ·Î±× Å×ÀÌºí¿¡ Ãß°¡ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ÇÁ·Î¼¼½º´Â ´ÙÀ½ »ùÇÿ¡ ³ª¿Í ÀÖ½À´Ï´Ù.
db2 "create table sample (key INTEGER not null PRIMARY KEY, name VARCHAR(50) not null, comment VARCHAR(90))"
db2 "insert into sample values(1,'Claus','works in room 301')" db2 "insert into sample values(2,'Manja','is in the same office as Juergen')" db2 "insert into sample values(2,'Juergen','has the longest way to Raiko')" db2 "insert into sample values(3,'Raiko','is sitting in the office besides Claus ')"
db2 "create view sampleview as select key, comment from sample"
db2text "create index indexview for text on hde.sampleview(comment) cache table (comment) maximum cache size 1 key columns for index on view (key)" db2text "update index indexview for text" db2text "activate cache for index indexview for text"
Âü°í |
---|
ºä¿¡¼ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÒ ¼ö ÀÖµµ·Ï ij½Ã Å×À̺íÀ» ÁöÁ¤ÇϽʽÿÀ. ¿Ã¹Ù¸¥ ·Î±× Å×À̺íÀ» ÀÛ¼ºÇÏ·Á¸é ºä¿¡¼ À妽ºÀÇ Å° Ä÷³À» ÁöÁ¤ÇϽʽÿÀ. ºÐ»ê DB2 ȯ°æ¿¡¼´Â ´ÜÀÏ ³ëµå¿¡ ÀÖ´Â °ü¸® Å×ÀÌºí¿¡ ´ëÇÑ Å×ÀÌºí ½ºÆäÀ̽º¸¦ ¸í½ÃÀûÀ¸·Î ÁöÁ¤Çϰí ÀÌ ³ëµå¿¡¼ ¸í½ÃÀûÀ¸·Î È£ÃâÇØ¾ß ÇÕ´Ï´Ù. ¿Ã¹Ù¸¥ ³ëµå¿¡ ¿¬°áµÇ¾ú´ÂÁö È®ÀÎÇÏ·Á¸é DB2NODE ȯ°æ º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ. |
db2 "insert into sample values(4,'Bernhard','is working in the same floor as Manja, but not as Claus')" db2 "insert into sample values(5,'Guenter','shares the office with Raiko')"
db2 "select INDSCHEMA,INDNAME,LOGVIEWSCHEMA,LOGVIEWNAME from db2ext.textindexes"´ÙÀ½Àº ·Î±× Å×À̺íÀÇ ·¹À̾ƿôÀÔ´Ï´Ù.
sqltype sqllen sqlname.data sqlname.length -------------------- ------ ----------------------- -------------- 496 INTEGER 4 OPERATION 9 392 TIMESTAMP 26 TIME 4 497 INTEGER 4 PK01 4Ç׸ñÀ» ·Î±× Å×ÀÌºí¿¡ Ãß°¡ÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
db2 "insert into sample values(0,CURRENT TIMESTAMP,4)" db2 "insert into sample values(0,CURRENT TIMESTAMP,5)"ù ¹øÂ° °ªÀº Á¶ÀÛ(0 = »ðÀÔ, 1 = °»½Å, 2 = »èÁ¦)¿¡ ´ëÇÑ ¼³¸íÀÌ°í µÎ ¹øÂ° °ªÀº Ç×»ó CURRENT TIMESTAMPÀ̾î¾ß ÇÏ¸ç ¸¶Áö¸· °ªÀº »ðÀÔµÈ Å°ÀÔ´Ï´Ù.
db2text "update index indexview for text"
ÀÌÁ¦ ½ºÅä¾îµå ÇÁ·Î½ÃÀú¸¦ »ç¿ëÇÏ¿© »õ °ª¿¡ ´ëÇÑ °Ë»öÀ» ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.