{"id":7940,"date":"2019-12-26T10:54:55","date_gmt":"2019-12-26T18:54:55","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=7940"},"modified":"2025-06-13T17:21:52","modified_gmt":"2025-06-14T00:21:52","slug":"index-advisor-service","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-service\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 N1QL\uc6a9 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uc11c\ube44\uc2a4(JSON\uc6a9 SQL)"},"content":{"rendered":"<p><span style=\"color: #000000\">\uc758 \ucd9c\uc2dc\ub97c \ubc1c\ud45c\ud558\uac8c \ub418\uc5b4 \uae30\uc058\uac8c \uc0dd\uac01\ud569\ub2c8\ub2e4:<\/span><\/p>\n<h3><span style=\"color: #993300\"> \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uc11c\ube44\uc2a4<\/span><\/h3>\n<h3><a href=\"https:\/\/index-advisor.couchbase.com\">https:\/\/index-advisor.couchbase.com<\/a><\/h3>\n<h4>\ub610 \ub2e4\ub978 \uc11c\ube44\uc2a4? \uc65c\uc694?<\/h4>\n<p>\uba87 \ub144 \uc804, SQL\uc744 \uc0ac\uc6a9\ud574 JSON \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\uace0 \uc870\uc791\ud560 \uc218 \uc788\ub3c4\ub85d N1QL(SQL for JSON)\uc744 \ucd9c\uc2dc\ud588\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc88b\uc740 \uc778\ub371\uc2a4\uac00 \uc0dd\uc131\ub418\uc9c0 \uc54a\uc73c\uba74 \ucffc\ub9ac \uc131\ub2a5\uc774 \uc88b\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4! \uc0dd\uc131\ud55c \uc778\ub371\uc2a4\uac00 \ucffc\ub9ac \uc5d4\uc9c4\uc5d0 \uc801\ud569\ud55c \uc778\ub371\uc2a4\uc778\uc9c0 \uc5b4\ub5bb\uac8c \uc54c \uc218 \uc788\uc744\uae4c\uc694? \uadf8\ub798\uc11c \uc6b0\ub9ac\ub294 \uc88b\uc740 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4dc\ub294 \ubaa8\ub4e0 \uaddc\uce59\uc744 \uacf5\uac1c\ud558\uae30\ub85c \uacb0\uc815\ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uadf8\uac83\uc740 \ub108\ubb34 \ub9ce\uc740 \uc77d\uae30\ub97c \ud544\uc694\ub85c \ud588\uc2b5\ub2c8\ub2e4! \uadf8\ub798\uc11c \ud55c \uac78\uc74c \ub354 \ub098\uc544\uac00 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud798\uc744 \uc2e4\uc5b4\ub4dc\ub9ac\uace0\uc790 \ud569\ub2c8\ub2e4. \uc774\uc81c \uc11c\ube44\uc2a4\ub97c \ucd9c\uc2dc\ud569\ub2c8\ub2e4.<strong>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800<\/strong>-\ub294 \ucffc\ub9ac\ub97c \uc218\ub77d\ud558\uace0 \ucffc\ub9ac \uc5d4\uc9c4\uc758 \uae30\ub300\uce58\ub97c \ucda9\uc871\ud558\ub294 \uc778\ub371\uc2a4 \ucd94\ucc9c\uc744 \uc81c\uacf5\ud558\ub294\ub370, \uc774 \ubaa8\ub4e0 \uac83\uc774 \ucd5c\uc2e0 Couchbase \uc11c\ubc84\ub97c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uc9c0 \uc54a\uace0\ub3c4 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n<h4>\ub204\uad6c\ub97c \uc704\ud574?<\/h4>\n<p>\uc774 \uc11c\ube44\uc2a4\ub294 DBA, \uac1c\ubc1c\uc790, \uc544\ud0a4\ud14d\ud2b8\uac00 \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\uace0 SLA\ub97c \ucda9\uc871\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \uc778\ub371\uc2a4 \uad8c\uc7a5 \uc0ac\ud56d\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>Index Advisor\ub294 Couchbase Server 6.5\uc758 \uc77c\ubd80\ub85c \ucd9c\uc2dc\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \ubc84\uc804\uc744 \ub2e4\uc6b4\ub85c\ub4dc\ud588\ub2e4\uba74 \uc774 \uc11c\ube44\uc2a4\uac00 \uc81c\uacf5\ud558\ub294 \ubaa8\ub4e0 \uae30\ub2a5(\uadf8\ub9ac\uace0 \uadf8 \uc774\uc0c1)\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h4>\uc774 \uc11c\ube44\uc2a4\ub294 \uc5b8\uc81c \uc0ac\uc6a9\ud574\uc57c \ud558\ub098\uc694?<\/h4>\n<p>\ub9cc\uc57d \ub2f9\uc2e0\uc774:<\/p>\n<ol>\n<li>\uc77d\uc9c0 \uc54a\uc73c\ub824\uba74 <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/createindex.html\">\uc778\ub371\uc2a4 \uc0dd\uc131<\/a> <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/create-right-index-get-right-performance\/\">\uaddc\uce59<\/a>\ub97c \uc0b4\ud3b4\ubcf4\uace0, \uc774\ub97c \uc774\ud574\ud558\uace0, \uad6c\ud604\ud558\uc5ec \ucffc\ub9ac\/\uc9c8\ubb38\/\uc6cc\ud06c\ub85c\ub4dc\uc5d0 \uc801\ud569\ud55c \uc778\ub371\uc2a4\ub97c \ucc3e\uc544\ubcf4\uc138\uc694.<\/li>\n<li>\u00a0\uc544\uc9c1 \ucd5c\uc2e0 Couchbase 6.5 \uc11c\ubc84\ub97c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uace0 \uc2f6\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\u00a0\uc0ac\uc6a9 \uc911\uc785\ub2c8\ub2e4. <strong>\uc774\uc804 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ubc84\uc804<\/strong> \ucffc\ub9ac\uc5d0 \uc801\ud569\ud55c \uc778\ub371\uc2a4\ub97c \ub9cc\ub4dc\ub294 \ub370 \ub3c4\uc6c0\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \uc870\uc5b8\uc744 \uc0dd\uc131\ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. <strong>\ubc84\ud0b7\uc744 \ub9cc\ub4e4\uc9c0 \uc54a\uace0<\/strong> \ub610\ub294 \uc2a4\ud0a4\ub9c8 \ub610\ub294 \ub370\uc774\ud130\ub97c \uc5c5\ub85c\ub4dc\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<h4>\ubc30\uacbd:<\/h4>\n<p>N1QL\uc740 JSON \ub370\uc774\ud130 \ubc0f \uba54\ud0c0\ub370\uc774\ud130\uc6a9 SQL\uc785\ub2c8\ub2e4. N1QL\ub85c \uc791\uc131\ub41c \ubaa8\ub4e0 \ucffc\ub9ac\uc5d0\ub294 N1QL \ucffc\ub9ac \uc5d4\uc9c4\uc5d0 \uc758\ud574 \uc900\ube44\ub41c \ucffc\ub9ac \uacc4\ud68d\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ucffc\ub9ac\uc758 \uc131\ub2a5\uacfc \ud6a8\uc728\uc131\uc740 \ucffc\ub9ac \uacc4\ud68d\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4. \ub370\uc774\ud130\uc5d0 \uc801\ud569\ud55c \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\uba74 \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 \ubc29\uc2dd\uc73c\ub85c \uacb0\uacfc \uc9d1\ud569\uc744 \uac80\uc0c9\ud560 \uc218 \uc788\ub294 \uc778\ub371\uc2a4\ub97c \uc120\ud0dd\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. JSON \ubb38\uc11c \uc790\uccb4\uc5d0\ub294 \uc2a4\ud0a4\ub9c8\uac00 \uc5c6\ub354\ub77c\ub3c4 \uc778\ub371\uc2a4\uc5d0\ub294 \uc2a4\ud0a4\ub9c8\uac00 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\uc608: \uc778\ub371\uc2a4 <span style=\"color: #3366ff\">ix1(field1,field2)<\/span> \ub294 \uc778\ub371\uc2a4\uc640 \ub2e4\ub985\ub2c8\ub2e4. <span style=\"color: #993366\">ix2(field2,field1)<\/span>.<\/p>\n<p>\ub530\ub77c\uc11c \uc778\ub371\uc2a4\uc5d0 \ub300\ud574 \uc120\ud0dd\ud558\ub294 \ud544\ub4dc\ub3c4 \uc911\uc694\ud558\uc9c0\ub9cc, \uc778\ub371\uc2a4\uc5d0 \ud3ec\ud568\ub418\ub294 \uc21c\uc11c\ub3c4 GSI \uc778\ub371\uc2a4\uc5d0 \uc911\uc694\ud569\ub2c8\ub2e4. (FTS \uc778\ub371\uc2a4\uc5d0 \ub300\ud574\uc11c\ub294 \ub2e4\ub978 \ube14\ub85c\uadf8\uc5d0\uc11c \ub2e4\ub8f0 \uc608\uc815\uc785\ub2c8\ub2e4.)<\/p>\n<h4>\ucffc\ub9ac\uc758 \uc218\uba85:<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/bUAH1tBFCqxjrnWB-JOpJ-hCLUSJ4ispcUe2QQDvSJhxv_JQO4oGrPAIijxCtTnvr2gjijbFprOefbDDXBmv7X4zUB2-gswgByTlbq9UQKYZCAjToxUtWKjyR1aSpVVjnVbXXDi7\" alt=\"Screen Shot 2016-12-12 at 2.10.40 PM.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>4\ub2e8\uacc4\uac00 \uc5bc\ub9c8\ub098 \uc798 \uc218\ud589\ub418\ub290\ub0d0\uc5d0 \ub530\ub77c 5\ub2e8\uacc4\uc640 6\ub2e8\uacc4\ub97c \ucd5c\uc18c\ud654\ud558\uac70\ub098 \uc644\uc804\ud788 \uc0dd\ub7b5\ud558\uc5ec \ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc73c\ubbc0\ub85c \uc778\ub371\uc2a4\uc758 \ud544\ub4dc\ub97c \uacb0\uc815\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud55c \ubd80\ubd84\uc785\ub2c8\ub2e4. \uc774\ub97c \ub3d5\uae30 \uc704\ud574 Index Advisor\ub97c \ucd9c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/index-advisor.couchbase.com\">https:\/\/index-advisor.couchbase.com<\/a><\/p>\n<h4>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 - \uc11c\ube44\uc2a4!<\/h4>\n<p>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub97c \uc0ac\uc6a9\ud558\uba74 \ub2e4\uc74c\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\ub2e4\uc74c\uc5d0\uc11c \ucffc\ub9ac \ud558\ub098 \ub610\ub294 \uc5ec\ub7ec \uac1c\uc758 \ucffc\ub9ac\ub97c \uc81c\uacf5\ud558\uc138\uc694. <strong>6.5 \uc774\uc804 \uc11c\ubc84\ub3c4<\/strong> \ub97c \uc785\ub825\ud558\uba74 \uc11c\ube44\uc2a4\uac00 \ucd5c\uc0c1\uc758 \uc131\ub2a5\uc744 \uc5bb\uae30 \uc704\ud574 \ubcf4\uc720\ud558\uac70\ub098 \uc0dd\uc131\ud574\uc57c \ud558\ub294 \uc778\ub371\uc2a4\ub97c \ucd94\ucc9c\ud574 \ub4dc\ub9bd\ub2c8\ub2e4.<\/li>\n<li>\ub370\uc774\ud130\ub098 \uc2a4\ud0a4\ub9c8\uac00 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \ud604\uc7ac \ud574\ub2f9 \uc778\ub371\uc2a4\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\/\ud1b5\uacc4\/\uc2a4\ud0a4\ub9c8\/\ucd94\ub860 \uc5f0\uc0b0\/\ud604\uc7ac \uc778\ub371\uc2a4 \ub610\ub294 \ub354 \ub098\uc740 \ucd94\ucc9c\uc744 \uc704\ud574 \uc81c\uacf5\ud560 \uc218 \uc788\ub294 \ub2e4\ub978 \ubaa8\ub4e0 \uac83\uc744 \ud5c8\uc6a9\ud558\ub3c4\ub85d \uc774 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uace7 \uac1c\uc120\ud560 \uc608\uc815\uc785\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>ADVISE \uc9c0\uc2dc\uc5b4\ub85c \ucffc\ub9ac\ub97c \uc785\ub825\ud558\uba74 \ub3c4\uad6c\uc5d0\uc11c \ucd5c\uc18c \uc778\ub371\uc2a4\uc640 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \uad8c\uc7a5 \uc0ac\ud56d\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uc778\ub371\uc2a4: \uc774 \uc139\uc158\uc5d0\ub294 WHERE\/ON \uc808\uc758 \uc220\uc5b4\ub97c \uae30\ubc18\uc73c\ub85c \ud558\ub294 \uad8c\uc7a5 \uc778\ub371\uc2a4\uc640 \uac01 \uc778\ub371\uc2a4\uac00 \ub530\ub974\ub294 \ud574\ub2f9 \uad8c\uc7a5 \uaddc\uce59\uc774 \ub098\uc5f4\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4: \uc774 \uc139\uc158\uc5d0\ub294 \uc785\ub825 \ucffc\ub9ac\uc5d0 \uc801\uc6a9 \uac00\ub2a5\ud55c \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4, \uc989 \ub370\uc774\ud130 \uc11c\ube44\uc2a4\ub85c\uc758 \ucd94\uac00 \ud649\uc744 \ud53c\ud558\uae30 \uc704\ud574 \ucffc\ub9ac\uc5d0\uc11c \ucc38\uc870\ub41c \ubaa8\ub4e0 \ud544\ub4dc\ub97c \ud3ec\ud568\ud558\ub294 \uc778\ub371\uc2a4\uac00 \ub098\uc5f4\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\ub3c4\uad6c\uc758 \ubaa8\uc591\uacfc \ub290\ub08c\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc544\ub798 GIF\ub97c \ud074\ub9ad\ud558\uba74 \uba85\ud655\ud558\uac8c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/12\/IndexAdvisorexample.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7963\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/12\/IndexAdvisorexample-300x158.gif\" alt=\"\" width=\"1115\" height=\"587\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/IndexAdvisorexample-300x158.gif 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/IndexAdvisorexample-1024x540.gif 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/IndexAdvisorexample-768x405.gif 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/IndexAdvisorexample-1536x810.gif 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/IndexAdvisorexample-20x11.gif 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/IndexAdvisorexample-1320x696.gif 1320w\" sizes=\"auto, (max-width: 1115px) 100vw, 1115px\" \/><\/a><\/p>\n<p>\uc608\uc2dc:<\/p>\n<p>1.<\/p>\n<pre class=\"lang:default decode:true\">ADVISE SELECT fname, age, age\/7 AS age_dog_years FROM trial WHERE fname = 'Sara'<\/pre>\n<pre class=\"lang:default decode:true\">{\r\n  \"results\": [\r\n    {\r\n      \"#operator\": \"Advise\",\r\n      \"advice\": {\r\n        \"#operator\": \"IndexAdvice\",\r\n        \"adviseinfo\": [\r\n          {\r\n            \"recommended_indexes\": {\r\n              \"covering_indexes\": [\r\n                {\r\n                  \"index_statement\": \"CREATE INDEX adv_fname_age ON `trial`(`fname`,`age`)\",\r\n                  \"keyspace_alias\": \"trial\"\r\n                }\r\n              ],\r\n              \"indexes\": [\r\n                {\r\n                  \"index_statement\": \"CREATE INDEX adv_fname ON `trial`(`fname`)\",\r\n                  \"keyspace_alias\": \"trial\",\r\n                  \"recommending_rule\": \"Index keys follow order of predicate types: 2. equality\/null\/missing.\"\r\n                }\r\n              ]\r\n            }\r\n          }\r\n        ]\r\n      },\r\n      \"query\": \"SELECT fname, age, age\/7 AS age_dog_years FROM trial WHERE fname = 'Sara'\"\r\n    }\r\n  ]\r\n}\r\n<\/pre>\n<p>2.<\/p>\n<pre class=\"lang:default decode:true\">ADVISE SELECT (DISTINCT purchases.customerId)FROM purchases\u00a0\r\nWHERE purchases.purchasedAt BETWEEN \"2014-03-01\" AND \"2014-03-31\"<\/pre>\n<pre class=\"lang:default decode:true\">{\r\n  \"results\": [\r\n    {\r\n      \"#operator\": \"Advise\",\r\n      \"advice\": {\r\n        \"#operator\": \"IndexAdvice\",\r\n        \"adviseinfo\": [\r\n          {\r\n            \"recommended_indexes\": {\r\n              \"indexes\": [\r\n                {\r\n                  \"index_statement\": \"CREATE INDEX adv_purchasedAt ON `purchases`(`purchasedAt`)\",\r\n                  \"keyspace_alias\": \"purchases\",\r\n                  \"recommending_rule\": \"Index keys follow order of predicate types: 4. not less than\/between\/not greater than.\"\r\n                }\r\n              ]\r\n            }\r\n          }\r\n        ]\r\n      },\r\n      \"query\": \"SELECT (DISTINCT purchases.customerId) \\nFROM purchases\\nWHERE purchases.purchasedAt BETWEEN \\\"2014-03-01\\\" AND \\\"2014-03-31\\\"\"\r\n    }\r\n  ]\r\n}<\/pre>\n<p>3.<\/p>\n<pre class=\"lang:default decode:true\">ADVISE SELECT DISTINCT airline.name,airport.name AS airport,route.distance \r\nFROM `travel-sample` airport INNER JOIN `travel-sample` route ON airport.faa = route.sourceairport\r\nAND route.type = \"route\" INNER JOIN `travel-sample` airline ON route.airline = airline.iata \r\nAND airline.type = \"airline\"<\/pre>\n<pre class=\"lang:default decode:true\">{\r\n  \"results\": [\r\n    {\r\n      \"#operator\": \"Advise\",\r\n      \"advice\": {\r\n        \"#operator\": \"IndexAdvice\",\r\n        \"adviseinfo\": [\r\n          {\r\n            \"recommended_indexes\": {\r\n              \"covering_indexes\": [\r\n                {\r\n                  \"index_statement\": \"CREATE INDEX adv_type_sourceairport_airline_distance ON `travel-sample`(`type`,`sourceairport`,`airline`,`distance`)\",\r\n                  \"keyspace_alias\": \"travel-sample_route\"\r\n                },\r\n                {\r\n                  \"index_statement\": \"CREATE INDEX adv_type_iata_name ON `travel-sample`(`type`,`iata`,`name`)\",\r\n                  \"keyspace_alias\": \"travel-sample_airline\"\r\n                }\r\n              ],\r\n              \"indexes\": [\r\n                {\r\n                  \"index_statement\": \"CREATE INDEX adv_type_sourceairport ON `travel-sample`(`type`,`sourceairport`)\",\r\n                  \"keyspace_alias\": \"travel-sample_route\",\r\n                  \"recommending_rule\": \"Index keys follow order of predicate types: 2. equality\/null\/missing, 10. non-static join predicate.\"\r\n                },\r\n                {\r\n                  \"index_statement\": \"CREATE INDEX adv_type_iata ON `travel-sample`(`type`,`iata`)\",\r\n                  \"keyspace_alias\": \"travel-sample_airline\",\r\n                  \"recommending_rule\": \"Index keys follow order of predicate types: 2. equality\/null\/missing, 10. non-static join predicate.\"\r\n                }\r\n              ]\r\n            }\r\n          }\r\n        ]\r\n      },\r\n      \"query\": \"SELECT DISTINCT airline.name,airport.name AS airport,route.distance FROM `travel-sample` airport INNER JOIN `travel-sample` route ON airport.faa = route.sourceairport AND route.type = \\\"route\\\"\\nINNER JOIN `travel-sample` airline ON route.airline = airline.iata AND airline.type = \\\"airline\\\"\\nWHERE airport.type = \\\"airport\\\" AND airport.city = \\\"San Jose\\\";\"\r\n    }\r\n  ]\r\n}<\/pre>\n<p>4.<\/p>\n<pre class=\"lang:default decode:true\">SELECT ADVISOR([\"SELECT * FROM `travel-sample` WHERE type = 'hotel' AND city = 'Paris'\", \r\n                \"SELECT * FROM `travel-sample` h JOIN `travel-sample` a ON a.city = h.city\r\n                                           WHERE h.type = 'hotel' AND a.type = 'airport'\"])<\/pre>\n<p>&nbsp;<\/p>\n<div class=\"listingblock\" data-ce-key=\"2760\">\n<div class=\"title\" data-ce-key=\"2761\">\uacb0\uacfc<\/div>\n<\/div>\n<pre class=\"lang:default decode:true\">{\r\n  \"results\": [\r\n    {\r\n      \"$1\": {\r\n        \"recommended_indexes\": [\r\n          {\r\n            \"index\": \"CREATE INDEX adv_type_city ON `travel-sample`(`type`,`city`)\",\r\n            \"statements\": [\r\n              {\r\n                \"run_count\": 1,\r\n                \"statement\": \"SELECT * FROM `travel-sample` WHERE type = 'hotel' AND city = 'Paris'\"\r\n              },\r\n              {\r\n                \"run_count\": 1,\r\n                \"statement\": \"SELECT * FROM `travel-sample` h JOIN `travel-sample` a ON a.city = h.city                                 WHERE h.type = 'hotel' AND a.type = 'airport'\"\r\n              }\r\n            ]\r\n          }\r\n        ]\r\n      }\r\n    }\r\n  ]\r\n}\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>\uc778\ub371\uc2a4 \ud6c4\ubcf4\uac00 \uc9c0\uc815\ub41c \ub514\uc790\uc778 \uaddc\uce59\uc5d0 \ub530\ub77c \uc0dd\uc131\ub429\ub2c8\ub2e4. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/create-right-index-get-right-performance\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">\uc5ec\uae30<\/a>.<\/p>\n<h4>\ub0a8\uc740 \uacfc\uc81c<\/h4>\n<p>1. \uc774 \ub3c4\uad6c\uc758 UI\ub97c \uac1c\uc120\ud569\ub2c8\ub2e4. \uc27d\uac8c \uc798\ub77c\ub0b4\uc5b4 \ubd99\uc5ec\ub123\uc744 \uc218 \uc788\ub3c4\ub85d \uc0c9\uc778 \ucd94\ucc9c\uc744 \ud14d\uc2a4\ud2b8\ub85c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ud604\uc7ac JSON \ucd9c\ub825\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>2. \ucde8\ud5a5 \uc218\ub77d - \ubd80\ubd84\uc801\uc778 \uc778\ub371\uc2a4 \ucd94\ucc9c\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n<p>3. \uc0ac\uc6a9\uc790\uac00 \uc2a4\ud0a4\ub9c8, \uae30\uc874 \uc778\ub371\uc2a4\ub97c \uc785\ub825\ud558\uace0, \ucd9c\ub825\uc744 \ucd94\ub860\ud558\uace0, \ub370\uc774\ud130\ub97c \ud14c\uc2a4\ud2b8\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc744 \uc81c\uacf5\ud558\uc138\uc694.<\/p>\n<p>\uc774 \ub3c4\uad6c\uac00 \uc5b4\ub5a4 \uc810\uc774 \ub9c8\uc74c\uc5d0 \ub4e4\uc5c8\ub294\uc9c0, \ucd94\uac00\ub418\uc5c8\uc73c\uba74 \ud558\ub294 \uae30\ub2a5\uc774 \uc788\ub294\uc9c0 \uc5ec\ub7ec\ubd84\uc758 \uc758\uacac\uc744 \ub4e3\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \ub313\uae00\uc744 \ud1b5\ud574 \uc758\uacac\uc744 \uacf5\uc720\ud574 \uc8fc\uc138\uc694.<\/p>\n<h4>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uae30\ub2a5\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694:<\/h4>\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/n1ql-index-advisor-improve-query-performance-and-productivity\/\">https:\/\/www.couchbase.com\/blog\/n1ql-index-advisor-improve-query-performance-and-productivity\/<\/a><\/p>\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-for-query-workload\/\">https:\/\/www.couchbase.com\/blog\/index-advisor-for-query-workload\/<\/a><\/p>\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/advise.html\">https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/advise.html<\/a><\/p>\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/advisor.html\">https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/advisor.html<\/a><\/p>\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/tools\/query-workbench.html#index-advisor\">https:\/\/docs.couchbase.com\/server\/6.5\/tools\/query-workbench.html#index-advisor<\/a><\/p>\n<h4>\uc694\uc57d:<\/h4>\n<p>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800(ADVISE \ubb38)\ub294 \ub2e8\uc77c \ucffc\ub9ac\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4 \uad8c\uc7a5 \uc0ac\ud56d\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc77c\ubc18 \uc778\ub371\uc2a4, \ubc30\uc5f4 \uc778\ub371\uc2a4, \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uc5d0 \ub300\ud574 \uc870\uc5b8\ud558\uace0 \uac01 \uc778\ub371\uc2a4 \ud0a4\uac00 \ub530\ub974\ub294 \ud574\ub2f9 \ucd94\ucc9c \uaddc\uce59\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800(ADVISOR \ubb38)\ub294 \uc5ec\ub7ec \ucffc\ub9ac\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4 \uad8c\uc7a5 \uc0ac\ud56d\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ubc30\uc5f4\uc758 \ubaa8\ub4e0 \ucffc\ub9ac\uc5d0 \uc801\ud569\ud55c \uc778\ub371\uc2a4\ub97c \uac00\ub2a5\ud55c \ud55c \uc801\uac8c \ucd94\ucc9c\ud569\ub2c8\ub2e4.<\/p>\n<p><strong>\uc9d1\uc5d0\uc11c\ub3c4 \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694!<\/strong><\/p>\n<p>https:\/\/index-advisor.couchbase.com<\/p>","protected":false},"excerpt":{"rendered":"<p>We are excited to announce the release of : Couchbase Index Advisor Service https:\/\/index-advisor.couchbase.com Yet Another service? Why? We released N1QL(SQL for JSON) a few years ago- so that you could use SQL to retrieve and manipulate JSON data. But [&hellip;]<\/p>","protected":false},"author":50908,"featured_media":7971,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1812],"tags":[2439,2440,2445,2444],"ppma_author":[9099],"class_list":["post-7940","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n1ql-query","tag-index-advisor","tag-indexes","tag-query-optimization","tag-secondary-indexes"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Index Advisor Service for Couchbase N1QL(SQL for JSON) - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"Couchbase Index advisor provides secondary index recommendations for SQL-like queries on JSON documents to improve query performance.\" \/>\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\/index-advisor-service\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Index Advisor Service for Couchbase N1QL(SQL for JSON)\" \/>\n<meta property=\"og:description\" content=\"Couchbase Index advisor provides secondary index recommendations for SQL-like queries on JSON documents to improve query performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-service\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-26T18:54:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:21:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Kamini Jagtiani\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kamini Jagtiani\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/\"},\"author\":{\"name\":\"Kamini Jagtiani\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f99c5767a877147f9cf658230bc2473b\"},\"headline\":\"Index Advisor Service for Couchbase N1QL(SQL for JSON)\",\"datePublished\":\"2019-12-26T18:54:55+00:00\",\"dateModified\":\"2025-06-14T00:21:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/\"},\"wordCount\":847,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png\",\"keywords\":[\"Index Advisor\",\"Indexes\",\"Query optimization\",\"Secondary indexes\"],\"articleSection\":[\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/\",\"name\":\"Index Advisor Service for Couchbase N1QL(SQL for JSON) - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png\",\"datePublished\":\"2019-12-26T18:54:55+00:00\",\"dateModified\":\"2025-06-14T00:21:52+00:00\",\"description\":\"Couchbase Index advisor provides secondary index recommendations for SQL-like queries on JSON documents to improve query performance.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png\",\"width\":400,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Index Advisor Service for Couchbase N1QL(SQL for JSON)\"}]},{\"@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\/f99c5767a877147f9cf658230bc2473b\",\"name\":\"Kamini Jagtiani\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/257695296726c224fc7f0e85b30c9129\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/546f9f69203064f77430f14922d59be33e3f0ea674078a793fc813dd40310c5c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/546f9f69203064f77430f14922d59be33e3f0ea674078a793fc813dd40310c5c?s=96&d=mm&r=g\",\"caption\":\"Kamini Jagtiani\"},\"description\":\"Kamini Jagtiani is a Senior Engineering Manager for the Query Team at Couchbase R&amp;D. Before Couchbase, Kamini was 7 years at Futurewei as Kernel Architect\/Manager and 13 years at IBM Informix as Software Engineer. Kamini has a Bachelors's degree in Computer Science and Engineering from Bombay University, India and holds 5 US patents.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/kaminijagtiani\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Index Advisor Service for Couchbase N1QL(SQL for JSON) - The Couchbase Blog","description":"Couchbase \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \ucffc\ub9ac \uc131\ub2a5\uc744 \uac1c\uc120\ud558\uae30 \uc704\ud574 JSON \ubb38\uc11c\uc5d0\uc11c SQL\uacfc \uc720\uc0ac\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud55c \ubcf4\uc870 \uc778\ub371\uc2a4 \uad8c\uc7a5 \uc0ac\ud56d\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.","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\/index-advisor-service\/","og_locale":"ko_KR","og_type":"article","og_title":"Index Advisor Service for Couchbase N1QL(SQL for JSON)","og_description":"Couchbase Index advisor provides secondary index recommendations for SQL-like queries on JSON documents to improve query performance.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-service\/","og_site_name":"The Couchbase Blog","article_published_time":"2019-12-26T18:54:55+00:00","article_modified_time":"2025-06-14T00:21:52+00:00","og_image":[{"width":400,"height":400,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png","type":"image\/png"}],"author":"Kamini Jagtiani","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kamini Jagtiani","Est. reading time":"6\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/"},"author":{"name":"Kamini Jagtiani","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f99c5767a877147f9cf658230bc2473b"},"headline":"Index Advisor Service for Couchbase N1QL(SQL for JSON)","datePublished":"2019-12-26T18:54:55+00:00","dateModified":"2025-06-14T00:21:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/"},"wordCount":847,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png","keywords":["Index Advisor","Indexes","Query optimization","Secondary indexes"],"articleSection":["SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/","url":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/","name":"Index Advisor Service for Couchbase N1QL(SQL for JSON) - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png","datePublished":"2019-12-26T18:54:55+00:00","dateModified":"2025-06-14T00:21:52+00:00","description":"Couchbase \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \ucffc\ub9ac \uc131\ub2a5\uc744 \uac1c\uc120\ud558\uae30 \uc704\ud574 JSON \ubb38\uc11c\uc5d0\uc11c SQL\uacfc \uc720\uc0ac\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud55c \ubcf4\uc870 \uc778\ub371\uc2a4 \uad8c\uc7a5 \uc0ac\ud56d\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/index-advisor-service\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/12\/ZgEfnw1X_400x400.png","width":400,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Index Advisor Service for Couchbase N1QL(SQL for JSON)"}]},{"@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\/f99c5767a877147f9cf658230bc2473b","name":"\uce74\ubbf8\ub2c8 \uc790\uadf8\ud2f0\uc544\ub2c8","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/257695296726c224fc7f0e85b30c9129","url":"https:\/\/secure.gravatar.com\/avatar\/546f9f69203064f77430f14922d59be33e3f0ea674078a793fc813dd40310c5c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/546f9f69203064f77430f14922d59be33e3f0ea674078a793fc813dd40310c5c?s=96&d=mm&r=g","caption":"Kamini Jagtiani"},"description":"\uce74\ubbf8\ub2c8 \uc790\uadf8\ud2f0\uc544\ub2c8\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 R&amp;D\uc758 \ucffc\ub9ac\ud300 \uc218\uc11d \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1 \ub9e4\ub2c8\uc800\uc785\ub2c8\ub2e4. Couchbase\uc5d0 \uc785\uc0ac\ud558\uae30 \uc804\uc5d0\ub294 Futurewei\uc5d0\uc11c \ucee4\ub110 \uc544\ud0a4\ud14d\ud2b8\/\uad00\ub9ac\uc790\ub85c 7\ub144, IBM Informix\uc5d0\uc11c \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4\ub85c 13\ub144 \ub3d9\uc548 \uadfc\ubb34\ud588\uc2b5\ub2c8\ub2e4. \uce74\ubbf8\ub2c8\ub294 \uc778\ub3c4 \ubd04\ubca0\uc774 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70 5\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/kaminijagtiani\/"}]}},"authors":[{"term_id":9099,"user_id":50908,"is_guest":0,"slug":"kaminijagtiani","display_name":"Kamini Jagtiani","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/546f9f69203064f77430f14922d59be33e3f0ea674078a793fc813dd40310c5c?s=96&d=mm&r=g","author_category":"","last_name":"Jagtiani","first_name":"Kamini","job_title":"","user_url":"","description":"\uce74\ubbf8\ub2c8 \uc790\uadf8\ud2f0\uc544\ub2c8\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 R&amp;D\uc758 \ucffc\ub9ac\ud300 \uc218\uc11d \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1 \ub9e4\ub2c8\uc800\uc785\ub2c8\ub2e4. Couchbase\uc5d0 \uc785\uc0ac\ud558\uae30 \uc804\uc5d0\ub294 Futurewei\uc5d0\uc11c \ucee4\ub110 \uc544\ud0a4\ud14d\ud2b8\/\uad00\ub9ac\uc790\ub85c 7\ub144, IBM Informix\uc5d0\uc11c \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4\ub85c 13\ub144 \ub3d9\uc548 \uadfc\ubb34\ud588\uc2b5\ub2c8\ub2e4. \uce74\ubbf8\ub2c8\ub294 \uc778\ub3c4 \ubd04\ubca0\uc774 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70 5\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/7940","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\/50908"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=7940"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/7940\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/7971"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=7940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=7940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=7940"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=7940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}