{"id":4662,"date":"2021-11-04T14:22:59","date_gmt":"2021-11-04T05:22:59","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4662"},"modified":"2021-11-04T14:23:56","modified_gmt":"2021-11-04T05:23:56","slug":"skip_unusable_indexes-%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b0-%ec%84%a4%eb%aa%85","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4662","title":{"rendered":"skip_unusable_indexes \ud30c\ub77c\ubbf8\ud130 \uc124\uba85"},"content":{"rendered":"

 <\/p>\n

partition index \uac00 Index Unusable<\/strong> (IU) \uc0c1\ud0dc\uac00 \ub418\uc5c8\uc744 \ub54c \uadf8 partition index\uc744 \uc0ac\uc6a9 \ud558\uac8c \ub418\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uac8c \ub41c\ub2e4.<\/span><\/p>\n

 <\/p>\n

SQL> SELECT \/*+ INDEX(A A_IDX1) *\/ * FROM SALES A WHERE PROD_ID >= 10000<\/strong><\/p>\n

 <\/p>\n

ORA-01502: \uc778\ub371\uc2a4 ‘A_IDX1’ \ub610\ub294 \uc778\ub371\uc2a4 \ubd84\ud560\uc601\uc5ed\uc740 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud0dc\uc774\ub2e4.<\/p>\n

 <\/p>\n

\uc774\uc640 \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\uc2dc \ud574\ub2f9 \ud30c\ud2f0\uc158\uc744 \ud574\ub2f9 \uc778\ub371\uc2a4\ub97c \ud1b5\ud574\uc11c \uc5d1\uc138\uc2a4 \ud560 \uc218 \uc5c6\uac8c \ub428\uc73c\ub85c <\/span><\/p>\n

\ud574\ub2f9 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc218\ud589\uc744 \uc720\uc9c0 \ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669\uc774 \ubc1c\uc0dd\ud558\uac8c \ub41c\ub2e4. <\/span><\/p>\n

\ubb3c\ub860 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 \ud574\ub2f9 \ud30c\ud2f0\uc158\uc744 TABLE FULL SCAN \ud558\uba74 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/strong> <\/span><\/p>\n

\u00a0<\/span><\/p>\n

\ud558\uc9c0\ub9cc \uc635\ud2f0\ub9c8\uc774\uc838\uac00 \uc2e4\ud589\uacc4\ud68d \uc218\ub9bd \uc2dc\uc5d0 INDEX UNUSABLE \uc0c1\ud0dc \uc5ec\ubd80\ub97c \uccb4\ud06c\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c \ud574\ub2f9 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uc2e4\ud589\uacc4\ud68d\uc774 \uc218\ub9bd\ub418\uace0<\/span><\/strong><\/span><\/p>\n

\uc2e4\uc81c \uc218\ud589 \uc2dc \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uac8c \ub428\uc73c\ub85c<\/span><\/strong> \uc774\ubbf8 \uc6b4\uc6a9\uc911\uc778 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc774\ub098 SQL\uc774 \uc815\uc0c1 \uc218\ud589\ub418\uc9c0 \uc54a\ub294\ub2e4. <\/span><\/p>\n

\u00a0<\/span><\/p>\n

\uc774\ub7f4 \uacbd\uc6b0\uc5d0\ub294 <\/span><\/p>\n

\u00a0<\/span><\/p>\n

skip_unusable_indexes = TRUE<\/span><\/strong> <\/span><\/p>\n

\u00a0<\/span><\/p>\n

\ud30c\ub77c\ubbf8\ud130\ub97c \uc9c0\uc815\ud558\uba74 <\/span><\/p>\n

\uc218\ud589 \uc2dc\uc5d0 \ud574\ub2f9 \uc778\ub371\uc2a4\uac00 UNUSABLE\uc774\uba74 \uc774\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 TABLE FULL SCAN \ub4f1\uc744 \ud55c\ub2e4.<\/span><\/p>\n

 <\/p>\n

\uacbd\uc6b0\uc5d0 \ub530\ub77c\uc11c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9 \uac00\ub2a5\ud558\ubbc0\ub85c \uace0\ub824 \ud574 \ubcfc \uc218 \uc788\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

  partition index \uac00 Index Unusable (IU) \uc0c1\ud0dc\uac00 \ub418\uc5c8\uc744 \ub54c \uadf8 partition index\uc744 \uc0ac\uc6a9 \ud558\uac8c \ub418\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uac8c \ub41c\ub2e4.   SQL> SELECT \/*+ INDEX(A A_IDX1) *\/ * FROM SALES A WHERE PROD_ID >= 10000   ORA-01502: \uc778\ub371\uc2a4 ‘A_IDX1’ \ub610\ub294 \uc778\ub371\uc2a4 \ubd84\ud560\uc601\uc5ed\uc740 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud0dc\uc774\ub2e4.   \uc774\uc640 \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\uc2dc \ud574\ub2f9 \ud30c\ud2f0\uc158\uc744 \ud574\ub2f9 […]<\/p>\n","protected":false},"author":1,"featured_media":4522,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[1240,1238,1239,1237],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2021\/11\/troubleshoot.png?fit=680%2C345","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4662"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4662"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4662\/revisions"}],"predecessor-version":[{"id":4664,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4662\/revisions\/4664"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/4522"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4662"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}