{"id":7277,"date":"2019-08-22T17:42:26","date_gmt":"2019-08-23T00:42:26","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=7277"},"modified":"2025-06-13T20:19:35","modified_gmt":"2025-06-14T03:19:35","slug":"primary-uses-for-couchbase-primary-index","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/primary-uses-for-couchbase-primary-index\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uae30\ubcf8 \uc778\ub371\uc2a4\uc758 \uc8fc\uc694 \uc6a9\ub3c4"},"content":{"rendered":"<p>\ucffc\ub9ac \uc11c\ube44\uc2a4\uc6a9 N1QL\uc5d0 \ub300\ud574 \uc790\uc8fc \ubb3b\ub294 \uba87 \uac00\uc9c0 \uc9c8\ubb38\uc785\ub2c8\ub2e4:<\/p>\n<ol>\n<li>\uc2e4\uc81c\ub85c \uae30\ubcf8 \uc778\ub371\uc2a4\ub294 \uc5b8\uc81c \uc0ac\uc6a9\ud558\ub098\uc694?<\/li>\n<li>\uc65c <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/n1ql-index-advisor-improve-query-performance-and-productivity\/\">\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \uad8c\uc7a5\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/a> \uc720\uc77c\ud55c \uc120\ud0dd\uc9c0\uac00 \ub420 \uc218 \uc788\ub294 \uacbd\uc6b0 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc2dc\uaca0\uc2b5\ub2c8\uae4c?<\/li>\n<\/ol>\n<p>\uacc4\uc18d \uc77d\uae30...<\/p>\n<p>\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub294 \ubd84\uc0b0\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4. JSON\uc744 \uc0ac\uc6a9\ud574 \uc720\uc5f0\ud55c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ubc84\ud0b7\uc758 \uac01 \ubb38\uc11c\uc5d0\ub294 \uc0ac\uc6a9\uc790\uac00 \uc0dd\uc131\ud55c \uace0\uc720 \ubb38\uc11c \ud0a4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uace0\uc720\uc131\uc740 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\uac70\ub098 \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \ub3d9\uc548 \uc801\uc6a9\ub429\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \ubb38\uc11c \uc608\uc2dc\uc785\ub2c8\ub2e4.<\/p>\n<pre class=\"theme:eclipse font-size:13 wrap:true whitespace-before:2 whitespace-after:1 lang:mysql decode:true\">select meta().id, travel\r\nfrom `travel-sample` travel\r\nwhere type = 'airline' limit 1;\r\n[\r\n  {\r\n      \"id\": \"airline_10\",\r\n      \"travel\": {\r\n          \"callsign\": \"MILE-AIR\",\r\n          \"country\": \"United States\",\r\n          \"iata\": \"Q5\",\r\n          \"icao\": \"MLA\",\r\n          \"id\": 10,\r\n          \"name\": \"40-Mile Air\",\r\n          \"type\": \"airline\"\r\n          }\r\n      }\r\n  ]<\/pre>\n<pre class=\"theme:eclipse font-size:14 whitespace-before:2 lang:mysql decode:true\">INSERT INTO customer (key, value) VALUES(\u201ccx:123\u201d, {\u201cname\u201d:\u201djoe\u201d, \u201czip\u201d: 94040, \u201cstate\u201d:ca});\r\n\r\nSELECT META().id FROM customer;\r\n\r\ncx:123\r\n<\/pre>\n<p>\uac01 Couchbase \ubc84\ud0b7\uc5d0\ub294 \uace0\uac1d, \uc8fc\ubb38, \uce74\ud0c8\ub85c\uadf8 \ub4f1 \uc5ec\ub7ec \uc720\ud615\uc758 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \"\uc5ec\ud589 \uc0d8\ud50c\" \ub370\uc774\ud130 \uc9d1\ud569\uc744 \ub85c\ub4dc\ud558\uba74 \ud56d\uacf5\uc0ac, \uacf5\ud56d, \ud638\ud154, \uacbd\ub85c, \ub79c\ub4dc\ub9c8\ud06c \ub4f1 \ub2e4\uc12f \uac00\uc9c0 \uc720\ud615\uc758 \ubb38\uc11c\ub97c \ub85c\ub4dc\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub7ec\ub098 \uae30\ubcf8\uc801\uc73c\ub85c Couchbase\uc5d0\ub294 \ubaa8\ub4e0 \ubb38\uc11c\ub97c \ucc98\uc74c\ubd80\ud130 \ub05d\uae4c\uc9c0 \uc2a4\uce94\ud558\ub294 \"\uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\"\uacfc \uac19\uc740 \uae30\ub2a5\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.  \uae30\ubcf8 \uc778\ub371\uc2a4 \uc2a4\uce94\uc740 \"\uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\"\uc5d0 \ud574\ub2f9\ud558\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>\uace0\uac1d\uc5d0 \uae30\ubcf8 \uc778\ub371\uc2a4 ix_customer_primary\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4;<\/p>\n<p>\uae30\ubcf8 \uc0c9\uc778\uc774\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>\ubc84\ud0b7 \uace0\uac1d \ub0b4 \ubaa8\ub4e0 \ubb38\uc11c \uc720\ud615\uc758 \ubaa8\ub4e0 \ubb38\uc11c \ud0a4\uac00 \uc815\ub82c\ub41c \ubaa9\ub85d\uc785\ub2c8\ub2e4.<\/li>\n<li>\ub2e4\ub978 \ubcf4\uc870 \uc778\ub371\uc2a4\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ube44\ub3d9\uae30\uc801\uc73c\ub85c \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/li>\n<li>\ubb38\uc11c \ud0a4\ub9cc \ubcf4\uad00\ud558\uace0 \ub2e4\ub978 \uac83\uc740 \ubcf4\uad00\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ub294 \ubaa8\ub4e0 \uc2a4\uce94 \uc77c\uad00\uc131\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4:\n<ul>\n<li>\ubb34\uc81c\ud55c<\/li>\n<li>AT_PLUS<\/li>\n<li>REQUEST_PLUS<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \uc5d4\uc9c4\uc774 \ubaa8\ub4e0 \ubb38\uc11c\uc5d0 \uc561\uc138\uc2a4\ud55c \ub2e4\uc74c \ud544\ud130\ub9c1, \uc870\uc778, \uc9d1\uacc4 \ub4f1\uc758 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uace0\uac1d\uc5d0\uc11c SELECT * WHERE zip = 94040 \uc774\ub984 \uc774\ub984 = \"joe\" \ubc0f \uc720\ud615 = \"cx\"\ub97c \uc124\uba85\ud569\ub2c8\ub2e4;<\/p>\n<p>\ub290\ub9bd\ub2c8\ub2e4. \ub9e4\uc6b0 \ub290\ub9bd\ub2c8\ub2e4. \ubd88\ud544\uc694\ud55c \ubb38\uc11c \uac00\uc838\uc624\uae30, \ubd88\ud544\uc694\ud55c \ud544\ud130\ub9c1. \uba54\ubaa8\ub9ac\uc640 CPU \ub0ad\ube44. \uae30\ubcf8 \uc2a4\uce94\uc740 \ucffc\ub9ac\uac00 \uacb0\uad6d \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubb38\uc11c\ub97c \ubc18\ud658\ud558\ub294\uc9c0 \uc5ec\ubd80\uc640 \uad00\uacc4\uc5c6\uc774 \ubc84\ud0b7\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \uc720\ud615\uc758 \ubb38\uc11c\ub97c \ubaa8\ub450 \uac80\uc0c9\ud569\ub2c8\ub2e4.  \uae30\ubcf8 \uc2a4\uce94\uc740 \ud14c\uc774\ube14 \uc2a4\uce94\uacfc \ube44\uc2b7\ud558\ub2e4\uace0 \ub9d0\uc500\ub4dc\ub838\uc9c0\ub9cc, \ubaa8\ub4e0 \uc720\ud615\uc758 \ubb38\uc11c\ub97c \ubaa8\ub450 \uc2a4\uce94\ud574\uc57c \ud558\ubbc0\ub85c \ud14c\uc774\ube14 \uc2a4\uce94\ubcf4\ub2e4 \ud6e8\uc52c \ub290\ub9bd\ub2c8\ub2e4.<\/p>\n<p><span style=\"color: #ff0000\"><strong>\uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud574\uc11c\ub294 \uc548 \ub429\ub2c8\ub2e4.  \uc0ac\uc6a9\ud558\uc9c0 \ub9c8\uc138\uc694.  \ud2b9\ud788 \ud504\ub85c\ub355\uc158 \ud658\uacbd\uc5d0\uc11c\ub294 \ub354\uc6b1 \uadf8\ub807\uc2b5\ub2c8\ub2e4.<\/strong><\/span><\/p>\n<p><strong>\u00a0<\/strong>\uadf8\ub807\ub2e4\uba74 \uc65c \uae30\ubcf8 \uc778\ub371\uc2a4\uac00 \uc788\uc744\uae4c\uc694?<\/p>\n<ol>\n<li>\uc0c8\ub85c\uc6b4 \uc0d8\ud50c \ub370\uc774\ud130\ub97c \uac00\uc9c0\uace0 \ub180\uae30 \uc2dc\uc791\ud560 \ub54c\ub294 \ud2b9\uc815 \uc778\ub371\uc2a4 \uc0dd\uc131\uc5d0 \ub300\ud574 \uac71\uc815\ud560 \ud544\uc694 \uc5c6\uc774 \ub300\ubd80\ubd84\uc758 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc2dc\uc810\uc5d0\uc11c\ub294 \ucc98\ub9ac\ub7c9\uc744 \uc870\uc815\ud558\ub294 \uac83\ubcf4\ub2e4 \ub370\uc774\ud130\ub97c \uc774\ud574\ud558\ub294 \uac83\uc774 \uc6b0\uc120\uc785\ub2c8\ub2e4.<\/li>\n<li>\uc2a4\uce94\ud558\ub824\ub294 \uae30\ubcf8 \ud0a4\uc758 \ubc94\uc704\ub97c \uc54c\uace0 \uc788\ub294 \uacbd\uc6b0.\n<ol>\n<li><span class=\"theme:eclipse lang:mysql decode:true crayon-inline\">WHERE META().id between \u201ccx:123\u201d and \u201ccx:458\u201d<\/span><\/li>\n<\/ol>\n<\/li>\n<li>\ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0 <strong>\ud6c4\ud589 <\/strong>\uc544\ub798\uc640 \uac19\uc774 META().id \ud328\ud134\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\n<ol>\n<li><span class=\"theme:eclipse lang:mysql decode:true crayon-inline\">WHERE META().id LIKE \u201ccx:1%\u201d<\/span><\/li>\n<li>\uc0ac\uc6a9\ud558\uc9c0 \ub9c8\uc2ed\uc2dc\uc624: \"%:123\"\uacfc \uac19\uc774. \uc774\ub807\uac8c \ud558\uba74 \uc804\uccb4 \uc2a4\uce94\uc774 \uc218\ud589\ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n<\/li>\n<li>\uc804\uccb4 \uba54\ud0c0().id \ub610\ub294 \uba54\ud0c0().id \ubaa9\ub85d\uc744 \uc54c\uace0 \uc788\ub294 \uacbd\uc6b0 USE KEY\ub97c \uc0ac\uc6a9\ud558\uc5ec \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \ucc38\uc870\ud558\uc9c0 \uc54a\uace0 \ubb38\uc11c\ub97c \uc9c1\uc811 \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<ol>\n<li><span class=\"theme:eclipse lang:mysql decode:true crayon-inline\">FROM customer USE KEYS [\u201ccx:123\u201d]<\/span><\/li>\n<li><span class=\"theme:eclipse lang:mysql decode:true crayon-inline\">FROM customer USE KEYS [\u201ccx:123\u201d, \u201ccx:359\u201d, \u201ccx:948\u201d]<\/span><\/li>\n<li><span class=\"theme:eclipse lang:mysql decode:true crayon-inline\">FROM customer USE KEYS (SELECT raw docid FROM mylist WHERE zip = 94501)<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<h3><b>\uae30\ubcf8 \uc0c9\uc778<\/b><\/h3>\n<p><span style=\"font-weight: 400\">'travel-sample'\uc5d0 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4;<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uae30\ubcf8 \uc778\ub371\uc2a4\ub294 \ub2e8\uc21c\ud788 \uc804\uccb4 \ubc84\ud0b7\uc758 \ubb38\uc11c \ud0a4\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4\uc785\ub2c8\ub2e4. Couchbase \ub370\uc774\ud130 \uacc4\uce35\uc740 \ubb38\uc11c \ud0a4\uc5d0 \uace0\uc720\uc131 \uc81c\uc57d \uc870\uac74\uc744 \uc801\uc6a9\ud569\ub2c8\ub2e4. \uae30\ubcf8 \uc778\ub371\uc2a4\ub294 Couchbase\uc758 \ub2e4\ub978 \ubaa8\ub4e0 \uc778\ub371\uc2a4\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ube44\ub3d9\uae30\uc801\uc73c\ub85c \uc720\uc9c0\ub429\ub2c8\ub2e4.  \ub370\uc774\ud130\uc758 \ucd5c\uc2e0\uc131\uc744 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc740 <\/span><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/architecture\/querying-data-with-n1ql.html\"><span style=\"font-weight: 400\">\uc77c\uad00\uc131 \uc218\uc900<\/span><\/a><span style=\"font-weight: 400\"> \ub97c \uc785\ub825\ud558\uc138\uc694.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc774 \uc778\ub371\uc2a4\uc758 \uba54\ud0c0\ub370\uc774\ud130\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 whitespace-before:01 whitespace-after:1 lang:default decode:true\">select * from system:indexes where name = \u2018#primary\u2019;\r\n\"indexes\": {\r\n  \"datastore_id\": \"https:\/\/127.0.0.1:8091\",\r\n  \"id\": \"f6e3c75d6f396e7d\",\r\n  \"index_key\": [],\r\n  \"is_primary\": true,\r\n  \"keyspace_id\": \"travel-sample\",\r\n  \"name\": \"#primary\",\r\n  \"namespace_id\": \"default\",\r\n  \"state\": \"online\",\r\n  \"using\": \"gsi\"\r\n  }\r\n<\/pre>\n<p><span style=\"font-weight: 400\">\uba54\ud0c0\ub370\uc774\ud130\ub294 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ucd94\uac00 \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4: \uc778\ub371\uc2a4\uac00 \uc788\ub294 \uc704\uce58(datastore_id), \uc778\ub371\uc2a4\uc758 \uc0c1\ud0dc(state), \uc778\ub371\uc2f1 \ubc29\ubc95(\uc0ac\uc6a9) \ub4f1\uc785\ub2c8\ub2e4.<\/span><br \/>\n<span style=\"font-weight: 400\">\uae30\ubcf8 \uc778\ub371\uc2a4\ub294 \ucffc\ub9ac\uc5d0 \ud544\ud130(\uc220\uc5b4)\uac00 \uc5c6\uac70\ub098 \ub2e4\ub978 \uc778\ub371\uc2a4\ub098 \uc561\uc138\uc2a4 \uacbd\ub85c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \uacbd\uc6b0 \uc804\uccb4 \ubc84\ud0b7 \uc2a4\uce94(\uae30\ubcf8 \uc2a4\uce94)\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.   Couchbase\uc5d0\uc11c\ub294 \uc5ec\ub7ec \ud0a4 \uacf5\uac04(\uc11c\ub85c \ub2e4\ub978 \uc720\ud615\uc758 \ubb38\uc11c, \uace0\uac1d, \uc8fc\ubb38, \uc7ac\uace0 \ub4f1)\uc744 \ud558\ub098\uc758 \ubc84\ud0b7\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.   \ub530\ub77c\uc11c \uae30\ubcf8 \uc2a4\uce94\uc744 \uc218\ud589\ud560 \ub54c \ucffc\ub9ac\ub294 \uc0c9\uc778\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubb38\uc11c \ud0a4\ub97c \uac00\uc838\uc624\uace0 \ubc84\ud0b7\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ubb38\uc11c\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ud544\ud130\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4.    \ub530\ub77c\uc11c \uc774\uac83\uc740 \ub9e4\uc6b0 \ube44\uc309\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ubb38\uc11c \ud0a4 \ub514\uc790\uc778\uc740 \uc5ec\ub7ec \ubd80\ubd84\uc73c\ub85c \uad6c\uc131\ub41c \uae30\ubcf8 \ud0a4 \ub514\uc790\uc778\uacfc \ub2e4\uc18c \uc720\uc0ac\ud569\ub2c8\ub2e4.<\/span><\/p>\n<p><span class=\"font-size:17 line-height:20 lang:mysql decode:true crayon-inline\">\uc131:\uc774\ub984:\uace0\uac1dID <\/span><\/p>\n<p><span class=\"font-size:17 line-height:20 lang:mysql decode:true crayon-inline\">Example: smith:john:X1A1849 <\/span><\/p>\n<p><span style=\"font-weight: 400\">Couchbase\uc5d0\uc11c\ub294 \ud0a4 \uc55e\uc5d0 \ubb38\uc11c \uc720\ud615\uc774 \ud3ec\ud568\ub41c \uc811\ub450\uc0ac\ub97c \ubd99\uc774\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.  \uc774 \ubb38\uc11c\ub294 \uace0\uac1d \ubb38\uc11c\uc774\ubbc0\ub85c \uc811\ub450\uc0ac \uc55e\uc5d0 CX\ub97c \ubd99\uc774\uaca0\uc2b5\ub2c8\ub2e4.  \uc774\uc81c \ud0a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 lang:mysql decode:true\">Example: CX:smith:john:X1A1849\r\n<\/pre>\n<p><span style=\"font-weight: 400\">\ub530\ub77c\uc11c \uac19\uc740 \ubc84\ud0b7\uc5d0 \ub2e4\ub978 \uc720\ud615\uc758 \ubb38\uc11c\uac00 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 lang:mysql decode:true\">ORDERS type: \u00a0OD:US:CA:294829\r\n<\/pre>\n<pre class=\"font-size:17 line-height:20 lang:mysql decode:true\">ITEMS \u00a0\u00a0\u00a0type: \u00a0\u00a0IT:KD93823\r\n<\/pre>\n<p><span style=\"font-weight: 400\">\uc774\ub294 \ubaa8\ubc94 \uc0ac\ub840\uc77c \ubfd0\uc785\ub2c8\ub2e4. \ubc84\ud0b7 \ub0b4\uc5d0\uc11c \uace0\uc720\ud574\uc57c \ud55c\ub2e4\ub294 \uc810\uc744 \uc81c\uc678\ud558\uba74 Couchbase\uc5d0\uc11c \ubb38\uc11c \ud0a4\uc758 \ud615\uc2dd\uc774\ub098 \uad6c\uc870\uc5d0\ub294 \uc81c\ud55c\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc774\uc81c \ub2e4\uc591\ud55c \ud0a4\uac00 \uc788\ub294 \ubb38\uc11c\uac00 \uc788\uace0 \uae30\ubcf8 \uc778\ub371\uc2a4\uac00 \uc788\ub294 \uacbd\uc6b0 \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud6a8\uc728\uc801\uc73c\ub85c \uc791\uc5c5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc608 1:  \ud2b9\uc815 \ubb38\uc11c \ud0a4\ub97c \ucc3e\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 whitespace-before:01 whitespace-after:01 lang:mysql decode:true\">SELECT * FROM  sales WHERE META().id = \u201cCX:smith:john:X1A1849\u201d;\r\n\r\n      {\r\n        \"#operator\": \"IndexScan2\",\r\n        \"index\": \"#primary\",\r\n        \"index_id\": \"4c92ab0bcca9690a\",\r\n        \"keyspace\": \"sales\",\r\n        \"namespace\": \"default\",\r\n        \"spans\": [\r\n          {\r\n            \"exact\": true,\r\n            \"range\": [\r\n              {\r\n                \"high\": \"\\\"CX:smith:john:X1A1849\\\"\",\r\n                \"inclusion\": 3,\r\n                \"low\": \"\\\"CX:smith:john:X1A1849\\\"\"\r\n              }\r\n            ]\r\n          }\r\n        ],\r\n<\/pre>\n<p><span style=\"font-weight: 400\">\uc804\uccb4 \ubb38\uc11c \ud0a4\ub97c \uc54c\uace0 \uc788\ub294 \uacbd\uc6b0 \ub2e4\uc74c \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4 \uc561\uc138\uc2a4\ub97c \uc644\uc804\ud788 \ud53c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span class=\"theme:dark-terminal lang:default decode:true crayon-inline\">SELECT * FROM sales USE KEYS [\u201cCX:smith:john:X1A1849\u201d] <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uba85\uc138\uc11c\uc5d0 \ub450 \uac1c \uc774\uc0c1\uc758 \ubb38\uc11c\ub97c \ub123\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 lang:mysql decode:true\">SELECT * FROM sales USE KEYS [\u201cCX:smith:john:X1A1849\u201d, \u201cCX:smithjr:john:X2A1492\u201d]\r\n<\/pre>\n<p><b>\uc608 2:<\/b><span style=\"font-weight: 400\"> \u00a0\ud328\ud134\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.  \ubaa8\ub4e0 \uace0\uac1d \ubb38\uc11c\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 whitespace-before:01 whitespace-after:01 lang:mysql decode:true\">SELECT * FROM  sales WHERE META().id LIKE \u201cCX:%\u201d;\r\n      {\r\n        \"#operator\": \"IndexScan2\",\r\n        \"index\": \"#primary\",\r\n        \"index_id\": \"4c92ab0bcca9690a\",\r\n        \"keyspace\": \"sales\",\r\n        \"namespace\": \"default\",\r\n        \"spans\": [\r\n          {\r\n            \"exact\": true,\r\n            \"range\": [\r\n              {\r\n                \"high\": \"\\\"CX;\\\"\",\r\n                \"inclusion\": 1,\r\n                \"low\": \"\\\"CX:\\\"\"\r\n              }\r\n            ]\r\n          }\r\n        ],\r\n<\/pre>\n<p><b>\uc608 3:<\/b><span style=\"font-weight: 400\"> \u00a0\uc131\uc774 \uc2a4\ubbf8\uc2a4\uc778 \ubaa8\ub4e0 \uace0\uac1d\uc744 \ud655\ubcf4\ud558\uc138\uc694.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ub2e4\uc74c \ucffc\ub9ac\ub294 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \ubc94\uc704\uc758 \uace0\uac1d\ub9cc \uac00\uc838\uc635\ub2c8\ub2e4.<\/span><span style=\"font-weight: 400\"> \u00a0<\/span><b>\ucc38\uace0:<\/b><span style=\"font-weight: 400\"> \uc774 \uc2a4\uce94\uc740 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud569\ub2c8\ub2e4.  \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\ub294 \uc2a4\uce94\uc744 \uc218\ud589\ud558\ub824\uba74 \ubb38\uc11c \ud0a4\uc758 UPPER() \ub610\ub294 LOWER()\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubcf4\uc870 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 whitespace-before:01 whitespace-after:01 lang:mysql decode:true\">SELECT * FROM  sales WHERE META().id LIKE \"CX:smith%\";\r\n\r\n      {\r\n        \"#operator\": \"IndexScan2\",\r\n        \"index\": \"#primary\",\r\n        \"index_id\": \"4c92ab0bcca9690a\",\r\n        \"keyspace\": \"sales\",\r\n        \"namespace\": \"default\",\r\n        \"spans\": [\r\n          {\r\n            \"exact\": true,\r\n            \"range\": [\r\n              {\r\n                \"high\": \"\\\"CX:smiti\\\"\",\r\n                \"inclusion\": 1,\r\n                \"low\": \"\\\"CX:smith\\\"\"\r\n              }\r\n            ]\r\n          }\r\n        ],\r\n<\/pre>\n<p><b>\uc608 4:<\/b><span style=\"font-weight: 400\"> \u00a0\uc77c\ubd80 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \uc774\uba54\uc77c \uc8fc\uc18c\uac00 \uace0\uc720\ud558\uae30 \ub54c\ubb38\uc5d0 \ubb38\uc11c \ud0a4\uc758 \uc77c\ubd80\ub85c \uc774\uba54\uc77c \uc8fc\uc18c\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc77c\ubc18\uc801\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 gmail.com\uc744 \uc0ac\uc6a9\ud558\ub294 \ubaa8\ub4e0 \uace0\uac1d\uc744 \ucc3e\uc544\uc57c \ud569\ub2c8\ub2e4.  \uc774\uac83\uc774 \uc77c\ubc18\uc801\uc778 \uc694\uad6c \uc0ac\ud56d\uc774\ub77c\uba74 \uc774\uba54\uc77c \uc8fc\uc18c\uc758 \uc5ed\ubc29\ud5a5\uc744 \ud0a4\ub85c \uc800\uc7a5\ud558\uace0 \uc120\ud589 \ubb38\uc790\uc5f4 \ud328\ud134\uc744 \uc2a4\uce94\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/span><\/p>\n<p><span class=\"font-size:17 line-height:20 lang:default decode:true crayon-inline\">Email:johnsmith@gmail.com; &amp;nbsp;&amp;nbsp;key: reverse(&#8220;johnsmith@gmail.com&#8221;) =&gt; moc.liamg@htimsnhoj\u00a0<\/span><\/p>\n<p><span class=\"font-size:17 line-height:20 lang:default decode:true crayon-inline\">Email: janesnow@yahoo.com &amp;nbsp;key: reverse(&#8220;janesnow@yahoo.com&#8221;) =&gt; moc.oohay@wonsenaj<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 whitespace-before:1 whitespace-after:1 lang:mysql decode:true\">SELECT *\r\nFROM  sales\r\nWHERE meta().id LIKE (reverse(\"@yahoo.com\") || \"%\");\r\n\r\n        \"#operator\": \"IndexScan2\",\r\n        \"index\": \"#primary\",\r\n        \"index_id\": \"4c92ab0bcca9690a\",\r\n        \"keyspace\": \"sales\",\r\n        \"namespace\": \"default\",\r\n        \"spans\": [\r\n          {\r\n            \"range\": [\r\n              {\r\n                \"high\": \"\\\"moc.oohayA\\\"\",\r\n                \"inclusion\": 1,\r\n                \"low\": \"\\\"moc.oohay@\\\"\"\r\n              }\r\n            ]\r\n          }\r\n        ],\r\n<\/pre>\n<h3><b>\uba85\uba85\ub41c \uae30\ubcf8 \uc0c9\uc778<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Couchbase 5.0\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \ub9e4\uac1c\ubcc0\uc218 CREATE INDEX\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4\uc758 \ubcf5\uc81c\ubcf8\uc744 \uc5ec\ub7ec \uac1c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \ub2e4\uc74c\uc740 \uc778\ub371\uc2a4\uc758 \ubcf5\uc0ac\ubcf8 3\uac1c\ub97c \uc0dd\uc131\ud558\uba70 \ud074\ub7ec\uc2a4\ud130\uc5d0 \ucd5c\uc18c 3\uac1c\uc758 \uc778\ub371\uc2a4 \ub178\ub4dc\uac00 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 lang:mysql decode:true\">CREATE PRIMARY INDEX ON 'travel-sample' WITH {\"num_replica\":2}; \r\nCREATE PRIMARY INDEX `def_primary` ON `travel-sample` ;<\/pre>\n<p><span style=\"font-weight: 400\">\uae30\ubcf8 \uc778\ub371\uc2a4\uc758 \uc774\ub984\uc744 \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8 \uc778\ub371\uc2a4\uc758 \ub098\uba38\uc9c0 \uae30\ub2a5\uc740 \uc778\ub371\uc2a4 \uc774\ub984\uc744 \uc81c\uc678\ud558\uace0\ub294 \ub3d9\uc77c\ud569\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc758 \uc88b\uc740 \uc810\uc740 5.0 \uc774\uc804 Couchbase \ubc84\uc804\uc5d0\uc11c \uc11c\ub85c \ub2e4\ub978 \uc774\ub984\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc5ec\ub7ec \uac1c\uc758 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uac00\uc9c8 \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc911\ubcf5 \uc778\ub371\uc2a4\ub294 \uace0\uac00\uc6a9\uc131\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc778\ub371\uc2a4 \uc804\uccb4\uc5d0 \ucffc\ub9ac \ubd80\ud558\ub97c \ubd84\uc0b0\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.  \uc774\ub294 \uae30\ubcf8 \uc778\ub371\uc2a4\uc640 \ubcf4\uc870 \uc778\ub371\uc2a4 \ubaa8\ub450\uc5d0 \ud574\ub2f9\ub429\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"font-size:17 line-height:20 whitespace-before:1 whitespace-after:01 lang:mysql decode:true\">select meta().id as documentkey, `travel-sample` airline\r\nfrom `travel-sample`\r\nwhere type = 'airline' limit 1;\r\n{\r\n  \"airline\": {\r\n    \"callsign\": \"MILE-AIR\",\r\n    \"country\": \"United States\",\r\n    \"iata\": \"Q5\",\r\n    \"icao\": \"MLA\",\r\n    \"id\": 10,\r\n    \"name\": \"40-Mile Air\",\r\n    \"type\": \"airline\"\r\n  },\r\n  \"documentkey\": \"airline_10\"\r\n}\r\n<\/pre>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, Couchbase 6.5\uc5d0\uc11c\ub294 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub97c \ub3c4\uc785\ud588\uc2b5\ub2c8\ub2e4.  \uc774 \uae30\ub2a5\uc740 \ub2e8\uc77c N1QL \ubb38 \ub610\ub294 \uc6cc\ud06c\ub85c\ub4dc\ub97c \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc5ec\uae30\uc5d0\uc11c \ud655\uc778\ud558\uc138\uc694:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/n1ql-index-advisor-improve-query-performance-and-productivity\/\">N1QL \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800: \ucffc\ub9ac \uc131\ub2a5 \ubc0f \uc0dd\uc0b0\uc131 \ud5a5\uc0c1<\/a><\/li>\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-for-n1ql-query-statement\/\">N1QL \ucffc\ub9ac \ubb38\uc6a9 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800<\/a><\/li>\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-for-query-workload\/\">\ucffc\ub9ac \uc6cc\ud06c\ub85c\ub4dc\ub97c \uc704\ud55c \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800<\/a><\/li>\n<\/ol>\n<p>\uc774 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \uc801\uc808\ud55c \ubcf4\uc870 \uc778\ub371\uc2a4\ub9cc \ucd94\ucc9c\ud558\uace0 \uc8fc \uc778\ub371\uc2a4\ub294 \ucd94\ucc9c\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.  \uc9c0\uae08\uae4c\uc9c0 \uae00\uc744 \uc77d\uc5b4\ubcf4\uc168\ub2e4\uba74 \uadf8 \uc774\uc720\ub97c \uc544\uc2e4 \uac83\uc785\ub2c8\ub2e4! <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/?family=server&amp;product=couchbase-server-developer\">Couchbase 6.5 \ub2e4\uc6b4\ub85c\ub4dc<\/a> \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc744 \ubaa8\ub450 \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694!<\/p>","protected":false},"excerpt":{"rendered":"<p>A couple of frequently asked questions on N1QL for query service: When do we actually use a primary index? Why the index advisor does not recommend the primary index when that may the only choice? Read on&#8230; Couchbase is a [&hellip;]<\/p>","protected":false},"author":55,"featured_media":11848,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[9417,9381,1812],"tags":[1505,1506],"ppma_author":[8929],"class_list":["post-7277","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-performance","category-indexing","category-n1ql-query","tag-index","tag-tuning"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.8 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is the Couchbase Primary Index? Learn Primary Uses<\/title>\n<meta name=\"description\" content=\"What is the Couchbase Primary Index? The primary index scan provides you with the \u201cfull table scan\u201d equivalent for all the documents from start to finish.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/primary-uses-for-couchbase-primary-index\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Primary Uses for Couchbase Primary Index\" \/>\n<meta property=\"og:description\" content=\"What is the Couchbase Primary Index? The primary index scan provides you with the \u201cfull table scan\u201d equivalent for all the documents from start to finish.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/primary-uses-for-couchbase-primary-index\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-23T00:42:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T03:19:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"882\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Keshav Murthy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rkeshavmurthy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keshav Murthy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/\"},\"author\":{\"name\":\"Keshav Murthy\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\"},\"headline\":\"Primary Uses for Couchbase Primary Index\",\"datePublished\":\"2019-08-23T00:42:26+00:00\",\"dateModified\":\"2025-06-14T03:19:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/\"},\"wordCount\":1138,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png\",\"keywords\":[\"Index\",\"Tuning\"],\"articleSection\":[\"High Performance\",\"Indexing\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/\",\"name\":\"What is the Couchbase Primary Index? Learn Primary Uses\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png\",\"datePublished\":\"2019-08-23T00:42:26+00:00\",\"dateModified\":\"2025-06-14T03:19:35+00:00\",\"description\":\"What is the Couchbase Primary Index? The primary index scan provides you with the \u201cfull table scan\u201d equivalent for all the documents from start to finish.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png\",\"width\":1200,\"height\":882},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Primary Uses for Couchbase Primary Index\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\",\"name\":\"Keshav Murthy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"caption\":\"Keshav Murthy\"},\"description\":\"Keshav Murthy is a Vice President at Couchbase R&amp;D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design &amp; development. He lead the SQL and NoSQL R&amp;D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India, holds eleven US patents and has four US patents pending.\",\"sameAs\":[\"https:\/\/blog.planetnosql.com\/\",\"https:\/\/x.com\/rkeshavmurthy\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/keshav-murthy\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What is the Couchbase Primary Index? Learn Primary Uses","description":"What is the Couchbase Primary Index? The primary index scan provides you with the \u201cfull table scan\u201d equivalent for all the documents from start to finish.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/primary-uses-for-couchbase-primary-index\/","og_locale":"ko_KR","og_type":"article","og_title":"Primary Uses for Couchbase Primary Index","og_description":"What is the Couchbase Primary Index? The primary index scan provides you with the \u201cfull table scan\u201d equivalent for all the documents from start to finish.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/primary-uses-for-couchbase-primary-index\/","og_site_name":"The Couchbase Blog","article_published_time":"2019-08-23T00:42:26+00:00","article_modified_time":"2025-06-14T03:19:35+00:00","og_image":[{"width":1200,"height":882,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png","type":"image\/png"}],"author":"Keshav Murthy","twitter_card":"summary_large_image","twitter_creator":"@rkeshavmurthy","twitter_misc":{"Written by":"Keshav Murthy","Est. reading time":"7\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/"},"author":{"name":"Keshav Murthy","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636"},"headline":"Primary Uses for Couchbase Primary Index","datePublished":"2019-08-23T00:42:26+00:00","dateModified":"2025-06-14T03:19:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/"},"wordCount":1138,"commentCount":2,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png","keywords":["Index","Tuning"],"articleSection":["High Performance","Indexing","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/","url":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/","name":"What is the Couchbase Primary Index? Learn Primary Uses","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png","datePublished":"2019-08-23T00:42:26+00:00","dateModified":"2025-06-14T03:19:35+00:00","description":"What is the Couchbase Primary Index? The primary index scan provides you with the \u201cfull table scan\u201d equivalent for all the documents from start to finish.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Couchbase-primary-index-gsi-global-secondary-index.png","width":1200,"height":882},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/primary-uses-for-couchbase-primary-index\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Primary Uses for Couchbase Primary Index"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636","name":"\ucf00\uc0e4\ube0c \uba38\uc2dc","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4","url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","caption":"Keshav Murthy"},"description":"\ucf00\uc0e4\ube0c \uba38\uc2dc\ub294 Couchbase R&amp;D\uc758 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uc774\uc804\uc5d0\ub294 MapR, IBM, Informix, Sybase\uc5d0\uc11c \uadfc\ubb34\ud588\uc73c\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uac1c\ubc1c \ubd84\uc57c\uc5d0\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ub825\uc744 \uc313\uc558\uc2b5\ub2c8\ub2e4. IBM Informix\uc5d0\uc11c SQL \ubc0f NoSQL R&amp;D \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \ub450 \ucc28\ub840\uc758 President's Club \uc0c1\uc744, IBM\uc5d0\uc11c \ub450 \ucc28\ub840\uc758 Outstanding Technical Achievement Award\ub97c \uc218\uc0c1\ud588\uc2b5\ub2c8\ub2e4. \uc778\ub3c4 \ub9c8\uc774\uc18c\ub974 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70, 11\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uace0 4\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ucd9c\uc6d0 \uc911\uc785\ub2c8\ub2e4.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/keshav-murthy\/"}]}},"authors":[{"term_id":8929,"user_id":55,"is_guest":0,"slug":"keshav-murthy","display_name":"Keshav Murthy","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","author_category":"","last_name":"Murthy","first_name":"Keshav","job_title":"","user_url":"https:\/\/blog.planetnosql.com\/","description":"\ucf00\uc0e4\ube0c \uba38\uc2dc\ub294 Couchbase R&amp;D\uc758 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uc774\uc804\uc5d0\ub294 MapR, IBM, Informix, Sybase\uc5d0\uc11c \uadfc\ubb34\ud588\uc73c\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uac1c\ubc1c \ubd84\uc57c\uc5d0\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ub825\uc744 \uc313\uc558\uc2b5\ub2c8\ub2e4. IBM Informix\uc5d0\uc11c SQL \ubc0f NoSQL R&amp;D \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \ub450 \ubc88\uc758 President's Club \uc0c1\uc744, IBM\uc5d0\uc11c \ub450 \ubc88\uc758 \uc6b0\uc218 \uae30\uc220 \uc5c5\uc801\uc0c1\uc744 \uc218\uc0c1\ud588\uc2b5\ub2c8\ub2e4. \uc778\ub3c4 \ub9c8\uc774\uc18c\ub974 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70, 10\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uace0 3\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ucd9c\uc6d0 \uc911\uc785\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/7277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=7277"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/7277\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/11848"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=7277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=7277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=7277"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=7277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}