{"id":3676,"date":"2017-06-21T08:06:12","date_gmt":"2017-06-21T15:06:12","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=3676"},"modified":"2025-06-13T20:20:21","modified_gmt":"2025-06-14T03:20:21","slug":"n1ql-performance-feature-enhancements-couchbase-5-0","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/n1ql-performance-feature-enhancements-couchbase-5-0\/","title":{"rendered":"Couchbase 5.0\uc758 N1QL \uc131\ub2a5 \ubc0f \uae30\ub2a5 \uac1c\uc120 \uc0ac\ud56d"},"content":{"rendered":"<p>Couchbase 5.0\uc758 \uc548\uc815\uc801\uc778 \ub9b4\ub9ac\uc2a4\uac00 \uc784\ubc15\ud588\uc73c\ubbc0\ub85c N1QL \uae30\uc220\uacfc \ud568\uaed8 \uc81c\uacf5\ub418\ub294 \uc131\ub2a5 \ubc0f \uae30\ub2a5 \uac1c\uc120 \uc0ac\ud56d \uc911 \uc77c\ubd80\ub97c \ub2e4\uc2dc \uc0b4\ud3b4\ubcf4\ub294 \uac83\ub3c4 \uc88b\uc740 \uc0dd\uac01\uc785\ub2c8\ub2e4.<\/p>\n<p><!--more--><\/p>\n<p>\uadf8\ub807\ub2e4\uba74 \uc131\ub2a5\uacfc \uad00\ub828\ud558\uc5ec \uc5b4\ub5a4 \uac1c\uc120\uc774 \uc774\ub8e8\uc5b4\uc84c\uc744\uae4c\uc694?<\/p>\n<h2>N1QL\uc758 \uc131\ub2a5 \ud5a5\uc0c1<\/h2>\n<p>\uc778\ub371\uc2a4 \ud22c\uc601\uc744 \uc608\ub85c \ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.  \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4 \ub54c \uc6d0\ud558\ub294 \uc218\uc758 \uc18d\uc131\uc73c\ub85c \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c \uc778\ub371\uc2a4\ub97c \uc608\ub85c \ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">\uae30\ubcf8\uac12(\uc720\ud615, \uc774\ub984, \uc131)\uc5d0 \uc778\ub371\uc2a4 idx\ub97c \ub9cc\ub4ed\ub2c8\ub2e4;<\/pre>\n<p>\uc704\uc758 \uba85\ub839\ubb38\uc740 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uc5d0\u00a0<code>\uae30\ubcf8\uac12<\/code> \ubc84\ud0b7\uc6a9\u00a0<code>\uc720\ud615<\/code>, <code>\uc774\ub984<\/code>\ubc0f\u00a0<code>\uc131<\/code> \uc18d\uc131\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \ub2e4\uc74c\uacfc \uac19\uc740 N1QL \ucffc\ub9ac\ub97c \uc0dd\uc131\ud558\uc5ec \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc11c \uba87 \uac1c\ub97c \uac80\uc0c9\ud55c\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.\u00a0<code>idx<\/code> \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud588\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">SELECT firstname\r\nFROM default\r\nWHERE type = 'person'<\/pre>\n<p>\uc704\uc758 \ucffc\ub9ac\ub294\u00a0<code>idx<\/code> \uc0c9\uc778\uc744 \uc0dd\uc131\ud558\uace0\u00a0<code>\uc774\ub984<\/code>\u00a0\uc18d\uc131\uc744 \ucffc\ub9ac\ud569\ub2c8\ub2e4.  \uc774\ub7ec\ud55c \ubc29\uc2dd\uc73c\ub85c \ucffc\ub9ac\ud558\ub294 \uac1c\ub150\uc740 \uc0c8\ub85c\uc6b4 \uac83\uc740 \uc544\ub2c8\uc9c0\ub9cc, \uadf8 \uc774\uba74\uc5d0\uc11c \uc77c\uc5b4\ub098\ub294 \uc77c\uc740 \ub2ec\ub77c\uc84c\uc2b5\ub2c8\ub2e4.  \uc778\ub371\uc2a4\uc5d0 \ub9ce\uc740 \ud0a4\uac00 \uc788\ub354\ub77c\ub3c4 \ud558\uc704 \uc9d1\ud569, \uc989 \uc774 \uacbd\uc6b0\uc5d0\ub294 \ub450 \uac1c\uc758 \ud0a4\uc5d0\ub9cc \uad00\uc2ec\uc774 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub807\ub2e4\uba74 \ubb34\uc2a8 \uc77c\uc774 \uc77c\uc5b4\ub098\uace0 \uc788\uc73c\uba70 \uc774\uac83\uc774 \uc911\uc694\ud55c \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/p>\n<p>\uc774\uc804 \ubc84\uc804\uc758 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc5d0\uc11c\ub294 \ud558\uc704 \uc9d1\ud569\ub9cc \uc0ac\uc6a9\ub418\ub354\ub77c\ub3c4 \uc778\ub371\uc2a4\uc758 \ubaa8\ub4e0 \ud0a4\uac00 \uace0\ub824\ub418\uc5c8\uc2b5\ub2c8\ub2e4.  \uadf8 \uacb0\uacfc, \ub354 \ub9ce\uc740 \ub124\ud2b8\uc6cc\ud06c, CPU, \uba54\ubaa8\ub9ac\uac00 \ud544\uc694\ud588\uc2b5\ub2c8\ub2e4.  \uc774\uc81c \ub354 \uc774\uc0c1 \uadf8\ub807\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub807\ub2e4\uba74 \uc778\ub371\uc2a4 \ud22c\uc601\uc774 \uc77c\uc5b4\ub098\uace0 \uc788\ub294\uc9c0 \uc5b4\ub5bb\uac8c \uc54c \uc218 \uc788\uc744\uae4c\uc694?<\/p>\n<p>\ub2e4\uc74c\uc744 \uc218\ud589\ud558\uc2ed\uc2dc\uc624.\u00a0<code>\uc124\uba85<\/code> \ub97c \uc2e4\ud589 \uc911\uc778 \ucffc\ub9ac\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">EXPLAIN SELECT firstname\r\nFROM default\r\nWHERE type = 'person'<\/pre>\n<p>\uacb0\uacfc\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.\u00a0<code>index_projection<\/code> \ub2e4\uc74c\uacfc \uac19\uc774 \ubcf4\uc785\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">...\r\n\"index_projection\": {\r\n    \"entry_keys\": [\r\n        0,\r\n        1\r\n    ]\r\n},\r\n...<\/pre>\n<p>\uadf8\ub9ac\uace0\u00a0<code>entry_keys<\/code> \uc18d\uc131\uc740 \ucffc\ub9ac\uc5d0 \ub530\ub77c \ubcc0\uacbd\ub429\ub2c8\ub2e4.  \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc774 \ucd94\uac00\ud558\uba74 \uc5b4\ub5bb\uac8c \ub418\ub098\uc694?\u00a0<code>\uc5b4\ub514<\/code> \uc870\uac74\uc73c\ub85c \uc124\uc815\ud560 \uc218 \uc788\ub098\uc694?<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">SELECT firstname\r\nFROM default\r\nWHERE type = 'person' AND lastname = 'Nic'<\/pre>\n<p>\uc704\uc758 \uc2dc\ub098\ub9ac\uc624\uc5d0\uc11c, \uc6b0\ub9ac\ub294\u00a0<code>\uc124\uba85<\/code> \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">...\r\n\"index_projection\": {\r\n    \"entry_keys\": [\r\n        0,\r\n        1,\r\n        2\r\n    ]\r\n},\r\n...<\/pre>\n<p>\uc774\uc81c \uc704\uc758 \ucffc\ub9ac\ub294 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uc758 \ubaa8\ub4e0 \ud0a4\ub97c \uc0ac\uc6a9\ud588\uae30 \ub54c\ubb38\uc5d0 \uc778\ub371\uc2a4 \ud22c\uc601\uc774 \uc544\ub2d9\ub2c8\ub2e4.<\/p>\n<p>\uc778\ub371\uc2a4 \ud22c\uc601\uacfc \ud568\uaed8 \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\uba74 \uc804\ubc18\uc801\uc778 \uc131\ub2a5\uacfc Couchbase Server \ud074\ub7ec\uc2a4\ud130 \ud655\uc7a5\uc5d0 \ud070 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>2017\ub144 3\uc6d4 \ube4c\ub4dc\uc5d0\uc11c \uac1c\uc120\ub41c \uc131\ub2a5\uc740 \uc778\ub371\uc2a4 \ud22c\uc601\ubfd0\uc774 \uc544\ub2c8\uc5c8\ub098\uc694?  \ub9de\uc2b5\ub2c8\ub2e4, \ub354 \uc788\uc2b5\ub2c8\ub2e4!<\/p>\n<p>\uc774\uc81c\u00a0<code>count(distinct)<\/code> \uc5f0\uc0b0\uc744 \uc608\ub85c \ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.  \uc774\uc81c \ub2e4\uc74c \ucffc\ub9ac\uc5d0\uc11c \ud574\ub2f9 \uc5f0\uc0b0\uc744 \uc0ac\uc6a9\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">EXPLAIN SELECT COUNT(DISTINCT type)\r\nFROM default;<\/pre>\n<p>\uacb0\uacfc\uc5d0\uc11c \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.\u00a0<code>\uc778\ub371\uc2a4 \uce74\uc6b4\ud2b8 \ub514\uc2a4\ud305\ud2b8 \uc2a4\uce942<\/code> \uadf8\ub9ac\uace0 \uadf8\uac83\uc774\ud558\ub294 \uc77c\uc740 \ubaa8\ub4e0 \uac83\uc744 \uc800\uc7a5\ud558\ub294 \uac83\uc785\ub2c8\ub2e4\u00a0<code>\uc720\ud615<\/code> \ub97c \uc778\ub371\uc2a4\uc5d0 \ucd94\uac00\ud558\uace0 \uace0\uc720 \uac12\uc744 \ucc98\ub9ac\ud569\ub2c8\ub2e4.  \uc774 \uc791\uc5c5\uc740 Couchbase 5.0\uc758 \uc778\ub371\uc11c\uc5d0\uc11c \ubc1c\uc0dd\ud558\uc9c0\ub9cc, \uc774\uc804 \ubc84\uc804\uc5d0\uc11c\ub294 N1QL \uc11c\ube44\uc2a4\uc5d0\uc11c \ubc1c\uc0dd\ud588\uc2b5\ub2c8\ub2e4.  \uc778\ub371\uc11c\uc5d0\uc11c \uc774 \uc791\uc5c5\uc744 \uc624\ud504\ub85c\ub4dc\ud568\uc73c\ub85c\uc368 \uc0c1\ub2f9\ud55c \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uacbd\ud5d8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\ucc2c\uac00\uc9c0\ub85c\u00a0<code>\uc624\ud504\uc14b<\/code>,\u00a0<code>LIMIT<\/code>\ubc0f\u00a0<code>\uc8fc\ubb38 \uae30\uc900<\/code> \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc608\ub85c \ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">EXPLAIN SELECT firstname\r\nFROM default\r\nWHERE type = 'person'\r\nORDER BY firstname\r\nLIMIT 1\r\nOFFSET 1;<\/pre>\n<p>\uc5ec\ub7ec\ubd84\uc740\u00a0<code>LIMIT<\/code>, <code>\uc8fc\ubb38 \uae30\uc900<\/code>\ubc0f\u00a0<code>\uc624\ud504\uc14b<\/code> \uc5f0\uc0b0\uc790\uac00 \uc0c9\uc778\uae30\uc5d0 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.  5.0 \uc774\uc804\uc5d0\ub294 <code>LIMIT<\/code> \uc5f0\uc0b0\uc790\ub9cc \uc778\ub371\uc11c\uc5d0 \ud45c\uc2dc\ub418\uc5c8\uc9c0\ub9cc \uc774\uc81c\ub294 \ub2e4\ub978 \uc5f0\uc0b0\uc790\ub4e4\ub3c4 \ud45c\uc2dc\ub429\ub2c8\ub2e4.  \uc774\uc804 \ubc84\uc804\uc758 Couchbase\uc5d0\uc11c\ub294 \uacb0\uacfc\ub97c \uc624\ud504\uc14b\ud560 \uacbd\uc6b0 N1QL\uc774 X\ub9cc\ud07c\uc758 \uacb0\uacfc\ub97c \ubaa8\ub450 \uac00\uc838\uc624\uace0 \uc624\ud504\uc14b \uc774\uc804\uc758 \ubaa8\ub4e0 \uacb0\uacfc\ub97c \uc0ad\uc81c\ud588\uae30 \ub54c\ubb38\uc5d0 \uc774\uac83\uc740 \ud070 \uc2b9\ub9ac\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c N1QL \ubc0f \uc778\ub371\uc2f1 \uae30\ub2a5 \uac1c\uc120\uc5d0 \ub300\ud55c \uc8fc\uc81c\ub85c \ub118\uc5b4\uac00\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<h2>\uac04\uc18c\ud654\ub41c \ubc30\uc5f4 \uc778\ub371\uc2f1<\/h2>\n<p>Couchbase Server 4.5\uc5d0\ub294 \ubc30\uc5f4 \uc778\ub371\uc2f1 \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \uc0d8\ud50c \ubb38\uc11c\ub97c \uc608\ub85c \ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">{\r\n  \"type\": \"person\",\r\n  \"firstname\": \"Nic\",\r\n  \"lastname\": \"Raboy\",\r\n  \"social-media\": [\r\n    {\r\n      \"type\": \"twitter\",\r\n      \"url\": \"https:\/\/www.twitter.com\/nraboy\"\r\n    },\r\n    {\r\n      \"type\": \"website\",\r\n      \"url\": \"https:\/\/www.thepolyglotdeveloper.com\"\r\n    }\r\n  ]\r\n}<\/pre>\n<h3>\uc0c8\ub85c\uc6b4 \ubc30\uc5f4 \uc778\ub371\uc2a4 \uad6c\ubb38<\/h3>\n<p>Couchbase 5.0 \uc774\uc804\uc5d0\ub294 \ub2e4\uc74c\uc5d0\uc11c \ucc3e\uc740 \ubc30\uc5f4 \uc694\uc18c\ub97c \uc778\ub371\uc2f1\ud558\ub824\uba74 <code>\uc18c\uc15c \ubbf8\ub514\uc5b4<\/code> \uc640 \uac19\uc740 \uc778\ub371\uc2a4\ub97c \uc791\uc131\ud574\uc57c \ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">CREATE INDEX ism \r\nON `default` ( DISTINCT ARRAY media FOR media IN `social-media` END )\r\nWHERE type = 'person';<\/pre>\n<p>\uc704\uc758 \uc608\uc5d0\uc11c\u00a0<code>FOR<\/code> \uc5f0\uc0b0\uc790\uac00 \ubc30\uc5f4 \uc778\ub371\uc2f1\uc5d0 \ud544\uc694\ud588\uc2b5\ub2c8\ub2e4.  Couchbase Server 5.0\uc5d0\uc11c\ub294 \ud6e8\uc52c \ub354 \uac04\uc18c\ud654\ub41c \uad6c\ubb38\uc774 \uc788\uc2b5\ub2c8\ub2e4.  \ub2e4\uc74c\uc744 \ud1b5\ud574 \ub3d9\uc77c\ud55c \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">CREATE INDEX ism \r\nON `default` ( DISTINCT `social-media` )\r\nWHERE type = \"person\";<\/pre>\n<p>\uc778\ub371\uc2a4\uac00 \uc791\ub3d9\ud558\ub294\uc9c0 \ud655\uc778\ud558\ub824\uba74 \ub2e4\uc74c N1QL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uba74 \ub429\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">EXPLAIN SELECT *\r\nFROM default\r\nWHERE type = 'person' AND ANY media IN `social-media` SATISFIES media.type = 'website' END;<\/pre>\n<p>\uacb0\uacfc\ub97c \uc0b4\ud3b4\ubcfc \ub54c\u00a0<code>\uc124\uba85<\/code> \ub97c \uc0ac\uc6a9\ud558\uba74\u00a0<code>ism<\/code> \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \uac04\uc18c\ud654\ub41c \uad6c\ubb38\uc774 \uc874\uc7ac\ud55c\ub2e4\uace0 \ud574\uc11c \ubc30\uc5f4 \uc778\ub371\uc2f1 \uc2dc \uc774\uc804 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4\ub294 \uc758\ubbf8\ub294 \uc544\ub2d9\ub2c8\ub2e4.  \ub2e4\uc74c\uc740 \uc774\uc804 \uad6c\ubb38\uc774 \uc5ec\uc804\ud788 \uc720\ud6a8\ud55c \uc774\uc720\ub97c \ubcf4\uc5ec\uc8fc\ub294 \uc644\ubcbd\ud55c \uc608\uc2dc\uc785\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">CREATE INDEX ism_website\r\nON `default` ( DISTINCT ARRAY media FOR media IN `social-media` WHEN media.type = 'website' END )\r\nWHERE type = 'person';<\/pre>\n<p>\ub2e4\uc74c \uc0ac\ud56d\uc5d0 \uc720\uc758\ud558\uc2ed\uc2dc\uc624.\u00a0<code>\uc5b8\uc81c<\/code> \uc5f0\uc0b0\uc790\ub97c \uc0dd\uc131\ud560 \ub54c\u00a0<code>ism_\uc6f9\uc0ac\uc774\ud2b8<\/code> \uc0c9\uc778\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n<p>\ubc30\uc5f4 \uc778\ub371\uc2f1\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694.\u00a0<a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/n1ql\/n1ql-language-reference\/indexing-arrays.html\" target=\"_blank\" rel=\"noopener noreferrer\">\uc5ec\uae30<\/a>\ub97c \ucc38\uc870\ud558\uc138\uc694. Couchbase\uc5d0\uc11c \uc778\ub371\uc2a4 \uc0dd\uc131\uc5d0 \ub300\ud55c \ub2e4\ub978 \uc720\uc6a9\ud55c \ubb38\uc11c\ub3c4 \ud568\uaed8 \uc81c\uacf5\ub429\ub2c8\ub2e4.<\/p>\n<h3>\ubc30\uc5f4 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ubcc0\uc218 \uc77c\uce58 \uc694\uac74 \uc644\ud654<\/h3>\n<p>4.x \ub9b4\ub9ac\uc2a4\uc5d0\uc11c\ub294 \ubc30\uc5f4 \uc778\ub371\uc2f1\uc5d0 \uc815\ud655\ud788 \ub3d9\uc77c\ud55c \ubcc0\uc218 \uc774\ub984\uc744 \uc0ac\uc6a9\ud574\uc57c \ud588\uc2b5\ub2c8\ub2e4. <code>\uc120\ud0dd<\/code> \ucffc\ub9ac\uc5d0\uc11c \uc0ac\uc6a9\ub41c <code>\uc778\ub371\uc2a4 \uc0dd\uc131<\/code> \uc9c4\uc220. \uc790\uc138\ud55c \ub0b4\uc6a9 \ubcf4\uae30 <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.6\/n1ql\/n1ql-language-reference\/indexing-arrays.html\" target=\"_blank\" rel=\"noopener noreferrer\">\uc5ec\uae30<\/a>.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4, \uc704\uc5d0\uc11c \ubcf8 \uc774\uc804 \ucffc\ub9ac\ub97c \ucc38\uc870\ud558\uba74 \ubcc0\uc218 <code>\ubbf8\ub514\uc5b4<\/code> \ubc30\uc5f4\uc744 \ubc18\ubcf5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 <code>\uc18c\uc15c \ubbf8\ub514\uc5b4<\/code> \uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. 4.x\uc758 \ubc30\uc5f4 \uc778\ub371\uc2f1\uc5d0\uc11c\ub294 \uc815\ud655\ud55c \ubcc0\uc218 \uc774\ub984\uc774 \ud544\uc218\uc785\ub2c8\ub2e4. <code>\ubbf8\ub514\uc5b4<\/code> \ub97c \uc0ac\uc6a9\ud558\uc5ec \uc774\uc804\u00a0<code>\uc120\ud0dd<\/code> \ucffc\ub9ac.<\/p>\n<p>Couchbase 5.0 \ub9b4\ub9ac\uc2a4\uc5d0\uc11c\ub294 \uc774 \uc694\uad6c \uc0ac\ud56d\uc774 \uc644\ud654\ub418\uc5c8\uc73c\uba70, \ub2e4\uc74c \ucffc\ub9ac\ub294 \uc644\ubcbd\ud558\uac8c \uc791\ub3d9\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">EXPLAIN SELECT *\r\nFROM default\r\nUSE INDEX (ism)\r\nWHERE type = 'person' AND ANY m IN `social-media` SATISFIES m.type = 'website' END;<\/pre>\n<p>\uc778\ub371\uc2a4 <code>ism<\/code> \ubcc0\uc218 \uc774\ub984 \uc0ac\uc6a9 <code>\ubbf8\ub514\uc5b4<\/code>\ub97c \uc0ac\uc6a9\ud558\uc9c0\ub9cc \uc704\uc758 \ucffc\ub9ac\ub294 <code>m<\/code>. \uadf8\ub798\ub3c4 \uc704\uc758 \ucffc\ub9ac\ub294 \uc778\ub371\uc2a4 <code>ism<\/code> \uc131\uacf5\uc801\uc73c\ub85c \uc644\ub8cc\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\ubc30\uc5f4 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \uc644\ud654\ub41c \uc804\uccb4 \ubc30\uc5f4 \uc778\ub371\uc2a4 \ud0a4 \uc694\uad6c \uc0ac\ud56d<\/h3>\n<p>\ub610\ud55c 4.x \ub9b4\ub9ac\uc2a4\uc5d0\uc11c \uc9c0\uc6d0\ub418\ub294 \ubc30\uc5f4 \uc778\ub371\uc2f1\uc740 \ubc30\uc5f4 \uc778\ub371\uc2a4 \uc815\uc758\uc5d0\uc11c \uc804\uccb4 \ubc30\uc5f4 \uc18d\uc131\uc744 \ud544\uc218 \uc778\ub371\uc2a4 \ud0a4\ub85c \uc694\uad6c\ud55c\ub2e4\ub294 \uc810\uc744 \uae30\uc5b5\ud558\uc138\uc694.  \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c \ucffc\ub9ac\ub97c \ub2e4\uc2dc \uc0b4\ud3b4\ubd05\uc2dc\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">EXPLAIN SELECT *\r\nFROM default\r\nWHERE type = 'person' AND ANY media IN `social-media` SATISFIES media.type = 'website' END;<\/pre>\n<p>\uc704\uc758 \ucffc\ub9ac\uc5d0 \ud574\ub2f9\ud558\ub294 \ucee4\ubc84\ub41c \ubc30\uc5f4 \uc778\ub371\uc2a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">CREATE INDEX ism_covered \r\nON `default` ( DISTINCT ARRAY media FOR media IN `social-media` END,  `social-media`)\r\nWHERE type = 'person';<\/pre>\n<p>\ub450 \ubc88\uc9f8 \uc778\ub371\uc2a4 \ud0a4\ub294 <code>\uc18c\uc15c \ubbf8\ub514\uc5b4<\/code> \ub294 \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c \ucffc\ub9ac\ub97c \ucc98\ub9ac\ud558\ub294 \ub370 \ud544\uc218\uc785\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">EXPLAIN SELECT media\r\nFROM default\r\nWHERE type = 'person' AND ANY media IN `social-media` SATISFIES media IS NOT NULL END;<\/pre>\n<p>Couchbase 5.0\uc5d0\uc11c\ub294 \ub3d9\uc77c\ud55c \ucffc\ub9ac\uac00 \uc778\ub371\uc2a4\uc5d0 \uc758\ud574 \ucc98\ub9ac\ub429\ub2c8\ub2e4. <code>ism<\/code> \uc774 \uae00\uc758 \ub9e8 \ucc98\uc74c\uc5d0 \uc124\uba85\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uae30\ub2a5\uc740 \ubc30\uc5f4 \uc778\ub371\uc2a4\uc5d0 \ub9ce\uc740 \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774\uc81c \ubc30\uc5f4 \uc778\ub371\uc2a4\uc758 \uac01 \ud56d\ubaa9\uc774 \uc800\uc7a5 \uacf5\uac04\uacfc \uba54\ubaa8\ub9ac\ub97c \ub35c \ucc28\uc9c0\ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc740 \uc774\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li>\ub354 \ud070 \ubc30\uc5f4\uc5d0 \ucee4\ubc84\ub41c \ubc30\uc5f4 \uc778\ub371\uc2a4 \uc0ac\uc6a9<\/li>\n<li>\ucee4\ubc84\ub41c \ubc30\uc5f4 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\uc758 \ud6a8\uc728\uc131\uacfc \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2>\ubb38\uc11c \uba54\ud0c0 \uc815\ubcf4 \uc0c9\uc778\ud654<\/h2>\n<p>\uc774\uc81c \uc0c9\uc778\ud654\ud560 \uc218 \uc788\ub294 \uc0c8\ub85c\uc6b4 \uba54\ud0c0 \uc815\ubcf4\uc5d0 \ub300\ud574 \ucc28\ub840\ub85c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.  \uc774\uc804\uc5d0\ub294 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4 \uc218 \uc788\ub294 <code>\uba54\ud0c0().id<\/code> \uc18d\uc131\uc774 \uc788\uc9c0\ub9cc \uc774\uc81c\ub294 <code>\uba54\ud0c0().cas<\/code> \uadf8\ub9ac\uace0 <code>\uba54\ud0c0().\ub9cc\ub8cc<\/code> \uc18d\uc131\uc774 \uc9c0\uc6d0\ub429\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub807\ub2e4\uba74 \uba54\ud0c0 \uc18d\uc131\uc744 \ud0a4\ub85c \uc0ac\uc6a9\ud558\ub294 \uc778\ub371\uc2a4\ub294 \uc5b4\ub5bb\uac8c \ub9cc\ub4e4\uae4c\uc694?  \uc774\ubbf8 \uc54c\uace0 \uc788\ub294 \uac83\uacfc \ub2e4\ub974\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.  \ub2e4\uc74c \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\ub97c \uc608\ub85c \ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">CREATE INDEX idx_cas\r\nON `default` ( META().cas, META().expiration )\r\n\r\nCREATE INDEX idx_exp\r\nON `default` ( META().expiration )<\/pre>\n<p>\uc774\uc81c\u00a0<code>IDX_CAS<\/code>\u00a0\uadf8\ub9ac\uace0 <code>IDX_EXP<\/code> \uc778\ub371\uc2a4\uc5d0 \ub300\ud574 \ub2e4\uc74c\uacfc \uac19\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">SELECT META().id, META().cas\r\nFROM default\r\nWHERE META().cas &gt; 1489531586248179712;\r\n\r\nSELECT META().id, META().expiration\r\nFROM default\r\nWHERE META().expiration &gt; NOW_MILLIS();<\/pre>\n<p>\uadf8\ub807\ub2e4\uba74 \uc65c \uc774\ub7ec\ud55c \uc18d\uc131\uc744 \uc0c9\uc778\ud654\ud560 \uc218 \uc788\uc744\uae4c\uc694?  \uc624\ub298 \ub9cc\ub8cc\ub41c \ubaa8\ub4e0 \ubb38\uc11c \ub610\ub294 \uc624\ub298 \uc218\uc815\ub41c \ubaa8\ub4e0 \ubb38\uc11c\uc5d0 \ub300\ud55c \ucffc\ub9ac\ub97c \uc218\ud589\ud558\ub824\ub294 \uacbd\uc6b0 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud560\uae4c\uc694?<\/p>\n<p>CAS \ubc0f \ub9cc\ub8cc \uc18d\uc131\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.6\/sdk\/core-operations.html#story-h2-8\" target=\"_blank\" rel=\"noopener noreferrer\">\uc5ec\uae30<\/a>.  Couchbase\uc5d0\uc11c N1QL\uc744 \uc0c9\uc778\ud654\ud558\uac70\ub098 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/developers\/\" target=\"_blank\" rel=\"noopener noreferrer\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uac1c\ubc1c\uc790 \ud3ec\ud138<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Couchbase 5.0\uc758 \uc548\uc815\uc801\uc778 \ub9b4\ub9ac\uc2a4\uac00 \uc784\ubc15\ud588\uc73c\ubbc0\ub85c N1QL \uae30\uc220\uacfc \ud568\uaed8 \uc81c\uacf5\ub418\ub294 \uc131\ub2a5 \ubc0f \uae30\ub2a5 \uac1c\uc120 \uc0ac\ud56d \uc911 \uc77c\ubd80\ub97c \ub2e4\uc2dc \uc0b4\ud3b4\ubcf4\ub294 \uac83\ub3c4 \uc88b\uc740 \uc0dd\uac01\uc785\ub2c8\ub2e4.<\/p>","protected":false},"author":63,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816,9417,1812],"tags":[1891,1505],"ppma_author":[9032],"class_list":["post-3676","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","category-performance","category-n1ql-query","tag-enhancement","tag-index"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>N1QL Performance and Feature Enhancements in Couchbase 5.0<\/title>\n<meta name=\"description\" content=\"Learn about all the new N1QL and indexing features and enhancements made available in Couchbase Server 5.0.\" \/>\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\/n1ql-performance-feature-enhancements-couchbase-5-0\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"N1QL Performance and Feature Enhancements in Couchbase 5.0\" \/>\n<meta property=\"og:description\" content=\"Learn about all the new N1QL and indexing features and enhancements made available in Couchbase Server 5.0.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/n1ql-performance-feature-enhancements-couchbase-5-0\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/thepolyglotdeveloper\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-21T15:06:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T03:20:21+00:00\" \/>\n<meta name=\"author\" content=\"Nic Raboy, Developer Advocate, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@nraboy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nic Raboy, Developer Advocate, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/\"},\"author\":{\"name\":\"Nic Raboy, Developer Advocate, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/bb545ebe83bb2d12f91095811d0a72e1\"},\"headline\":\"N1QL Performance and Feature Enhancements in Couchbase 5.0\",\"datePublished\":\"2017-06-21T15:06:12+00:00\",\"dateModified\":\"2025-06-14T03:20:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/\"},\"wordCount\":1078,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"keywords\":[\"enhancement\",\"Index\"],\"articleSection\":[\"Couchbase Server\",\"High Performance\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/\",\"name\":\"N1QL Performance and Feature Enhancements in Couchbase 5.0\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2017-06-21T15:06:12+00:00\",\"dateModified\":\"2025-06-14T03:20:21+00:00\",\"description\":\"Learn about all the new N1QL and indexing features and enhancements made available in Couchbase Server 5.0.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"N1QL Performance and Feature Enhancements in Couchbase 5.0\"}]},{\"@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\/bb545ebe83bb2d12f91095811d0a72e1\",\"name\":\"Nic Raboy, Developer Advocate, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8863514d8bed0cf6080f23db40e00354\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g\",\"caption\":\"Nic Raboy, Developer Advocate, Couchbase\"},\"description\":\"Nic Raboy is an advocate of modern web and mobile development technologies. He has experience in Java, JavaScript, Golang and a variety of frameworks such as Angular, NativeScript, and Apache Cordova. Nic writes about his development experiences related to making web and mobile development easier to understand.\",\"sameAs\":[\"https:\/\/www.thepolyglotdeveloper.com\",\"https:\/\/www.facebook.com\/thepolyglotdeveloper\",\"https:\/\/x.com\/nraboy\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/nic-raboy-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Couchbase 5.0\uc758 N1QL \uc131\ub2a5 \ubc0f \uae30\ub2a5 \uac1c\uc120 \uc0ac\ud56d","description":"Couchbase Server 5.0\uc5d0\uc11c \uc81c\uacf5\ub418\ub294 \ubaa8\ub4e0 \uc0c8\ub85c\uc6b4 N1QL \ubc0f \uc778\ub371\uc2f1 \uae30\ub2a5 \ubc0f \uac1c\uc120 \uc0ac\ud56d\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uc138\uc694.","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\/n1ql-performance-feature-enhancements-couchbase-5-0\/","og_locale":"ko_KR","og_type":"article","og_title":"N1QL Performance and Feature Enhancements in Couchbase 5.0","og_description":"Learn about all the new N1QL and indexing features and enhancements made available in Couchbase Server 5.0.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/n1ql-performance-feature-enhancements-couchbase-5-0\/","og_site_name":"The Couchbase Blog","article_author":"https:\/\/www.facebook.com\/thepolyglotdeveloper","article_published_time":"2017-06-21T15:06:12+00:00","article_modified_time":"2025-06-14T03:20:21+00:00","author":"Nic Raboy, Developer Advocate, Couchbase","twitter_card":"summary_large_image","twitter_creator":"@nraboy","twitter_misc":{"Written by":"Nic Raboy, Developer Advocate, Couchbase","Est. reading time":"5\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/"},"author":{"name":"Nic Raboy, Developer Advocate, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/bb545ebe83bb2d12f91095811d0a72e1"},"headline":"N1QL Performance and Feature Enhancements in Couchbase 5.0","datePublished":"2017-06-21T15:06:12+00:00","dateModified":"2025-06-14T03:20:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/"},"wordCount":1078,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["enhancement","Index"],"articleSection":["Couchbase Server","High Performance","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/","url":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/","name":"Couchbase 5.0\uc758 N1QL \uc131\ub2a5 \ubc0f \uae30\ub2a5 \uac1c\uc120 \uc0ac\ud56d","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2017-06-21T15:06:12+00:00","dateModified":"2025-06-14T03:20:21+00:00","description":"Couchbase Server 5.0\uc5d0\uc11c \uc81c\uacf5\ub418\ub294 \ubaa8\ub4e0 \uc0c8\ub85c\uc6b4 N1QL \ubc0f \uc778\ub371\uc2f1 \uae30\ub2a5 \ubc0f \uac1c\uc120 \uc0ac\ud56d\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uc138\uc694.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/n1ql-performance-feature-enhancements-couchbase-5-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"N1QL Performance and Feature Enhancements in Couchbase 5.0"}]},{"@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\/bb545ebe83bb2d12f91095811d0a72e1","name":"Nic Raboy, \uac1c\ubc1c\uc790 \uc639\ud638\uc790, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8863514d8bed0cf6080f23db40e00354","url":"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g","caption":"Nic Raboy, Developer Advocate, Couchbase"},"description":"\ub2c9 \ub77c\ubcf4\uc774\ub294 \ucd5c\uc2e0 \uc6f9 \ubc0f \ubaa8\ubc14\uc77c \uac1c\ubc1c \uae30\uc220\uc744 \uc639\ud638\ud558\ub294 \uc0ac\ub78c\uc785\ub2c8\ub2e4. \uadf8\ub294 Java, JavaScript, Golang \ubc0f Angular, NativeScript, Apache Cordova\uc640 \uac19\uc740 \ub2e4\uc591\ud55c \ud504\ub808\uc784\uc6cc\ud06c\uc5d0 \ub300\ud55c \uacbd\ud5d8\uc774 \uc788\uc2b5\ub2c8\ub2e4. Nic\uc740 \uc6f9 \ubc0f \ubaa8\ubc14\uc77c \uac1c\ubc1c\uc744 \ubcf4\ub2e4 \uc27d\uac8c \uc774\ud574\ud560 \uc218 \uc788\ub3c4\ub85d \uc790\uc2e0\uc758 \uac1c\ubc1c \uacbd\ud5d8\uc5d0 \ub300\ud574 \uae00\uc744 \uc4f0\uace0 \uc788\uc2b5\ub2c8\ub2e4.","sameAs":["https:\/\/www.thepolyglotdeveloper.com","https:\/\/www.facebook.com\/thepolyglotdeveloper","https:\/\/x.com\/nraboy"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/nic-raboy-2\/"}]}},"authors":[{"term_id":9032,"user_id":63,"is_guest":0,"slug":"nic-raboy-2","display_name":"Nic Raboy, Developer Advocate, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g","author_category":"","last_name":"Raboy","first_name":"Nic","job_title":"","user_url":"https:\/\/www.thepolyglotdeveloper.com","description":"\ub2c9 \ub77c\ubcf4\uc774\ub294 \ucd5c\uc2e0 \uc6f9 \ubc0f \ubaa8\ubc14\uc77c \uac1c\ubc1c \uae30\uc220\uc744 \uc639\ud638\ud558\ub294 \uc0ac\ub78c\uc785\ub2c8\ub2e4. \uadf8\ub294 Java, JavaScript, Golang \ubc0f Angular, NativeScript, Apache Cordova\uc640 \uac19\uc740 \ub2e4\uc591\ud55c \ud504\ub808\uc784\uc6cc\ud06c\uc5d0 \ub300\ud55c \uacbd\ud5d8\uc774 \uc788\uc2b5\ub2c8\ub2e4. Nic\uc740 \uc6f9 \ubc0f \ubaa8\ubc14\uc77c \uac1c\ubc1c\uc744 \ubcf4\ub2e4 \uc27d\uac8c \uc774\ud574\ud560 \uc218 \uc788\ub3c4\ub85d \uc790\uc2e0\uc758 \uac1c\ubc1c \uacbd\ud5d8\uc5d0 \ub300\ud574 \uae00\uc744 \uc4f0\uace0 \uc788\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/3676","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\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=3676"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/3676\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=3676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=3676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=3676"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=3676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}