SYSCS_UTIL.SYSCS_COMPRESS_TABLEシステム手続ã??を使ã?£ã?¦ã€?表や索引ã?«å‰²ã‚Šå½“ã?¦ã‚‰ã‚Œã?¦ã?„る未使用ã?®é ˜åŸŸã‚’å†?利用ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ 典型的ã?ªçжæ³?ã?§ã?¯ã€?割り当ã?¦ã‚‰ã‚Œã?Ÿæœªä½¿ç”¨ã?®é ˜åŸŸã?¯è¡¨ã?‹ã‚‰å¤§å®¹é‡?ã?®æƒ…å ±ã?Œå‰Šé™¤ã?•れã?Ÿå ´å?ˆã‚„ã€?索引ã?Œæ›´æ–°ã?•れã?Ÿå ´å?ˆã?«å˜åœ¨ã?—ã?¾ã?™ã€‚既定ã?§ã?¯ã€?Derbyã?¯æœªä½¿ç”¨ã?®é ˜åŸŸã‚’基本ソフト(OS)ã?«è¿”å?´ã?—ã?¾ã?›ã‚“。例ã?ˆã?°ãƒšãƒ¼ã‚¸ã?Œè¡¨ã‚„索引ã?«ä¸€åº¦å‰²ã‚Šå½“ã?¦ã‚‰ã‚Œã‚‹ã?¨ã€?ã??ã?®è¡¨ã‚„索引ã?Œç ´æ£„ã?•れるã?¾ã?§ã?¯ã€?é ˜åŸŸã?¯OSã?«è‡ªå‹•çš„ã?«è¿”å?´ã?•れã?¾ã?›ã‚“。 SYSCS_UTIL.SYSCS_COMPRESS_TABLEã?«ã‚ˆã‚Šåˆ©ç”¨ã?•れã?¦ã?„ã?ªã?„é ˜åŸŸã‚’åŸºæœ¬ã‚½ãƒ•ãƒˆ(OS)ã?«è¿”å?´ã?§ã??ã?¾ã?™ã€‚
SYSCS_UTIL.SYSCS_COMPRESS_TABLEシステム手続ã??ã?¯ç´¢å¼•ã?®å†?構築処ç?†ã?®ä¸€ç’°ã?¨ã?—ã?¦ã€?å…¨ã?¦ã?®ç´¢å¼•ã?®çµ±è¨ˆæƒ…å ±ã‚’æ›´æ–°ã?—ã?¾ã?™ã€‚
SYSCS_UTIL.SYSCS_COMPRESS_TABLE (IN SCHEMANAME VARCHAR(128), IN TABLENAME VARCHAR(128), IN SEQUENTIAL SMALLINT)
SEQUENTIALを指定ã?—ã?¦ã€?USスã‚ーマã?«ã?‚ã‚‹CUSTOMERã?¨ã?„ã?†è¡¨ã‚’圧縮ã?—ã?¾ã?™ã€‚
call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('US', 'CUSTOMER', 1)
SEQUENTIALを指定ã?—ã?¦ã€?USスã‚ーマã?«ã?‚ã‚‹CUSTOMERã?¨ã?„ã?†è¡¨ã‚’圧縮ã?—ã?¾ã?™ã€‚
CallableStatement cs = conn.prepareCall ("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?)"); cs.setString(1, "US"); cs.setString(2, "CUSTOMER"); cs.setShort(3, (short) 1); cs.execute();
SEQUENTIALã?®å€¤ã‚’特定ã?—ã?ªã?„å ´å?ˆã€?Derbyã?¯ã€?表ã?«ã?‚ã‚‹å…¨ã?¦ã?®ç´¢å¼•ã?¸ã?®å‡¦ç?†ã‚’並列ã?—ã?¦å‡¦ç?†ã?—ã?¾ã?™ã€‚ SEQUENTIALã?®å€¤ã‚’特定ã?—ã?ªã?„ã?¨ã€?ã?“ã?®æ‰‹ç¶šã??ã?¯å¤šé‡?ã?«ãƒ¡ãƒ¢ãƒªã‚’å¿…è¦?ã?¨ã?—ã?¦ã€?ディスクã?®å¤šé‡?ã?®ä¸€æ™‚é ˜åŸŸã‚’ä½¿ã?†ã?“ã?¨ã?¨ã?ªã‚Šã?¾ã?™ã€‚(ã??ã?®ã?Šã?Šã‚ˆã??ã?®é‡?ã?¯ã€?使ã‚?れã?¦ã?„ã‚‹é ˜åŸŸã?¨å‰²ã‚Šå½“ã?¦ã‚‰ã‚Œã?Ÿä½¿ã‚?れã?¦ã?„ã?ªã?„é ˜åŸŸã?®2å€?ã?»ã?©ã?§ã?™ã€‚) ã?“れã?¯è¡¨ã‚’圧縮ã?™ã‚‹ã?¨ã??ã?«ã€?Derbyã?Œã€? (æ—¢å˜ã?®é ˜åŸŸã‚’並ã?¹æ›¿ã?ˆã?Ÿã‚Šåˆ‡ã‚Šæ?¨ã?¦ã?Ÿã‚Šã?™ã‚‹ã?®ã?§ã?¯ã?ªã??ã€?)生ã??ã?¦ã‚‹è¡Œã‚’æ–°è¦?ã?«å‰²ã‚Šå½“ã?¦ã?Ÿé ˜åŸŸã?«å†™ã?™ã?‹ã‚‰ã?§ã?™ã€‚余分ã?ªé ˜åŸŸã?¯COMMITã?®ã?¨ã??ã€?基本ソフト(OS)ã?«è¿”ã?•れã?¾ã?™ã€‚
SEQUENTIALã?®å€¤ã?Œç‰¹å®šã?•れã?Ÿå ´å?ˆã€?Derbyã?¯ã€?ã?¾ã?šè¡¨ã‚’圧縮ã?—ã?¦ã?‹ã‚‰å€‹ã€…ã?®ç´¢å¼•ã‚’é †ã?«åœ§ç¸®ã?—ã?¾ã?™ã€‚SEQUENTIALを利用ã?™ã‚‹ã?¨ã€?å¿…è¦?ã?ªãƒ¡ãƒ¢ãƒªã‚„ãƒ‡ã‚£ã‚¹ã‚¯é ˜åŸŸã‚’å°‘ã?ªã??ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã?Œã€?処ç?†æ™‚é–“ã?¯ã‚ˆã‚Šé•·ã??ã?ªã‚Šã?¾ã?™ã€‚ãƒ¡ãƒ¢ãƒªã‚„ãƒ‡ã‚£ã‚¹ã‚¯é ˜åŸŸã?®åˆ©ç”¨ã‚’減らã?™ã?ªã‚‰ã€?SEQUENTIALã?®å¼•数を指定ã?—ã?¦ã??ã? ã?•ã?„。