{"id":429,"date":"2024-01-02T14:30:43","date_gmt":"2024-01-02T05:30:43","guid":{"rendered":"http:\/\/www.space4u.co.kr\/wp\/?p=429"},"modified":"2024-01-02T14:30:44","modified_gmt":"2024-01-02T05:30:44","slug":"mysql-%ec%9d%b8%eb%8d%b1%ec%8a%a4index-%ec%99%80-%ec%bb%ac%eb%9f%bc-%ec%a4%91%eb%b3%b5%eb%8f%84cardinality%ec%9d%98-%ea%b4%80%ea%b3%84-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/www.space4u.co.kr\/wp\/?p=429","title":{"rendered":"Mysql \uc778\ub371\uc2a4(index) \uc640 \uceec\ub7fc \uc911\ubcf5\ub3c4(Cardinality)\uc758 \uad00\uacc4 \uc815\ub9ac"},"content":{"rendered":"\n

\uc911\ubcf5\ub3c4\uac00 \ub0ae\uc73c\uba74 \uce74\ub514\ub110\ub9ac\ud2f0(Cardinality)\uac00 \ub192\ub2e4\uace0 \ud45c\ud604\ud558\uace0, \uc911\ubcf5\ub3c4\uac00 \ub192\uc73c\uba74 \uce74\ub514\ub110\ub9ac\ud2f0\uac00 \ub0ae\ub2e4\uace0 \ud45c\ud604\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc778\ub371\uc2a4\uc640\uc758 \uad00\uacc4\ub294 \uc911\ubcf5\ub3c4\uac00 \ub0ae\uc73c\uba74 \ud6a8\uc728\uc774 \ub192\uc544\uc9c0\uace0, \uc911\ubcf5\ub3c4\uac00 \ub192\uc73c\uba74 \ud6a8\uc728\uc774 \ub0ae\uc544\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc911\ubcf5\ub3c4\uac00 \ub0ae\ub2e4\ub294 \uac83\uc740 \ud2b9\uc815 \uceec\ub7fc\uc758 \ub370\uc774\ud130\uac00 \uac01\uae30 \ub2e4\ub978 \uac12\uc774 \ub4e4\uc5b4\uac04\ub2e4\ub294 \ub73b\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n

\ud504\ub77c\uc774\uba38\ub9ac \ud0a4(pk)\ub098, \uc8fc\ubbfc\ubc88\ud638 \uac19\uc740 \uc720\uc77c\uac12\uc77c \uc218\ub3c4 \uc788\uace0 \ud480\ub124\uc784 \uac19\uc774 \uc911\ubcf5\uc740 \uc788\uc9c0\ub9cc \uadf8\ub9ac \uc911\ubcf5\uc774 \ub9ce\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uceec\ub7fc\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\ubc18\uba74 \uc911\ubcf5\ub3c4\uac00 \ub192\ub2e4\ub294 \uac83\uc740 \uac19\uc740 \uac12\uc774 \ub9ce\uc774 \ub4e4\uc5b4\uac00\ub294 \uceec\ub7fc\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc790\uba74 \uc131\ubcc4 \uceec\ub7fc \uc815\ub3c4 \ub418\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

1000\ub9cc\uac74\uc758 \ub370\uc774\ud130\uac00 \ub4e4\uc5b4\uac00 \uc788\uc5b4\ub3c4 \ub0a8\uc790, \uc5ec\uc790, \uae30\ud0c0 \uc815\ub3c4 \ub4e4\uc5b4\uac08 \ud14c\ub2c8\uae50 \uc911\ubcf5\ub41c \ub370\uc774\ud130\uac00 \uac81\ub098\uac8c \ub9ce\uaca0\uc8e0.<\/p>\n\n\n\n

\uc778\ub371\uc2a4\ub97c \uc124\uc815\ud560\ub54c, pk \uac19\uc774 \uc911\ubcf5\ub3c4\uac00 \ub192\uc740 \uceec\ub7fc\uc5d0\ub294 \ud6a8\uc728\uc774 \ub192\uc9c0\ub9cc, \uc131\ubcc4\uac19\uc774 \uc911\ubcf5\ub3c4\uac00 \ub192\uc740 \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4\ub97c \uac78\uba74 \ub3c4\ub9ac\uc5b4 row\uac00 \ub298\uc5b4\ub098\uba74 \ub298\uc5b4\ub0a0 \uc218\ub85d \ud6a8\uc728\uc131\uc744 \ub5a8\uc5b4\ub728\ub9bd\ub2c8\ub2e4.(\uc5c5\ub370\uc774\ud2b8, \uc778\uc11c\ud2b8\uc2dc \uc131\ub2a5\uc774 \ud655!!! \ub5a8\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n

\ub530\ub77c\uc11c \uc911\ubcf5\ub3c4\uac00 \ub192\uc740 \uceec\ub7fc\uc5d0\ub9cc \uc778\ub371\uc2a4\ub97c \uc124\uc815\ud560 \uac83\uc744 \uad8c\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc911\ubcf5\ub3c4\ub97c \uc870\ud68c\ud558\ub294 \ubc29\ubc95\uc740 \uc544\ub798 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

show index from \ud14c\uc774\ube14\uc774\ub984;<\/pre>\n\n\n\n
\uc870\ud68c\ub418\ub294 \ub0b4\uc6a9\uc911\uc5d0 Cardinality \uac12\uc774 \uc791\uc740 column\uc5d0\ub294 \uc778\ub371\uc2a4\ub97c \uac78\uc9c0 \ub9c8\uc138\uc694.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"
\uc911\ubcf5\ub3c4\uac00 \ub0ae\uc73c\uba74 \uce74\ub514\ub110\ub9ac\ud2f0(Cardinality)\uac00 \ub192\ub2e4\uace0 \ud45c\ud604\ud558\uace0, \uc911\ubcf5\ub3c4\uac00 \ub192\uc73c\uba74 \uce74\ub514\ub110\ub9ac\ud2f0\uac00 \ub0ae\ub2e4\uace0 \ud45c\ud604\ud569\ub2c8\ub2e4. \uc778\ub371\uc2a4\uc640\uc758 \uad00\uacc4\ub294 \uc911\ubcf5\ub3c4\uac00 \ub0ae\uc73c\uba74 \ud6a8\uc728\uc774 \ub192\uc544\uc9c0\uace0, \uc911\ubcf5\ub3c4\uac00 \ub192\uc73c\uba74 \ud6a8\uc728\uc774 \ub0ae\uc544\uc9d1\ub2c8\ub2e4. \uc911\ubcf5\ub3c4\uac00 \ub0ae\ub2e4\ub294 \uac83\uc740 \ud2b9\uc815 \uceec\ub7fc\uc758…<\/p>\n
\ub354 \uc77d\uae30Mysql \uc778\ub371\uc2a4(index) \uc640 \uceec\ub7fc \uc911\ubcf5\ub3c4(Cardinality)\uc758 \uad00\uacc4 \uc815\ub9ac<\/span> <\/i><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,4],"tags":[424,433,428,437,115,434,435,425,440,427,439,426,432,423,431],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/429"}],"collection":[{"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=429"}],"version-history":[{"count":1,"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions"}],"predecessor-version":[{"id":430,"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions\/430"}],"wp:attachment":[{"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.space4u.co.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}