{"id":379,"date":"2024-11-19T15:50:09","date_gmt":"2024-11-19T06:50:09","guid":{"rendered":"https:\/\/sejiwon.com\/?p=379"},"modified":"2024-11-19T15:50:09","modified_gmt":"2024-11-19T06:50:09","slug":"%ec%88%98%ec%a7%91%eb%90%9c-%ed%86%b5%ea%b3%84%ec%a0%95%eb%b3%b4-%ed%99%95%ec%9d%b8%ec%9d%b8%eb%8d%b1%ec%8a%a4-%ea%b8%b0%ec%a4%80-%ec%98%a4%eb%9d%bc%ed%81%b4","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=379","title":{"rendered":"\uc218\uc9d1\ub41c \ud1b5\uacc4\uc815\ubcf4 \ud655\uc778(\uc778\ub371\uc2a4 \uae30\uc900 &#8211; \uc624\ub77c\ud074)"},"content":{"rendered":"\n<p>\uc774\uc804\uc5d0 \ud1b5\uacc4\uc815\ubcf4 \ud655\uc778\uc740 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uac74\uc218\uac00 \uc5bc\ub9c8\ub098 \uc788\ub294\uc9c0\ub97c \uc54c\uc544\ubd24\ub2e4\uba74, \uc774\ubc88\uc5d0\ub294 \uc778\ub371\uc2a4\ub97c \uae30\uc900\uc73c\ub85c \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>ALL_IND_STATISTICS \uc5d0\uc11c\ub3c4 \uac19\uc740 \uc815\ubcf4\ud655\uc778\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc54c\uc544\ubcf4\ub294 SQL\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT TABLE_NAME\n      ,INDEX_NAME\n      ,BLEVEL             \/* \ub9ac\ud504\ube14\ub85d \ub3c4\ub2ec\uae4c\uc9c0 \uc77d\ub294 \ube14\ub85d\uc218 *\/\n      ,LEAF_BLOCKS        \/* \uc778\ub371\uc2a4 \ub9ac\ud504 \ube14\ub85d \ucd1d \uac1c\uc218 *\/\n      ,NUM_ROWS           \/* \uc778\ub371\uc2a4 \uc800\uc7a5\ub41c \ub808\ucf54\ub4dc \uac1c\uc218 *\/\n      ,DISTINCT_KEYS      \/* '=' \uc870\uac74\uc73c\ub85c \uc870\ud68c\ud560 \ub54c \uc77d\ub294 \ub9ac\ud504\ube14\ub85d \uc218 \n      ,AVG_LEAF_BLOCKS_PER_KEY \/* '=' \uc870\uac74\uc73c\ub85c \uc870\ud68c\ud560 \ub54c \uc77d\ub294 \ud14c\uc774\ube14\ube14\ub85d \uc218 *\/\n      ,CLUSTERING_FACTOR  \/* \ud14c\uc774\ube14\uc774 \ubaa8\uc778 \uc815\ub3c4 \n                             \ud14c\uc774\ube14\ub808\ucf54\ub4dc\ub97c \ucc3e\uc744 \ub54c \uc77d\uac8c \ub420 \ud14c\uc774\ube14 \ube14\ub85d\uac1c\uc218\uc758 \uac1c\uc0b0\ud55c \uc218 *\/\n      ,SAMPLE_SIZE\n      ,LAST_ANALYZED\n  FROM ALL_INDEXES\n WHERE TABLE_NAME = '\ud14c\uc774\ube14\uba85'\nORDER BY NUM_ROWS DESC\n        ,DISTINCT_KEYS DESC\n;<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-verse\">\uc0c8\ub85c \ub9cc\ub4e0 \ud14c\uc774\ube14\uc778 \uacbd\uc6b0, \ud1b5\uacc4\uc815\ubcf4\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uac70\ub098 \ub370\uc774\ud130\uac74\uc218\uac00 \uc874\uc7ac\ud558\uc9c0\ub9cc 0\uc73c\ub85c \ud45c\ud604\ub420 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.\n\uc774\ub7f0 \uacbd\uc6b0\uc5d0\ub294 DBA\ub4f1 \uad00\ub9ac\uc790\uc5d0\uac8c \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc7ac\uc0dd\uc131\ud574\ub2ec\ub77c\uace0 \ud574\uc57c \ud569\ub2c8\ub2e4.<\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc774\uc804\uc5d0 \ud1b5\uacc4\uc815\ubcf4 \ud655\uc778\uc740 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uac74\uc218\uac00 \uc5bc\ub9c8\ub098 \uc788\ub294\uc9c0\ub97c \uc54c\uc544\ubd24\ub2e4\uba74, \uc774\ubc88\uc5d0\ub294 \uc778\ub371\uc2a4\ub97c \uae30\uc900\uc73c\ub85c \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. ALL_IND_STATISTICS \uc5d0\uc11c\ub3c4 \uac19\uc740 \uc815\ubcf4\ud655\uc778\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \uc54c\uc544\ubcf4\ub294 SQL\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc0c8\ub85c \ub9cc\ub4e0 \ud14c\uc774\ube14\uc778 \uacbd\uc6b0, \ud1b5\uacc4\uc815\ubcf4\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uac70\ub098 \ub370\uc774\ud130\uac74\uc218\uac00 \uc874\uc7ac\ud558\uc9c0\ub9cc 0\uc73c\ub85c \ud45c\ud604\ub420 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7f0 \uacbd\uc6b0\uc5d0\ub294 DBA\ub4f1 \uad00\ub9ac\uc790\uc5d0\uac8c \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc7ac\uc0dd\uc131\ud574\ub2ec\ub77c\uace0 \ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/379"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=379"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions"}],"predecessor-version":[{"id":380,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions\/380"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}