{"id":9221,"date":"2021-01-19T18:53:02","date_gmt":"2021-01-20T02:53:02","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=9221"},"modified":"2025-06-13T17:32:24","modified_gmt":"2025-06-14T00:32:24","slug":"index-advisor-to-support-self-verification-and-index-pushdowns","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-to-support-self-verification-and-index-pushdowns\/","title":{"rendered":"\uc790\uccb4 \uac80\uc99d \ubc0f \uc778\ub371\uc2a4 \ud478\uc2dc\ub2e4\uc6b4\uc744 \uc9c0\uc6d0\ud558\ub294 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800"},"content":{"rendered":"<p>N1QL \ubb38\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800(ADVISE \ubb38 )\uac00 Couchbase Server 6.6\uc5d0\uc11c \uacf5\uc2dd \ucd9c\uc2dc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <span style=\"font-weight: 400;\">\ub9cc\ub4e4\ub824\uba74<strong> \ucd5c\uc120\uc758 \ub178\ub825<\/strong> \uc81c\uacf5 <\/span><strong>\uae00\ub85c\ubc8c \ubcf4\uc870 \uc778\ub371\uc2a4 <\/strong><span style=\"font-weight: 400;\">\uad8c\uc7a5 \ub300\uc0c1<\/span> <span style=\"font-weight: 400;\">\uac01<\/span><strong> \ud0a4 \uc2a4\ud398\uc774\uc2a4<\/strong><span style=\"font-weight: 400;\"> \ucffc\ub9ac\uc5d0\uc11c <\/span><strong>\ub354 \ub098\uc740 <\/strong><span style=\"font-weight: 400;\">\ubcf4\ub2e4<\/span> <span style=\"font-weight: 400;\">\ud604\uc7ac \uc874\uc7ac\ud558\ub294 \ubaa8\ub4e0 \uae30\uc874 \uc778\ub371\uc2a4\uc640 \uc778\ub371\uc2a4\uac00 \ube4c\ub4dc \uc9c0\uc5f0 \uc911\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p>\uae30\ub2a5 \uc911 \uac15\uc870 \ud45c\uc2dc\ub41c \ubd80\ubd84\uc5d0 \ub300\ud574 \uc880 \ub354 \uc790\uc138\ud788 \uc124\uba85\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>\ucd5c\uc120\uc758 \ub178\ub825:\n<ul>\n<li>\uc644\uc804\uc131 \ubcf4\uc7a5 \uc5c6\uc74c: \uc778\ub371\uc2a4 \uad8c\uc7a5 \uc0ac\ud56d \uc5c6\uc74c <span style=\"font-weight: 400;\">\uc220\uc5b4\ub098 \ud30c\uc0dd \ud544\ud130\uac00 \uc5c6\ub294 \uacbd\uc6b0.<\/span><\/li>\n<li>\uc624\ud0d0 \uc5c6\ub294 \uc815\ud655\uc131.<\/li>\n<\/ul>\n<\/li>\n<li>GSI \uc9c0\uc218\ub9cc \ucd94\ucc9c\ud558\uace0 \uae30\ubcf8 \uc9c0\uc218\ub294 \ucd94\ucc9c\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\uc778\ub371\uc2a4 \ucd94\ucc9c\uc740 \ucffc\ub9ac\uc640 \uad00\ub828\ub41c \uac01 \ud0a4 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c \uac83\uc785\ub2c8\ub2e4.<\/li>\n<li>\ub354 \uc88b\uc2b5\ub2c8\ub2e4: \ucffc\ub9ac \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \ucffc\ub9ac \uc2e4\ud589 \uc2dc \ub2e4\ub978 \ubaa8\ub4e0 \uae30\uc874 \uc778\ub371\uc2a4\ubcf4\ub2e4 \uad8c\uc7a5 \uc778\ub371\uc2a4\ub97c \uc120\ud638\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uad8c\uc7a5 \uc778\ub371\uc2a4\uac00 \ucffc\ub9ac\uc5d0 \ub300\ud55c \ucd5c\uc801\uc758 \uc778\ub371\uc2a4\ub77c\ub294 \ubcf4\uc7a5\uc740 \uc5c6\uc2b5\ub2c8\ub2e4. \ud604\uc7ac \ub9b4\ub9ac\uc988\uc758 \uacbd\uc6b0, \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \uaddc\uce59 \uae30\ubc18 \ucffc\ub9ac \ucd5c\uc801\ud654 \ub3c4\uad6c\uc5d0 \ub300\ud574\uc11c\ub9cc \uc870\uc5b8\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ube44\uc6a9 \uae30\ubc18 \ucffc\ub9ac \ucd5c\uc801\ud654 \ub3c4\uad6c\uc5d0 \ub300\ud55c \uc9c0\uc6d0\uc740 \ub2e4\uc74c \ub9b4\ub9ac\uc988\uc5d0\uc11c \uc81c\uacf5\ub420 \uc608\uc815\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\uc704 \uae30\ub2a5\uc758 \uacac\uace0\uc131\uc744 \ub192\uc774\uace0 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub97c \uc9c0\uc18d\uc801\uc73c\ub85c \uac1c\uc120\ud558\uae30 \uc704\ud574 \uc774\ubc88 \ub9b4\ub9ac\uc2a4\uc5d0 \uba87 \uac00\uc9c0 \ud601\uc2e0\uc801\uc778 \uae30\ub2a5\uc774 \ub3c4\uc785\ub418\uc5c8\uc73c\uba70, \uc774 \uae00\uc5d0\uc11c\ub294 \uadf8 \uc911 \uba87 \uac00\uc9c0\uc758 \uc124\uacc4 \uc138\ubd80 \uc0ac\ud56d\uc744 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcfc \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h4>\uac00\uc0c1 \uc778\ub371\uc2a4 \uac80\uc99d \ud504\ub808\uc784\uc6cc\ud06c<\/h4>\n<p style=\"text-align: left;\"><span style=\"font-weight: 400;\">\ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4 \ucd94\ucc9c\uc758 \uacbd\uc6b0, \ucee4\ubc84\ub9c1 \uc18d\uc131\uc758 \uc815\ud655\uc131\uc744 \ubcf4\uc7a5\ud558\ub294 \uac83\uc740 ARRAY \uc220\uc5b4\uc640 UNNEST \uc5f0\uc0b0 \ubaa8\ub450\uc5d0 \ub300\ud55c ARRAY \uc778\ub371\uc2a4\uc758 \uc911\ucca9\ub41c \uac1d\uccb4\uc758 \ubcf5\uc7a1\uc131\uc73c\ub85c \uc778\ud574 \ub9e4\uc6b0 \uc5b4\ub835\uc2b5\ub2c8\ub2e4. To <\/span><span style=\"font-weight: 400;\">\uad8c\uc7a5 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uac00 \ucffc\ub9ac \uc2e4\ud589\uc5d0\uc11c \uc2e4\uc81c \ucee4\ubc84\ub9c1 \uc2a4\uce94\uc744 \uad6c\ucd95\ud560 \uc218 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uae30 \uc704\ud574 \uac80\uc99d\uc744 \ubaa9\uc801\uc73c\ub85c \uc0c8\ub85c\uc6b4 \ud53c\ub4dc\ubc31 \ud504\ub808\uc784\uc6cc\ud06c\uac00 \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p style=\"text-align: left;\"><span style=\"font-weight: 400;\">\uc544\ub798 \uadf8\ub9bc\uacfc \uac19\uc774 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \ucd94\ucc9c \ucee4\ubc84\ub9ac\uc9c0 \uc778\ub371\uc2a4 \ud6c4\ubcf4\uc5d0 \ub300\ud55c \uac00\uc0c1 GSI \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\uace0 \ucffc\ub9ac \ucd5c\uc801\ud654 \ud504\ub85c\uadf8\ub7a8\uc5d0 \ud53c\ub4dc\ubc31\ud558\uc5ec \uae30\uc874\uc758 \ub2e4\ub978 \ubaa8\ub4e0 \uc778\ub371\uc2a4 \uc911\uc5d0\uc11c \ucd5c\uc801\ud654 \ud504\ub85c\uadf8\ub7a8\uc5d0 \uc758\ud574 \uc120\ud0dd\ub420 \uc218 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc5ec \uc2e4\ud589 \uacc4\ud68d\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. <\/span>\uac00\uc0c1 \uc778\ub371\uc2a4\ub294 \uba54\ud0c0\ub370\uc774\ud130\ub97c \ubaa8\ubc29\ud558\uae30 \uc704\ud55c \uc778\uba54\ubaa8\ub9ac \ub370\uc774\ud130 \uad6c\uc870\uc785\ub2c8\ub2e4. <span style=\"font-weight: 400;\">\uc77c\ubc18 \uc778\ub371\uc2a4\uc5d0 \ucd94\uac00\ud558\uc5ec \uc635\ud2f0\ub9c8\uc774\uc800\uac00 \uc778\ub371\uc2a4 \uc2a4\uce94 \uc5f0\uc0b0\uc790\ub97c \uc0dd\uc131\ud560 \ub54c \ub2e4\ub978 \uc77c\ubc18 \uc778\ub371\uc2a4\uc640 \ub3d9\uc77c\ud558\uac8c \uace0\ub824\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. \uac80\uc99d \ub2e8\uacc4\uc5d0\uc11c \ucee4\ubc84\ub9c1 \uc2a4\uce94 \uc5f0\uc0b0\uc790\uc5d0 \uac00\uc0c1 \uc778\ub371\uc2a4\uac00 \ub098\ud0c0\ub098\uba74 \uc0ac\uc6a9\uc790\uac00 \uc0dd\uc131\ud55c \ud6c4\uc5d0\ub3c4 \ub3d9\uc77c\ud55c \ubc29\uc2dd\uc73c\ub85c \uc791\ub3d9\ud558\ubbc0\ub85c \uc774\ub97c \ubc18\ud658\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p style=\"text-align: left;\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9248 aligncenter\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/08\/1-300x192.png\" alt=\"\" width=\"724\" height=\"464\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/1-300x192.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/1-768x492.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/1-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/1.png 910w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\ub3d9\uc2dc\uc5d0, \uac80\uc99d \ud53c\ub4dc\ubc31 \ub8e8\ud504\ub294 \uad8c\uc7a5 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uc758 \ud478\uc2dc\ub2e4\uc6b4 \uc18d\uc131\uc744 \ud3c9\uac00\ud558\ub294 \ub370\ub3c4 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uc758 \ucd9c\ub825\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc774 \uc778\ub371\uc2a4 \ud478\uc2dc\ub2e4\uc6b4 \uc18d\uc131\uc744 \uc81c\uacf5\ud558\ub294 \"index_property\"\ub77c\ub294 \uc0c8\ub85c\uc6b4 \ud544\ub4dc\uac00 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc81c\ud55c \ud478\uc2dc\ub2e4\uc6b4<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc624\ud504\uc14b \ud478\uc2dc\ub2e4\uc6b4<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc8fc\ubb38 \ud478\uc2dc\ub2e4\uc6b4<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uadf8\ub8f9 \ubc0f \uc9d1\uacc4 \ud478\uc2dc\ub2e4\uc6b4<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc804\uccb4 \uadf8\ub8f9 \ubc0f \uc9d1\uacc4 \ud478\uc2dc\ub2e4\uc6b4<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\uc774 \uae30\ub2a5\uc774 \uc124\uc815\ub418\uc5c8\uc73c\ubbc0\ub85c \uc544\ub798\uc5d0\uc11c \uc124\uba85\ud558\ub294 \uc0c8\ub85c\uc6b4 \uc601\uc5ed\uc744 \ud0d0\uc0c9\ud560 \uc900\ube44\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<h4><\/h4>\n<p>&nbsp;<\/p>\n<h4><span style=\"font-weight: 400;\">\ucee4\ubc84\ub9ac\uc9c0 \uc9c0\uc218 \ucd94\ucc9c\uc758 \uc9c0\uc218 \ud478\uc2dc\ub2e4\uc6b4<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">\uc778\ub371\uc2a4 \ud478\uc2dc\ub2e4\uc6b4\uc740 \ucffc\ub9ac \uc5d4\uc9c4\uc774 \ub354 \ub9ce\uc740 \uc791\uc5c5\uc744 \uc778\ub371\uc11c\uc5d0\uac8c \ud478\uc2dc\ud558\ub294 \uc131\ub2a5 \ucd5c\uc801\ud654 \uae30\ub2a5\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \ucffc\ub9ac \uc131\ub2a5\uc744 \ub354\uc6b1 \uac1c\uc120\ud558\uae30 \uc704\ud574 \ub354 \ub192\uc740 \ud478\uc2dc\ub2e4\uc6b4 \uc18d\uc131\uc744 \uac00\uc9c4 \uc9c0\uc218\ub97c \ucd94\ucc9c\ud560 \uc218 \uc788\ub294 \uac00\ub2a5\uc131\uc744 \ubaa8\uc0c9\ud558\uae30 \uc704\ud574 \ucd5c\uc120\uc744 \ub2e4\ud569\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\uc544\ub798 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uacfc \uac19\uc774 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4 \uc704\uc5d0 \uc138 \uac00\uc9c0 \uc885\ub958\uc758 \ud478\uc2dc\ub2e4\uc6b4\uc774 \uc801\uc6a9\ub429\ub2c8\ub2e4: \uadf8\ub8f9 \uae30\uc900\/\uc9d1\uacc4, \uc8fc\ubb38 \uae30\uc900, \uc81c\ud55c\/\uc624\ud504\uc14b(\ud574\ub2f9\ub418\ub294 \uacbd\uc6b0)\uc785\ub2c8\ub2e4. \uac01\uac01\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9253 aligncenter\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/08\/Untitled-Diagram-1-copy-300x254.png\" alt=\"\" width=\"548\" height=\"464\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Untitled-Diagram-1-copy-300x254.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Untitled-Diagram-1-copy-20x17.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Untitled-Diagram-1-copy.png 693w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><\/p>\n<h5><span style=\"font-weight: 400;\">\uc778\ub371\uc2a4 \uadf8\ub8f9\ud654\/\uc9d1\uacc4\u00a0<\/span><\/h5>\n<p>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc124\uacc4\ub97c \ub530\ub985\ub2c8\ub2e4. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/understanding-index-grouping-aggregation-couchbase-n1ql-query\/\">\uc778\ub371\uc2a4 \uadf8\ub8f9\ud654 \ubc0f \uc9d1\uacc4<\/a> \ub97c \ub2e4\uc74c\uacfc \uac19\uc740 \uce21\uba74\uc5d0\uc11c \uc0b4\ud3b4\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>6\uac00\uc9c0 \uc720\ud615\uc758 \uc9d1\uacc4\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4: \ucd5c\uc18c, \ucd5c\ub300, \ud3c9\uade0, \ud569\uacc4, \uce74\uc6b4\ud2b8 \ubc0f \uce74\uc6b4\ud2b8 \uc218\uc785\ub2c8\ub2e4.<\/li>\n<li>\ub354 \ub098\uc740 \uc131\ub2a5\uc744 \uc704\ud574 \uc778\ub371\uc2a4 \ud0a4\uc758 \uc21c\uc11c\ub97c \uc870\uc815\ud558\uc5ec \uc804\uccb4\/\ubd80\ubd84 \uc9d1\uacc4\ub97c \ub2ec\uc131\ud558\uae30 \uc704\ud574 \ucd5c\uc120\uc758 \ub178\ub825\uc744 \uae30\uc6b8\uc785\ub2c8\ub2e4.\n<ul>\n<li>\uc804\uccb4 \uc9d1\uacc4\ub294 \uc778\ub371\uc11c <span style=\"font-weight: 400;\">\ub294 \uc804\uccb4 \uadf8\ub8f9 \uc9d1\uacc4\ub97c \ucc98\ub9ac\ud558\uc5ec \ucffc\ub9ac \uc5d4\uc9c4\uc774 \uc774 \uc5f0\uc0b0\uc790 \uc804\uccb4\ub97c \uac74\ub108\ub6f8 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. <\/span><\/li>\n<li><span style=\"font-weight: 400;\">\ubd80\ubd84 \uc9d1\uacc4 \ubc29\uc2dd\uc785\ub2c8\ub2e4, <\/span><span style=\"font-weight: 400;\">\uc778\ub371\uc11c\ub294 \ucffc\ub9ac\uc5d0 \ubd80\ubd84 \uadf8\ub8f9 \uc9d1\uacc4\ub97c \ubcf4\ub0b4\uace0 \ucffc\ub9ac\uc5d0 \uc751\ub2f5\ud558\uc5ec \uc911\uac04 \uacb0\uacfc\ub97c \ubcd1\ud569\ud558\uace0 \ucd5c\uc885 \uadf8\ub8f9 \ubc0f \uc9d1\uacc4 \uc5f0\uc0b0\uc790\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>\uc804\uccb4 \ud478\uc2dc\ub2e4\uc6b4\uc774 \uc801\uc6a9\ub420 \ub54c\ub9cc \uac00\ub2a5\ud55c DISTINCT \uc9d1\uacc4\uc5d0 \ub300\ud55c \ud2b9\uc218 \ucc98\ub9ac.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h6><i><span style=\"font-weight: 400;\">\uc804\uc81c \uc870\uac74:<\/span><\/i><\/h6>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\ubaa8\ub4e0 \uc220\uc5b4\ub294 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uac00 \uc788\ub294 \ubc94\uc704 \uc2a4\uce94\uc73c\ub85c \uc815\ud655\ud558\uac8c \ubcc0\ud658\ub429\ub2c8\ub2e4, <\/span><span style=\"font-weight: 400;\">\ucffc\ub9ac\uc5d0 JOIN \ub610\ub294 NEST\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h6><span style=\"font-weight: 400;\">\u00a0\uc0ac\uc6a9 \ub300\uc0c1<\/span><i><span style=\"font-weight: 400;\"> DISTINCT\uac00 \uc5c6\ub294 \uc9d1\uacc4:<\/span><\/i><\/h6>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc778\ub371\uc2a4 \ucd94\ucc9c \uaddc\uce59\uc5d0 \ub530\ub77c \uc220\uc5b4\ub97c \uae30\ubc18\uc73c\ub85c \uc778\ub371\uc2a4 \ud0a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">GROUP BY \ud0a4\uc758 \uc704\uce58\ub97c \ub3d9\uc77c\uc131 \uc220\uc5b4\uc5d0\uc11c \uac74\ub108\ub6f0\uc5b4 \uc120\ud589 \uc778\ub371\uc2a4 \ud0a4\uc640 \ub3d9\ub4f1\ud558\uac70\ub098 \uc885\uc18d\ub418\ub3c4\ub85d \uc870\uc815\ud558\uace0, t<\/span><span style=\"font-weight: 400;\">GROUP BY \ud0a4 \uc548\uc758 \uc21c\uc11c\ub294 \uc911\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc778\ub371\uc2a4 \ud0a4\uc640 \uac19\uc9c0 \uc54a\uac70\ub098 \uc885\uc18d\uc801\uc774\uc9c0 \uc54a\uc740 GROUP BY \ud45c\ud604\uc2dd\uc758 \uacbd\uc6b0 \uc778\ub371\uc2a4 \ud0a4\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc778\ub371\uc2a4 \uc870\uac74\uc5d0 \ud574\ub2f9\ud558\ub294 GROUP BY \ud45c\ud604\uc2dd\uc758 \uacbd\uc6b0 \uc778\ub371\uc2a4 \uc870\uac74\uc744 \uc778\ub371\uc2a4 \ud0a4\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/span><\/li>\n<li>\ud22c\uc601\uc744 \ucd94\uac00\ud558\uc5ec \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<span style=\"font-weight: 400;\">\uc9d1\uacc4 \ud45c\ud604\uc2dd\uc740 \uc778\ub371\uc2a4 \ud0a4\uc758 \uc5b4\ub290 \uacf3\uc5d0\ub098 \uc788\uac70\ub098 \uc778\ub371\uc2a4 \ud0a4 \ub610\ub294 \uba54\ud0c0().id\uc5d0 \uc885\uc18d\ub429\ub2c8\ub2e4.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h6><i><span style=\"font-weight: 400;\">\uc9d1\uacc4 w DISTINCT \uc758 \uc791\ub3d9 \ubc29\uc2dd :<\/span><\/i><\/h6>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc804\uccb4 \ud478\uc2dc\ub2e4\uc6b4\uc774 \uc801\uc6a9\ub418\ub294 \uacbd\uc6b0\uc5d0\ub9cc \ud574\ub2f9\ub429\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc704\uc640 \ub3d9\uc77c\ud55c \uaddc\uce59\uc774 GROUP BY \ud45c\ud604\uc2dd\uc5d0\ub3c4 \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uace0\uc720 \uc9d1\uacc4 \ud45c\ud604\uc2dd\uc740 \ub3d9\uc77c\uc131 \uc220\uc5b4\uc5d0\uc11c (n)\uc744 \uac74\ub108\ub6f0\uc5b4 \uc120\ud589 \uc778\ub371\uc2a4 \ud0a4\uc640 \ub3d9\ub4f1\ud558\uac70\ub098 (n+1)\uc5d0 \uc885\uc18d\ub418\uc5b4\uc57c \ud558\uba70, \uc5ec\uae30\uc11c n\uc740 GROUP BY \ud56d\ubaa9\uc758 \uc218\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h5>\uc778\ub371\uc2a4 \uc21c\uc11c<\/h5>\n<p>ORDER BY \ud0a4\uac00 \uc778\ub371\uc2a4 \ud0a4 \uc21c\uc11c\uc640 \uc815\ub82c\ub41c \uacbd\uc6b0 \ucffc\ub9ac \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 ORDER BY \uc5f0\uc0b0\uc790 \uc0dd\uc131\uc744 \uac74\ub108\ub6f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \uadf8\uc5d0 \ub530\ub77c \uc870\uc815\ud558\uae30 \uc704\ud574 \ucd5c\uc120\uc758 \ub178\ub825\uc744 \uae30\uc6b8\uc785\ub2c8\ub2e4.<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ORDER BY \ud478\uc2dc\ub2e4\uc6b4 \uc18d\uc131\uc744 \uac00\uc9c4 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\ub824\uba74 GROUP BY\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 GROUP BY\/Aggregate \ud478\uc2dc\ub2e4\uc6b4 \ub610\ub294 \uc77c\ubc18 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4 \uc704\uc5d0 ORDER BY \uc778\ub371\uc2a4 \ud0a4\ub97c \uc7ac\ubc30\uce58\ud569\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc804\uccb4 \uadf8\ub8f9 \uae30\uc900\/\uc9d1\uacc4 \ud478\uc2dc\ub2e4\uc6b4 \uc704\uc5d0\ub9cc \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ORDER BY \ud45c\ud604\uc2dd\uc740 \ub3d9\uc77c\uc131 \uc220\uc5b4\uc5d0\uc11c \uc778\ub371\uc2a4 \ud0a4\uc758 \uc21c\uc11c\ub97c \uac74\ub108\ub6f0\ub294 \ubc29\uc2dd\uc73c\ub85c \uc778\ub371\uc2a4 \ud0a4\uc758 \uc21c\uc11c\ub97c \ub530\ub985\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ORDER BY \uc6a9\uc5b4\ub97c \uc544\ub798\ub85c \ub0b4\ub9b4 \uc218 \uc788\ub294 \uacbd\uc6b0 \ub0b4\ub9bc\ucc28\uc21c\uc774 \uc788\ub294 \uc6a9\uc5b4\uc5d0 \"DESC\"\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">GROUP BY\/Aggregate \ud478\uc2dc\ub2e4\uc6b4\uacfc \ub2ec\ub9ac, ORDER BY \uc870\uac74 \ub0b4\ubd80\uc758 \uc21c\uc11c\uac00 \uc911\uc694\ud569\ub2c8\ub2e4. \ucffc\ub9ac\uc5d0 GROUP BY\uc640 ORDER BY\uac00 \ubaa8\ub450 \uc874\uc7ac\ud558\uc9c0\ub9cc \uc778\ub371\uc2a4 \ud478\uc2dc\ub2e4\uc6b4\uc744 \ud568\uaed8 \uc218\ud589\ud560 \uc218 \uc5c6\ub294 \uc2dc\ub098\ub9ac\uc624\uc5d0\uc11c \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \uc774\ub97c \uac1c\ubcc4\uc801\uc73c\ub85c \ucc98\ub9ac\ud558\uace0 \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \uac80\uc99d \ud504\ub808\uc784\uc6cc\ud06c\uc5d0 \uc758\uc874\ud558\uc5ec \ub354 \ub098\uc740 \uac83\uc744 \uc120\ud0dd\ud558\uac8c \ub429\ub2c8\ub2e4.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h5>\ud398\uc774\uc9c0 \ub9e4\uae40<\/h5>\n<p><span style=\"font-weight: 400;\">\uc9c0\uc218 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \uc81c\ud55c\/\uc624\ud504\uc14b \ud478\uc2dc\ub2e4\uc6b4\uc5d0 \ub300\ud55c \ud2b9\uc815 \ucc98\ub9ac\ub97c \ud558\uc9c0 \uc54a\uc73c\uba70, \uc2e4\uc81c\ub85c \uc774\uc804 \ub450 \ud478\uc2dc\ub2e4\uc6b4\uc774 \uc788\ub294 \uacbd\uc6b0 \uadf8 \uc704\uc5d0 \uc801\uc6a9\ud558\uac70\ub098 \uc6d0\ub798 \ucee4\ubc84\ub9ac\uc9c0 \uc9c0\uc218\uc5d0 \uc9c1\uc811 \uc801\uc6a9\ud569\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">\uac00\uc0c1 \uc778\ub371\uc2a4 \ud53c\ub4dc\ubc31 \ub8e8\ud504\uc5d0 \uc758\ud574 \ud478\uc2dc\ub2e4\uc6b4 \ud504\ub85c\ud37c\ud2f0\uac00 \ud655\uc778\ub418\uace0 \ud574\ub2f9\ub418\ub294 \uacbd\uc6b0 \"pushdown_property\"\uc5d0 \ud45c\uc2dc\ub418\ub294 \uba87 \uac00\uc9c0 \uc608\ub97c \uc544\ub798\uc5d0\uc11c \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p>\uc608 1:<\/p>\n<pre class=\"lang:default decode:true\">ADVISE SELECT sum(d)\r\nFROM shellTest \r\nWHERE a = 10 and b &lt; 10 and c is not null \r\nGROUP BY c\r\n<\/pre>\n<p><span style=\"font-weight: 400;\">\ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uc758 \ucd9c\ub825\uc740 \uc544\ub798\uc640 \uac19\uc774 \ud45c\uc2dc\ub418\uba70, GROUP BY \ud45c\ud604\uc2dd \"c\"\ub294 \ub3d9\uc77c\uc131 \uc220\uc5b4\uc5d0\uc11c \uc624\ub294 \uc778\ub371\uc2a4 \ud0a4 \"a\"\uc758 \ubc14\ub85c \ub4a4\uc5d0 \uc624\ub3c4\ub85d \uc870\uc815\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<pre class=\"lang:default decode:true\">\"covering_indexes\": [\r\n            \t{\r\n              \t\"index_property\": \"FULL GROUPBY &amp; AGGREGATES pushdown, GROUPBY &amp; AGGREGATES pushdown\",\r\n              \t\"index_statement\": \"CREATE INDEX adv_a_c_b_d ON `shellTest`(`a`,`c`,`b`,`d`)\",\r\n              \t\"keyspace_alias\": \"shellTest\"\r\n            \t}\r\n]\r\n<\/pre>\n<p>\uc608 2:<\/p>\n<pre class=\"lang:default decode:true\">ADVISE SELECT c11 \r\nFROM shellTest \r\nWHERE test_id = \\\"advise\\\" \r\nORDER BY c11 DESC \r\nLIMIT 2\r\n<\/pre>\n<p><span style=\"font-weight: 400;\">\uc774 \ucd9c\ub825\uc5d0\uc11c \"c11\"\uc740 ORDER BY \ud478\uc2dc\ub2e4\uc6b4\uc5d0 \uc801\ud569\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc774 \uc778\ub371\uc2a4 \ud0a4\uc5d0 \"DESC\"\uac00 \ucd94\uac00\ub429\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"lang:default decode:true\">\"covering_indexes\": [\r\n            \t{\r\n              \t\"index_property\": \"ORDER pushdown, LIMIT pushdown\",\r\n              \t\"index_statement\": \"CREATE INDEX adv_test_id_c11DESC ON `shellTest`(`test_id`,`c11` DESC)\",\r\n              \t\"keyspace_alias\": \"shellTest\"\r\n            \t}\r\n]<\/pre>\n<p>\uc608 3:<\/p>\n<pre class=\"lang:default decode:true\">ADVISE SELECT avg(c), sum(DISTINCT d) \r\nFROM shellTest \r\nWHERE a = 10 and b &lt; 10 \r\nGROUP BY b\r\n<\/pre>\n<p><span style=\"font-weight: 400;\">\uc774 \uc608\uc81c\uc5d0\uc11c\ub294 'd'\uc5d0 DISTINCT \uc9d1\uacc4\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">DISTINCT \uc9d1\uacc4\ub294 (n+1) \uc120\ud589 \ud0a4\uc5d0 DISTINCT \uc9d1\uacc4 \ud45c\ud604\uc2dd\uc774 \uc788\ub294 \uc804\uccb4 \ud478\uc2dc\ub2e4\uc6b4\uc5d0\ub9cc \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\"a\"\ub294 \ub3d9\uc77c\uc131 \uc220\uc5b4\uc5d0\uc11c \ube44\ub86f\ub418\uba70 \uac74\ub108\ub701\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\"b\"\ub294 GROUP BY \ud45c\ud604\uc2dd\uc73c\ub85c \uc774\uc5b4\uc9d1\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\uc220\uc5b4 \ubc0f GROUP BY\uc758 \uc778\ub371\uc2a4 \ud0a4\ub294 \uc804\uccb4 \ud478\uc2dc\ub2e4\uc6b4\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\"d\"\ub294 DISTINCT \uc9d1\uacc4\uc5d0\uc11c\uc640 \uac19\uc774 GROUP BY \ud45c\ud604\uc2dd \"b\" \ub4a4\uc5d0 \uc624\uace0 \"c\" \uc55e\uc5d0 \uc624\uac8c \ub429\ub2c8\ub2e4.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\ucd9c\ub825 \uacb0\uacfc\uc785\ub2c8\ub2e4:<\/span><\/p>\n<pre class=\"lang:default decode:true\">\"covering_indexes\": [\r\n            \t{\r\n              \t\"index_property\": \"FULL GROUPBY &amp; AGGREGATES pushdown, GROUPBY &amp; AGGREGATES pushdown\",\r\n              \t\"index_statement\": \"CREATE INDEX adv_a_b_d_c ON `shellTest`(`a`,`b`,`d`,`c`)\",\r\n              \t\"keyspace_alias\": \"shellTest\"\r\n  \t          }\r\n]\r\n<\/pre>\n<h4><\/h4>\n<h4><\/h4>\n<p>&nbsp;<\/p>\n<h4>\uc694\uc57d<\/h4>\n<p>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \ub354 \ub098\uc740 \ucffc\ub9ac \uc131\ub2a5\uc744 \uc704\ud574 \ucd94\ucc9c \uc778\ub371\uc2a4\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud574 \ucd5c\uc120\uc744 \ub2e4\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uac80\uc99d \ud504\ub808\uc784\uc6cc\ud06c\ub294 \uc815\ud655\uc131\uacfc \uacac\uace0\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uace0, \uc778\ub371\uc2a4 \ud478\uc2dc\ub2e4\uc6b4\uc744 \uc9c0\uc6d0\ud558\uc5ec \ucffc\ub9ac \uc131\ub2a5\uc744 \ub354\uc6b1 \uac1c\uc120\ud569\ub2c8\ub2e4.<\/p>","protected":false},"excerpt":{"rendered":"<p>Index advisor for N1QL Statement (ADVISE statement ) is officially released in Couchbase Server 6.6. It is designed to make best efforts to provide global secondary index recommendation for each keyspace in the query which is better than all the [&hellip;]<\/p>","protected":false},"author":17714,"featured_media":10423,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[8905,1816,1812],"tags":[2439,1696],"ppma_author":[9088],"class_list":["post-9221","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-global-secondary-index","category-couchbase-server","category-n1ql-query","tag-index-advisor","tag-indexing"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.8 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Index Advisor Supports Self-Verification and Index Pushdowns - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"N1QL&#039;s ADVISE statement, released in Couchbase 6.6, provides Global Secondary Index (GSI) usage recommendations for each keyspace in your query.\" \/>\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-to-support-self-verification-and-index-pushdowns\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Index Advisor Supports Self-Verification and Index Pushdowns\" \/>\n<meta property=\"og:description\" content=\"N1QL&#039;s ADVISE statement, released in Couchbase 6.6, provides Global Secondary Index (GSI) usage recommendations for each keyspace in your query.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-to-support-self-verification-and-index-pushdowns\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-20T02:53:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:32:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Index-Advisor-to-Support-Self-Verification-and-Index-Pushdowns.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"627\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chang Liu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chang Liu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/\"},\"author\":{\"name\":\"Chang Liu\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c43360951567e4b3bef754197f5e866b\"},\"headline\":\"Index Advisor Supports Self-Verification and Index Pushdowns\",\"datePublished\":\"2021-01-20T02:53:02+00:00\",\"dateModified\":\"2025-06-14T00:32:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/\"},\"wordCount\":1231,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/webui-data-import-1.jpg\",\"keywords\":[\"Index Advisor\",\"Indexing\"],\"articleSection\":[\"Couchbase Global Secondary Index\",\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/\",\"name\":\"Index Advisor Supports Self-Verification and Index Pushdowns - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/webui-data-import-1.jpg\",\"datePublished\":\"2021-01-20T02:53:02+00:00\",\"dateModified\":\"2025-06-14T00:32:24+00:00\",\"description\":\"N1QL's ADVISE statement, released in Couchbase 6.6, provides Global Secondary Index (GSI) usage recommendations for each keyspace in your query.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/webui-data-import-1.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/webui-data-import-1.jpg\",\"width\":1590,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Index Advisor Supports Self-Verification and Index Pushdowns\"}]},{\"@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\/c43360951567e4b3bef754197f5e866b\",\"name\":\"Chang Liu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/2eede623c7ed061e0426183cb9cac122\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d73d8b19010a13d5e2567a4051ea99cf60a37f9ff39d8197255739d72a030b3b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d73d8b19010a13d5e2567a4051ea99cf60a37f9ff39d8197255739d72a030b3b?s=96&d=mm&r=g\",\"caption\":\"Chang Liu\"},\"description\":\"Software Engineer in N1QL Query Team\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/chang-liucouchbase-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Index Advisor Supports Self-Verification and Index Pushdowns - The Couchbase Blog","description":"N1QL's ADVISE statement, released in Couchbase 6.6, provides Global Secondary Index (GSI) usage recommendations for each keyspace in your query.","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-to-support-self-verification-and-index-pushdowns\/","og_locale":"ko_KR","og_type":"article","og_title":"Index Advisor Supports Self-Verification and Index Pushdowns","og_description":"N1QL's ADVISE statement, released in Couchbase 6.6, provides Global Secondary Index (GSI) usage recommendations for each keyspace in your query.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/index-advisor-to-support-self-verification-and-index-pushdowns\/","og_site_name":"The Couchbase Blog","article_published_time":"2021-01-20T02:53:02+00:00","article_modified_time":"2025-06-14T00:32:24+00:00","og_image":[{"width":1200,"height":627,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Index-Advisor-to-Support-Self-Verification-and-Index-Pushdowns.png","type":"image\/png"}],"author":"Chang Liu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chang Liu","Est. reading time":"7\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/"},"author":{"name":"Chang Liu","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c43360951567e4b3bef754197f5e866b"},"headline":"Index Advisor Supports Self-Verification and Index Pushdowns","datePublished":"2021-01-20T02:53:02+00:00","dateModified":"2025-06-14T00:32:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/"},"wordCount":1231,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/webui-data-import-1.jpg","keywords":["Index Advisor","Indexing"],"articleSection":["Couchbase Global Secondary Index","Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/","url":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/","name":"Index Advisor Supports Self-Verification and Index Pushdowns - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/webui-data-import-1.jpg","datePublished":"2021-01-20T02:53:02+00:00","dateModified":"2025-06-14T00:32:24+00:00","description":"N1QL's ADVISE statement, released in Couchbase 6.6, provides Global Secondary Index (GSI) usage recommendations for each keyspace in your query.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/webui-data-import-1.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/webui-data-import-1.jpg","width":1590,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/index-advisor-to-support-self-verification-and-index-pushdowns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Index Advisor Supports Self-Verification and Index Pushdowns"}]},{"@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\/c43360951567e4b3bef754197f5e866b","name":"\ucc3d \ub9ac\uc6b0","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/2eede623c7ed061e0426183cb9cac122","url":"https:\/\/secure.gravatar.com\/avatar\/d73d8b19010a13d5e2567a4051ea99cf60a37f9ff39d8197255739d72a030b3b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d73d8b19010a13d5e2567a4051ea99cf60a37f9ff39d8197255739d72a030b3b?s=96&d=mm&r=g","caption":"Chang Liu"},"description":"N1QL \ucffc\ub9ac \ud300\uc758 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/chang-liucouchbase-com\/"}]}},"authors":[{"term_id":9088,"user_id":17714,"is_guest":0,"slug":"chang-liucouchbase-com","display_name":"Chang Liu","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/d73d8b19010a13d5e2567a4051ea99cf60a37f9ff39d8197255739d72a030b3b?s=96&d=mm&r=g","author_category":"","last_name":"Liu","first_name":"Chang","job_title":"","user_url":"","description":"N1QL \ucffc\ub9ac \ud300\uc758 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4"}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/9221","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\/17714"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=9221"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/9221\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/10423"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=9221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=9221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=9221"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=9221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}