{"id":1184,"date":"2016-01-03T10:11:52","date_gmt":"2016-01-03T10:11:52","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1184"},"modified":"2016-01-03T10:11:52","modified_gmt":"2016-01-03T10:11:52","slug":"%ec%9d%b8%eb%8d%b1%ec%8a%a4-%ec%83%9d%ec%84%b1-%eb%b0%8f-%ec%82%ad%ec%a0%9c%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1184","title":{"rendered":"\uc778\ub371\uc2a4 \uc0dd\uc131 \ubc0f \uc0ad\uc81c\ud558\uae30"},"content":{"rendered":"

\uc778\ub371\uc2a4\ub780 \uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \uc5b4\ub514\uc5d0 \uc788\ub2e4\ub294 \uc704\uce58 \uc815\ubcf4\ub97c \uac00\uc9c4 \uc8fc\uc18c \uac1c\ub150(\ubaa9\ucc28) <\/SPAN><\/P>
\n

\uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9 \ud560 \uacbd\uc6b0 \ucffc\ub9ac \uc18d\ub3c4 \ud5a5\uc0c1 <\/SPAN><\/P>
\n

\ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \ub370\uc774\ud130\ub97c \uc880 \ub354 \ube60\ub974\uace0 \ud6a8\uc728\uc801\uc73c\ub85c \ucc3e\uae30 \uc704\ud574 \uc0ac\uc6a9 \ub428 <\/SPAN><\/P>
\n

   <\/P>
\n

# \uc778\ub371\uc2a4 \uc0dd\uc131 <\/SPAN><\/P>
\n

create [UNIQUE]index INDEX_NAME <\/SPAN><\/P>
\n

on SCHEMA_NAME.TABLE_NAME(COLUMN_NAME1, COLUMN_NAME2 ~~~) ; <\/SPAN><\/P>
\n

   <\/P>
\n

\ub450 \uac1c \uc774\uc0c1\uc758 \uceec\ub7fc\uc744 \uc0ac\uc6a9 \uc2dc \ubcf5\ud569 \uc778\ub371\uc2a4\ub77c \ud568 <\/SPAN><\/P>
\n

   <\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

UNIQUE INDEX: \uc778\ub371\uc2a4 \uceec\ub7fc\uc5d0 \ud558\ub098\uc758 \uac12\ub9cc \uc785\ub825 \uac00\ub2a5. \uc911\ubcf5 \uc548\ub428 <\/SPAN><\/P>
\n

NON-UNIQUE INDEX: \uc911\ubcf5 \uac00\ub2a5 <\/SPAN><\/P>
\n

   <\/P>
\n

\ub2e8\uc77c \uc778\ub371\uc2a4: \uc778\ub371\uc2a4\ub97c \uad6c\uc131\ud558\ub294 \uceec\ub7fc\uc774 \ud55c \uac1c <\/SPAN><\/P>
\n

\ubcf5\ud569 \uc778\ub371\uc2a4: \uc778\ub371\uc2a4\ub97c \uad6c\uc131\ud558\ub294 \uceec\ub7fc\uc774 \ub450 \uac1c \uc774\uc0c1 <\/SPAN><\/P>
\n

   <\/P>
\n

\uc218\ub3d9 \uc778\ub371\uc2a4: \uc0ac\uc6a9\uc790\uac00 \uc9c1\uc811 CREATE \ubb38\uc744 \uc0ac\uc6a9 \ud574 \uc0dd\uc131 <\/SPAN><\/P>
\n

\uc790\ub3d9 \uc778\ub371\uc2a4: QNIQUE\ub098 PRIMARY KEY \uc0dd\uc131\uc5d0 \ub530\ub77c \uc624\ub77c\ud074\uc774 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud568. SYS_\ub85c \uc2dc\uc791 <\/SPAN><\/P>
\n

   <\/P>
\n

# \uc778\ub371\uc2a4 \uc0ad\uc81c <\/SPAN><\/P>
\n

drop index INDEX_NAME ; <\/SPAN><\/P>
\n

ex) drop index BONUS_IDX2 ; <\/SPAN><\/P>
\n

<\/SPAN><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc778\ub371\uc2a4\ub780 \uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \uc5b4\ub514\uc5d0 \uc788\ub2e4\ub294 \uc704\uce58 \uc815\ubcf4\ub97c \uac00\uc9c4 \uc8fc\uc18c \uac1c\ub150(\ubaa9\ucc28) \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9 \ud560 \uacbd\uc6b0 \ucffc\ub9ac \uc18d\ub3c4 \ud5a5\uc0c1 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \ub370\uc774\ud130\ub97c \uc880 \ub354 \ube60\ub974\uace0 \ud6a8\uc728\uc801\uc73c\ub85c \ucc3e\uae30 \uc704\ud574 \uc0ac\uc6a9 \ub428     # \uc778\ub371\uc2a4 \uc0dd\uc131 create [UNIQUE]index INDEX_NAME on SCHEMA_NAME.TABLE_NAME(COLUMN_NAME1, COLUMN_NAME2 ~~~) ;     \ub450 \uac1c \uc774\uc0c1\uc758 \uceec\ub7fc\uc744 \uc0ac\uc6a9 \uc2dc \ubcf5\ud569 \uc778\ub371\uc2a4\ub77c \ud568   […]<\/p>\n","protected":false},"author":1,"featured_media":1185,"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":[3],"tags":[673,674,675],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.253EF7365688F3E515AC0D.png?fit=220%2C72","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1184"}],"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=1184"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1184\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1185"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1184"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}