{"id":462,"date":"2015-09-08T05:33:18","date_gmt":"2015-09-08T05:33:18","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=462"},"modified":"2015-09-08T05:33:18","modified_gmt":"2015-09-08T05:33:18","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-db%ec%9d%98-%ea%b2%b0%ed%95%a9-%ec%9d%b8%eb%8d%b1%ec%8a%a4-%ec%82%ac%ec%9a%a9-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=462","title":{"rendered":"\uc624\ub77c\ud074 DB\uc758 \uacb0\ud569 \uc778\ub371\uc2a4 \uc0ac\uc6a9 \ubc29\ubc95"},"content":{"rendered":"
\n\n\n\n\n\n\n

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

\u25a0 <\/span>\uacb0\ud569\uc778\ub371\uc2a4<\/span>(Composite index)<\/span><\/span><\/b><\/p>\n


<\/b><\/font>
\n <\/span><\/span>\u00b7<\/span>  <\/span><\/b>\uacb0\ud569 \uc778\ub371\uc2a4<\/span>(Composite index)<\/span><\/span><\/b> : <\/span>\ud558\ub098 \uc774\uc0c1\uc758 \uce7c\ub7fc\uc73c\ub85c \uc0dd\uc131\ub41c \uc778\ub371\uc2a4<\/span> <\/span><\/span><\/span><\/p>\n


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


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


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

\u25a0 <\/span>\uacb0\ud569\uc778\ub371\uc2a4\uc758 \uc7a5\uc810<\/span><\/b><\/p>\n


<\/b><\/font>
\n <\/span><\/span>\u00b7<\/span>
\n <\/span><\/b>\uc88b\uc740 \ubd84\ud3ec\ub3c4<\/span> <\/span><\/b>: <\/span>\ub098\uc05c \ubd84\ud3ec\ub3c4\ub97c \uac00\uc9c4<\/span> column<\/span>\uc744 \uacb0\ud569\ud55c \uacb0\ud569 \uc778\ub371\uc2a4\uac00
\n \ub354 \uc88b\uc740 \ubd84\ud3ec\ub3c4\ub97c \uac00\uc9c8 \uc218 \uc788\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

<\/span>
<\/span><\/span><\/span>\u00b7<\/span>
\n <\/span><\/b>\uc800\uc7a5 \uacf5\uac04\uc758 \ud6a8\uc728\uc131<\/span> <\/span><\/b>: <\/span>\ud55c \uc9c8\uc758\uc5d0 \uc758\ud574 \uc120\ud0dd\ub41c \ubaa8\ub4e0 \uce7c\ub7fc\uc774 \uacb0\ud569\uc778\ub371\uc2a4\uc5d0 \uc788\uc744 \uacbd\uc6b0<\/span>,
\n table<\/span>\uc744<\/span> access<\/span>\ud558\uc9c0 \uc54a\uace0 \uacb0\ud569 \uc778\ub371\uc2a4 \ub9cc\uc73c\ub85c \uc6d0\ud558\ub294 \uac12\uc744 \uac00\uc838\uc62c\uc218 \uc788\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n


\n <\/span><\/td>\n<\/tr>\n


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



\n <\/span><\/span>\u25a0 <\/span>\uacb0\ud569\uc778\ub371\uc2a4\uc758 \uc0ac\uc6a9 <\/span><\/b><\/p>\n


<\/b><\/font>
\n <\/span><\/span>\u00b7<\/span> <\/span> <\/span>\uacb0\ud569 \uc778\ub371\uc2a4\uc758 \uc120\ud589 \ubd80\ubd84<\/span>(leading
\n portion)<\/span>\uc744 \uc0ac\uc6a9\ud558\ub294<\/span> SQL<\/span>\ubb38\uc778 \uacbd\uc6b0<\/span>, <\/span>\uacb0\ud569
\n \uc778\ub371\uc2a4\uc5d0 \uc758\ud55c<\/span> access path <\/span>\uc0ac\uc6a9 \uac00\ub2a5 <\/span><\/span><\/p>\n


<\/font>
\n <\/span><\/span>\u00b7<\/span> <\/span> <\/span><\/b>\uc120\ud589\ubd80\ubd84<\/span><\/b> <\/span><\/b>: CREATE INDEX<\/span>\ubb38\uc5d0 \uc758\ud574 \uc0dd\uc131\ub41c \uacb0\ud569 \uc778\ub371\uc2a4\ub97c \uad6c\uc131\ud558\ub294<\/span> column list<\/span>\uc5d0 \uc788\ub294 \uccab \ubc88\uc9f8\ub97c \ud3ec\ud568\ud55c \uc5f0\uc18d\uc801\uc778 \uce7c\ub7fc\uc758 \uc9d1\ud569<\/span>.<\/span><\/span><\/span><\/p>\n


<\/font><\/span><\/span>              \u00b7<\/span>CREATE INDEX comp_ind<\/span>  ON
\n tab1(x, y, z);<\/span><\/span><\/b><\/p>\n


<\/font>
\n <\/span><\/span><\/b>\u00b7<\/span>          <\/span>\uc5ec\uae30\uc11c<\/span> X, XY, XYZ<\/span>\ub294 \uacb0\ud569 \uc778\ub371\uc2a4\uc758 \uc120\ud589 \ubd80\ubd84\uc774\ub2e4<\/span>. <\/span>\uadf8\ub7ec\ub098<\/span> YZ, Z<\/span>\ub294 \uc120\ud589\ubd80\ubd84\uc774 \uc544\ub2c8\ub2e4<\/span>. <\/span><\/span><\/span><\/p>\n


\n <\/span><\/td>\n<\/tr>\n


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


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

\u25a0<\/span> <\/span> <\/span><\/b><\/span>\uacb0\ud569 \uc778\ub371\uc2a4\uc758<\/span> column <\/span>\uc120\ud0dd\uc744 \uc704\ud55c \uc9c0\uce68<\/span><\/span><\/span><\/b><\/span><\/p>\n


\n <\/span><\/td>\n<\/tr>\n


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

\u00b7<\/span> <\/span>\uac01 <\/span>column<\/span>\uc758 \ubd84\ud3ec\ub3c4 \ubcf4\ub2e4 \uacb0\ud569 \uc778\ub371\uc2a4\uc5d0\uc11c \uacb0\ud569\ub41c \ubd84\ud3ec\ub3c4\uac00 \ub354
\n \uc88b\uc744 \uacbd\uc6b0<\/b><\/span>

\n <\/span><\/span><\/span>\u00b7<\/span> <\/span>\uc5ec\ub7ec \uc9c8\uc758\uc5d0\uc11c \ud558\ub098 \uc774\uc0c1\uc758 \uce7c\ub7fc\uac12\uc744 \uac00\uc9c4 \uce7c\ub7fc\uc758 \ub3d9\uc77c\ud55c \uc9d1\ud569\uc744 \uc9c8\uc758 \ud560 \uacbd\uc6b0<\/b><\/span>, <\/span>\uc774\ub4e4
\n \ubaa8\ub4e0 \uce7c\ub7fc\uc744 \ud3ec\ud568\ud558\ub294 \uacb0\ud569 \uc778\ub371\uc2a4 \uc0dd\uc131\uc744 \uace0\ub824\ud55c\ub2e4<\/span>. <\/span>

\n <\/span>
<\/span><\/span>\u25a0<\/span> <\/span> <\/span><\/b><\/span>\uacb0\ud569 \uc778\ub371\uc2a4 \uad6c\uc131\uc2dc<\/span> column <\/span>\uc21c\uc11c \ubc30\uce58\ub97c \uc704\ud55c \uc9c0\uce68 <\/span><\/span><\/b><\/p>\n

<\/b>
<\/b><\/font><\/span><\/span>\u00b7<\/span> WHERE<\/span>\uc808\uc5d0 \uc0ac\uc6a9\ub41c \uce7c\ub7fc\uc744 \uc120\ud589\ubd80\ubd84\uc73c\ub85c \ub9cc\ub4e4\uae30 \uc704\ud55c \uacb0\ud569 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131<\/span><\/span><\/span><\/p>\n


<\/font>
\n <\/span><\/span>\u00b7<\/span> <\/span>\uce7c\ub7fc\uc758 \uc77c\ubd80\uac00<\/span> WHERE<\/span>\uc808\uc5d0\uc11c \uc790\uc8fc \uc0ac\uc6a9\ub420 \uacbd\uc6b0<\/span> => <\/span>\uc790\uc8fc<\/span> select<\/span>\ub418\ub294<\/span> column<\/span>\uc744 \uc120\ud589\ubd80\ubd84\uc62c \ub9cc\ub4e4\uc5b4\uc11c \uc774<\/span> column<\/span>\ub9cc\uc73c\ub85c \uc778\ub371\uc2a4\ub97c
\n \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud55c\ub2e4<\/span>. <\/span><\/span><\/b><\/span><\/p>\n


<\/font>
\n <\/span><\/span>\u00b7<\/span> <\/span>\ubaa8\ub4e0 \uce7c\ub7fc\uc774<\/span> WHERE<\/span>\uc808\uc5d0\uc11c \ub3d9\uc77c\ud558\uac8c \uc0ac\uc6a9\ub418\uba74<\/span> => <\/span>\uc9c8\uc758 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\uae30 \uc704\ud558\uc5ec<\/span>
\n CREATE INDEX statement<\/span>\uc5d0\uc11c \ubd84\ud3ec\ub3c4\uac00 \uc88b\uc740 \uc21c\uc11c\ub300\ub85c \ubc30\uc5f4<\/span><\/span><\/b><\/p>\n


<\/font>
\n <\/span><\/span>\u00b7<\/span> <\/span>\ubaa8\ub4e0 \uce7c\ub7fc\uc774<\/span> WHERE<\/span>\uc808\uc5d0\uc11c \ub3d9\uc77c\ud558\uac8c \uc790\uc8fc \uc0ac\uc6a9\ub418\uc9c0\ub9cc \ub370\uc774\ud130\uac00 \ud55c<\/span> column<\/span>\uc5d0 \ub300\ud574 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ub418\uc5b4 \uc788\uc73c\uba74 <\/span>=> <\/span>\uadf8<\/span> column<\/span>\uc744 \uacb0\ud569 \uc778\ub371\uc2a4\uc758 \uccab\ubc88\uc9f8\ub85c
\n \uad6c\uc131<\/span><\/span><\/b><\/span><\/p>\n


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


\n <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

<\/span><\/div>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"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":[11],"tags":[226,227,228],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/462"}],"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=462"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/462\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=462"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}