°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
À妽º¸¦ ÀÛ¼ºÇÏ·Á¸é ÅØ½ºÆ® Ä÷³Àº ´ÙÀ½ µ¥ÀÌÅÍ À¯Çü Áß Çϳª¸¦ °¡Á®¾ß ÇÕ´Ï´Ù.
¹®¼°¡ »ç¿ëÀÚ Á¤ÀÇ À¯Çü(UDT)°ú °°ÀÌ ´Ù¸¥ À¯ÇüÀ» °¡Áø Ä÷³¿¡ ÀÖÀ¸¸é ÀÔ·ÂÀ¸·Î »ç¿ëÀÚ À¯ÇüÀ» °¡Á®¿À°í À§¿¡¼ ¾ð±ÞÇÑ Çü½Ä Áß Çϳª¸¦ Ãâ·Â À¯ÇüÀ¸·Î Á¦°øÇÏ´Â ±â´ÉÀ» Á¦°øÇØ¾ß ÇÕ´Ï´Ù.
º¯È¯ ÇÔ¼öÀÇ À̸§À» ÁöÁ¤ÇϽʽÿÀ. ÀÚ¼¼ÇÑ Á¤º¸´Â CREATE INDEX¸¦ ÂüÁ¶ÇϽʽÿÀ.
¿¹: Å×ÀÌºí¿¡ ¾ÐÃàµÈ ÅØ½ºÆ®¸¦ ÀúÀåÇÏ·Á°í ÇÕ´Ï´Ù.
db2 "CREATE DISTINCT TYPE COMPRESSED_TEXT AS CLOB(1M)"
db2 "CREATE TABLE UDTTABLE (author VARCHAR(50) not null, text COMPRESSED_TEXT, primary key (author))" db2 "INSERT ..."
db2text "CREATE INDEX UDTINDEX for text ON UDTTABLE (uncompress(text)) ..."