{"id":8187,"date":"2020-02-12T10:43:00","date_gmt":"2020-02-12T18:43:00","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=8187"},"modified":"2025-06-13T17:21:50","modified_gmt":"2025-06-14T00:21:50","slug":"index-advisor-service-for-couchbase-n1qlfeb-refresh","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 N1QL\uc6a9 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uc11c\ube44\uc2a4(2\uc6d4 \uc0c8\ub85c \uace0\uce68)"},"content":{"rendered":"

2\uc6d4\uc758 \ud560\uc778 \ud61c\ud0dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uc11c\ube44\uc2a4<\/a> \uc5d0\uc11c \ubc1c\uacac\ub41c \uba87 \uac00\uc9c0 \ubc84\uadf8\ub97c \uc218\uc815\ud55c \ud6c4 \uc5c5\ub370\uc774\ud2b8\ud588\uc2b5\ub2c8\ub2e4. \uc55e\uc73c\ub85c\ub3c4 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uc11c\ube44\uc2a4(\ubb34\uc2a8 \uc77c\uc774\uc8e0?<\/a>). \uc77c\ubc18\uc801\uc73c\ub85c \ub2e4\uc74c \uc720\uc9c0 \uad00\ub9ac \ub9b4\ub9ac\uc2a4\uc5d0\uc11c \ubcfc \uc218 \uc788\ub294 Index Advisor\uc758 \uc218\uc815 \uc0ac\ud56d\uc744 \uc774\uc81c \ub9e4\uc6d4 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ub204\uad6c\ub97c \uc704\ud55c \uc11c\ube44\uc2a4\uc778\uac00\uc694? \uc5b8\uc81c \uc0ac\uc6a9\ud574\uc57c \ud558\ub098\uc694?<\/h4>\n

https:\/\/index-advisor.couchbase.com\/<\/a><\/p>\n

\ubc18\ubcf5\ud574\uc11c \ub9d0\uc500\ub4dc\ub9ac\uc9c0\ub9cc,<\/p>\n

\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

\uc774 \uc11c\ube44\uc2a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4:<\/p>\n

    \n
  1. \uc77d\uc9c0 \uc54a\uc73c\ub824\uba74 \uc778\ub371\uc2a4 \uc0dd\uc131<\/a>\u00a0\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
  2. \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
  3. \u00a0\uc0ac\uc6a9 \uc911\uc785\ub2c8\ub2e4.\u00a0\uad6c\ud615 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ubc84\uc804(\ubc84\uc804 5.5,6.0)<\/strong>\u00a0\ucffc\ub9ac\uc5d0 \uc801\ud569\ud55c \uc778\ub371\uc2a4\ub97c \ub9cc\ub4dc\ub294 \ub370 \ub3c4\uc6c0\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/li>\n
  4. \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \uc870\uc5b8\uc744 \uc0dd\uc131\ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4.\u00a0\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

    \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<\/h4>\n

    \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 6.5 \uc11c\ubc84\ub97c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uace0 \ucffc\ub9ac \uc6cc\ud06c\ubca4\uce58\uc5d0\uc11c \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub3c4, \uc774 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \ucd5c\uc2e0 \ubc84\uc804(\ubcf4\uae30 \uc88b\uc740 UI\ub294 \uc5c6\uc9c0\ub9cc \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\ud568\uc774 \uc218\uc815\ub41c \ubc84\uc804)\uc785\ub2c8\ub2e4.<\/p>\n

    1. \uac00\uc0c1 \ud0a4 \uacf5\uac04\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4 \uc870\uc5b8<\/span><\/p>\n

    2. \uc0ad\uc81c\/\ubcd1\ud569\/\uc5c5\ub370\uc774\ud2b8 \ubb38\uc744 \uc704\ud55c \uac00\uc0c1 \ud0a4 \uacf5\uac04\uc744 \uc9c0\uc6d0\ud558\ub294 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800<\/span><\/p>\n

    \uc774 \ub450 \uac00\uc9c0 \uc218\uc815 \uc0ac\ud56d\uc744 \ubaa8\ub450 \uc801\uc6a9\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uac00 \uc218\uc815\ub429\ub2c8\ub2e4.<\/p>\n

    advise delete FROM aa where type=\"beer\" ;<\/pre>\n
    \ub97c \uc81c\uacf5\ud558\ub358<\/p>\n
    [\r\n  {\r\n    \"#operator\": \"Advise\",\r\n    \"advice\": {\r\n      \"#operator\": \"IndexAdvice\",\r\n      \"adviseinfo\": []\r\n    },\r\n    \"query\": \"delete FROM aa where type=\\\"beer\\\" ;\"\r\n  }\r\n]<\/span><\/pre>\n
    \uc774\uc81c<\/p>\n
    {\r\n  \"results\": [\r\n    {\r\n      \"#operator\": \"Advise\",\r\n      \"advice\": {\r\n        \"#operator\": \"IndexAdvice\",\r\n        \"adviseinfo\": {\r\n          \"recommended_indexes\": {\r\n            \"covering_indexes\": [\r\n              {\r\n                \"index_statement\": \"CREATE INDEX adv_type ON `aa`(`type`)\",\r\n                \"keyspace_alias\": \"aa\"\r\n              }\r\n            ],\r\n            \"indexes\": [\r\n              {\r\n                \"index_statement\": \"CREATE INDEX adv_type ON `aa`(`type`)\",\r\n                \"keyspace_alias\": \"aa\",\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      \"query\": \"delete FROM aa where type=\\\"beer\\\" ;\"\r\n    }\r\n  ]\r\n}<\/pre>\n
    3. Meta() \ud45c\ud604\uc2dd\uc5d0\uc11c \uc2dd\ubcc4\uc790\ub97c \uc81c\uac70\ud558\ub294 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800<\/span><\/p>\n
    \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uc758 \uacbd\uc6b0:<\/p>\n
    SELECT * FROM `beer-sample` d where SPLIT(meta(d).id, \":\")[0] like \"%cafe\"<\/pre>\n
    \uc6b0\ub9ac\ub294 \uc5bb\uc744 \uac83\uc785\ub2c8\ub2e4<\/p>\n
    {\r\n  \"adviseResult\": [\r\n    {\r\n      \"current_indexes\": [\r\n        {\r\n          \"index_statement\": \"CREATE PRIMARY INDEX beer_primary ON `beer-sample`\",\r\n          \"keyspace_alias\": \"beer-sample_d\"\r\n        }\r\n      ],\r\n      \"recommended_indexes\": {\r\n        \"indexes\": [\r\n          {\r\n            \"index_statement\": \"CREATE INDEX adv_split_meta_d_id_0 ON `beer-sample`(split((meta(`d`).`id`), ':')[0])\",\r\n            \"keyspace_alias\": \"beer-sample_d\",\r\n            \"recommending_rule\": \"Index keys follow order of predicate types: 9. function index.\"\r\n          }\r\n        ]\r\n      }\r\n    }\r\n  ]\r\n}<\/span><\/pre>\n
    \uc774\uc81c \uc774\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \uc218\uc815\ud588\uc2b5\ub2c8\ub2e4:<\/p>\n
    {\r\n  \"results\": [\r\n    {\r\n      \"#operator\": \"Advise\",\r\n      \"advice\": {\r\n        \"#operator\": \"IndexAdvice\",\r\n        \"adviseinfo\": {\r\n          \"recommended_indexes\": {\r\n            \"indexes\": [\r\n              {\r\n                \"index_statement\": \"CREATE INDEX adv_split_meta_self_id_0 ON `beer-sample`(split((meta(`self`)<\/span>.`id`), ':')[0])\",\r\n                \"keyspace_alias\": \"beer-sample_d\",\r\n                \"recommending_rule\": \"Index keys follow order of predicate types: 9. like.\"\r\n              }\r\n            ]\r\n          }\r\n        }\r\n      },\r\n      \"query\": \"SELECT * FROM `beer-sample` d where SPLIT(meta(d).id, \\\":\\\")[0] like \\\"%cafe\\\"\"\r\n    }\r\n  ]\r\n}<\/pre>\n
    \ub97c \ud074\ub9ad\ud558\uc138\uc694.<\/p>\n
    4. \ucffc\ub9ac: \uc870\uc5b8 \uae30\ub2a5 \ud63c\ub780\uc2a4\ub7ec\uc6b4 \uba54\uc2dc\uc9c0<\/span><\/p>\n
    \ud63c\ub780\uc2a4\ub7ec\uc6b4 \uc624\ub958 \uba54\uc2dc\uc9c0\uac00 \ubcf4\ub2e4 \uc0c1\uc138\ud558\uace0 \uba85\ud655\ud55c \uc124\uba85\uc73c\ub85c \ub300\uccb4\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
    5. USE \uc778\ub371\uc2a4 \ud0a4\uc6cc\ub4dc\uac00 \uc788\ub294 \ucffc\ub9ac\uc5d0 \uc870\uc5b8\uc744 \uc0ac\uc6a9\ud558\uba74 \uc798\ubabb\ub41c \uc624\ub958\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/span><\/p>\n
    advise select id,url,address,title,city,name,country,public_likes from bucket0 use index (def_primary)<\/strong> where some p in public_likes satisfies p like \"Ge%\" END AND type = \"hotel\" order by id, url, address, title, city DESC, name, country<\/pre>\n
    \uc81c\uacf5\uc5d0 \uc0ac\uc6a9<\/p>\n
    [\r\n  {\r\n    \"#operator\": \"Advise\",\r\n    \"advice\": {\r\n      \"#operator\": \"IndexAdvice\",\r\n      \"adviseinfo\": [\r\n        {\r\n          \"recommended_indexes\": \"No index recommendation at this time: no keyspace found.\"\r\n        }\r\n      ]\r\n    },\r\n    \"query\": \"select id,url,address,title,city,name,country,public_likes from bucket0 use index (def_primary) where some p in public_likes satisfies p like \\\"Ge%\\\" END AND type = \\\"hotel\\\" order by id, url, address, title, city DESC, name, country\"\r\n  }\r\n]<\/span><\/pre>\n
    \uc774\uc81c<\/p>\n
    {\r\n  \"results\": [\r\n    {\r\n      \"#operator\": \"Advise\",\r\n      \"advice\": {\r\n        \"#operator\": \"IndexAdvice\",\r\n        \"adviseinfo\": {\r\n          \"recommended_indexes\": {\r\n            \"covering_indexes\": [\r\n              {\r\n                \"index_statement\": \"CREATE INDEX adv_type_DISTINCT_public_likes_id_url_city_name_title_address_country_public_likes ON `bucket0`(`type`,DISTINCT ARRAY `p` FOR p in `public_likes` END,`id`,`url`,`city`,`name`,`title`,`address`,`country`,`public_likes`)\",\r\n                \"keyspace_alias\": \"bucket0\"\r\n              }\r\n            ],\r\n            \"indexes\": [\r\n              {\r\n                \"index_statement\": \"CREATE INDEX adv_type_DISTINCT_public_likes ON `bucket0`(`type`,DISTINCT ARRAY `p` FOR p in `public_likes` END)\",\r\n                \"keyspace_alias\": \"bucket0\",\r\n                \"recommending_rule\": \"Index keys follow order of predicate types: 2. equality\/null\/missing, 6. array predicate.\"\r\n              }\r\n            ]\r\n          }\r\n        }\r\n      },\r\n      \"query\": \"select id,url,address,title,city,name,country,public_likes from bucket0 use index (def_primary) where some p in public_likes satisfies p like \\\"Ge%\\\" END AND type = \\\"hotel\\\" order by id, url, address, title, city DESC, name, country\"\r\n    }\r\n  ]\r\n}<\/pre>\n
    \uba87 \uac00\uc9c0 \uc791\uc740 \uac1c\uc120 \uc0ac\ud56d\ub3c4 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
    \uc0ac\uc6a9\ud574 \ubcf4\uc2dc\uace0 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uc11c\ube44\uc2a4\uc5d0\uc11c \ucd94\ucc9c\ud558\ub294 \uc778\ub371\uc2a4\uc5d0 \ubb38\uc81c\uac00 \uc788\ub294 \uacbd\uc6b0 \uc774 \ube14\ub85c\uadf8\uc5d0 \ub313\uae00\ub85c \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
    \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uae30\ub2a5\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694:<\/h4>\n
    https:\/\/www.couchbase.com\/blog\/index-advisor-service\/<\/a><\/p>\n
    https:\/\/www.couchbase.com\/blog\/n1ql-index-advisor-improve-query-performance-and-productivity\/<\/a><\/p>\n
    https:\/\/www.couchbase.com\/blog\/index-advisor-for-query-workload\/<\/a><\/p>\n
    https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/advise.html<\/a><\/p>\n
    https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/advisor.html<\/a><\/p>\n
    https:\/\/docs.couchbase.com\/server\/6.5\/tools\/query-workbench.html#index-advisor<\/a><\/p>\n
    <\/h4>","protected":false},"excerpt":{"rendered":"
    This is our Feb drop for Index Advisor service after fixing some of the bugs that were found. We plan to keep improvising the Index Advisor service(What is it?). The fixes in Index Advisor that you would normally see in […]<\/p>","protected":false},"author":50908,"featured_media":2560,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[2225,1816,2453,1812],"tags":[2439,2440,2445,2444],"ppma_author":[9099],"class_list":["post-8187","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-couchbase-server","category-global-secondary-index","category-n1ql-query","tag-index-advisor","tag-indexes","tag-query-optimization","tag-secondary-indexes"],"acf":[],"yoast_head":"\nIndex Advisor Service for Couchbase N1QL(Feb refresh) - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"Follow-up blog for recent defects fixed in 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-for-couchbase-n1qlfeb-refresh\/\" \/>\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(Feb refresh)\" \/>\n<meta property=\"og:description\" content=\"Follow-up blog for recent defects fixed in 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-for-couchbase-n1qlfeb-refresh\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-12T18:43:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:21:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\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=\"4\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-for-couchbase-n1qlfeb-refresh\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/\"},\"author\":{\"name\":\"Kamini Jagtiani\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f99c5767a877147f9cf658230bc2473b\"},\"headline\":\"Index Advisor Service for Couchbase N1QL(Feb refresh)\",\"datePublished\":\"2020-02-12T18:43:00+00:00\",\"dateModified\":\"2025-06-14T00:21:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/\"},\"wordCount\":395,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png\",\"keywords\":[\"Index Advisor\",\"Indexes\",\"Query optimization\",\"Secondary indexes\"],\"articleSection\":[\"Couchbase Capella\",\"Couchbase Server\",\"Global Secondary Index\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/\",\"name\":\"Index Advisor Service for Couchbase N1QL(Feb refresh) - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png\",\"datePublished\":\"2020-02-12T18:43:00+00:00\",\"dateModified\":\"2025-06-14T00:21:50+00:00\",\"description\":\"Follow-up blog for recent defects fixed in 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-for-couchbase-n1qlfeb-refresh\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png\",\"width\":512,\"height\":512,\"caption\":\"N1QL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#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(Feb refresh)\"}]},{\"@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&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(Feb refresh) - The Couchbase Blog","description":"Couchbase Index advisor\uc758 \ucd5c\uadfc \uacb0\ud568 \uc218\uc815\uc5d0 \ub300\ud55c \ud6c4\uc18d \ube14\ub85c\uadf8\uc5d0\uc11c\ub294 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uae30 \uc704\ud574 JSON \ubb38\uc11c\uc758 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-for-couchbase-n1qlfeb-refresh\/","og_locale":"ko_KR","og_type":"article","og_title":"Index Advisor Service for Couchbase N1QL(Feb refresh)","og_description":"Follow-up blog for recent defects fixed in 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-for-couchbase-n1qlfeb-refresh\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-02-12T18:43:00+00:00","article_modified_time":"2025-06-14T00:21:50+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png","type":"image\/png"}],"author":"Kamini Jagtiani","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kamini Jagtiani","Est. reading time":"4\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/"},"author":{"name":"Kamini Jagtiani","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f99c5767a877147f9cf658230bc2473b"},"headline":"Index Advisor Service for Couchbase N1QL(Feb refresh)","datePublished":"2020-02-12T18:43:00+00:00","dateModified":"2025-06-14T00:21:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/"},"wordCount":395,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png","keywords":["Index Advisor","Indexes","Query optimization","Secondary indexes"],"articleSection":["Couchbase Capella","Couchbase Server","Global Secondary Index","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/","url":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/","name":"Index Advisor Service for Couchbase N1QL(Feb refresh) - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png","datePublished":"2020-02-12T18:43:00+00:00","dateModified":"2025-06-14T00:21:50+00:00","description":"Couchbase Index advisor\uc758 \ucd5c\uadfc \uacb0\ud568 \uc218\uc815\uc5d0 \ub300\ud55c \ud6c4\uc18d \ube14\ub85c\uadf8\uc5d0\uc11c\ub294 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uae30 \uc704\ud574 JSON \ubb38\uc11c\uc758 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-for-couchbase-n1qlfeb-refresh\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/02\/n1ql.png","width":512,"height":512,"caption":"N1QL"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-service-for-couchbase-n1qlfeb-refresh\/#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(Feb refresh)"}]},{"@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&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&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\/8187","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=8187"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/8187\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/2560"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=8187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=8187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=8187"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=8187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}