{"id":9025,"date":"2020-08-12T09:00:13","date_gmt":"2020-08-12T16:00:13","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=9025"},"modified":"2025-06-13T20:27:37","modified_gmt":"2025-06-14T03:27:37","slug":"announcing-flex-index-with-couchbase","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/announcing-flex-index-with-couchbase\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc640 \ud568\uaed8 \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4 \ubc1c\ud45c"},"content":{"rendered":"

\ud50c\ub809\uc2a4 \uc778\ub371\uc2a4 \uc124\uba85<\/span><\/h2>\n

\ud50c\ub809\uc2a4 \uc778\ub371\uc2a4\ub780 \ubb34\uc5c7\uc778\uac00\uc694? \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc758 \ud575\uc2ec \uc791\uc5c5 \uc911 \ud558\ub098\ub294 \uadf8 \uc548\uc5d0 \uc788\ub294 \ub370\uc774\ud130\uc758 \uac80\uc0c9\uacfc \uac80\uc0c9\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ub9ac\uc18c\uc2a4 \uc18c\ube44\uc640 \uc131\ub2a5 \uc0ac\uc774\uc758 \ud6a8\uc728\uc131\uacfc \uade0\ud615\uc740 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uac00\uc7a5 \uc911\uc694\ud55c \uce21\uba74\uc785\ub2c8\ub2e4. B-Tree, \ubc18\uc804, \uadf8\ub798\ud504, \uacf5\uac04 \ub4f1 \ub2e4\uc591\ud55c \uc720\ud615\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4\ub294 \uc11c\ub85c \ub2e4\ub978 \uac80\uc0c9 \uc694\uad6c \uc0ac\ud56d\uc744 \ucda9\uc871\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \uac80\uc0c9 \uc131\ub2a5\uc5d0 \ud544\uc218\uc801\uc774\uc9c0\ub9cc, \uc0ac\uc6a9\ud560 \uc801\uc808\ud55c \uc778\ub371\uc2a4 \uc720\ud615\uc744 \uc120\ud0dd\ud558\ub294 \uac83 \ub610\ud55c \uadf8 \ud6a8\uacfc\uc5d0 \ud070 \ucc28\uc774\ub97c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2f1\ub418\ub294 \ub370\uc774\ud130 \uc694\uc18c\uc758 \ud2b9\uc131\uc5d0 \ub530\ub77c \ucd5c\uc801\uc758 \uc778\ub371\uc2a4 \uc720\ud615\uc774 \uacb0\uc815\ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n

\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc5d0\uc11c \uae00\ub85c\ubc8c \ubcf4\uc870 \uc0c9\uc778\uc740 B-Tree \uad6c\uc870\ub97c \uc0ac\uc6a9\ud574 \ube60\ub978 \uc815\ud655\ub3c4 \ubc0f \ubc94\uc704 \uac80\uc0c9\uc744 \uc81c\uacf5\ud558\uace0, \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc740 \ubc18\uc804\ub41c \uc0c9\uc778 \uad6c\uc870\ub97c \uc0ac\uc6a9\ud574 \ud6a8\uc728\uc801\uc778 \uc6a9\uc5b4 \uac80\uc0c9\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uac01 \uc720\ud615\uc758 \uc778\ub371\uc2a4\ub294 \ud655\uc7a5\uc131\uc774 \ub6f0\uc5b4\ub0a0 \ubfd0\ub9cc \uc544\ub2c8\ub77c \uace0\uc720\ud55c \uae30\ub2a5\ub3c4 \uc81c\uacf5\ud569\ub2c8\ub2e4. B-Tree\ub294 \uc120\ud0dd\ub3c4\uac00 \ub192\uc740 \uac12(\uc608: \uc8fc\ubb38 \ubc88\ud638 \ub4f1 \ubcf4\ub2e4 \ub69c\ub837\ud55c)\uc5d0 \uac00\uc7a5 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \uc778\ub371\uc2a4\uc774\uba70, \ubc18\uc804 \uc778\ub371\uc2a4\ub294 \uac80\uc0c9 \uac00\ub2a5\ud55c \uc6a9\uc5b4\uc758 \uc120\ud0dd\ub3c4\uac00 \ub0ae\uc744 \uac00\ub2a5\uc131\uc774 \uc788\ub294 \ud14d\uc2a4\ud2b8 \ucf58\ud150\uce20\ub97c \uc0c9\uc778\ud558\ub294 \ub370 \uac00\uc7a5 \uc798 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.\u00a0<\/span><\/p>\n

\uc0ac\uc6a9\uc790\uc640 \uc9c1\uc811 \uc778\ud130\ud398\uc774\uc2a4\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\ub294 \uac80\uc0c9 \uae30\ub2a5\uc774 \ud544\uc694\ud558\uba70, \uc774\ub7ec\ud55c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\ub294 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc815\ud655\ud55c \uac80\uc0c9\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uac80\uc0c9 \uae30\ub2a5\uc740 \uc5ec\ub7ec \uac80\uc0c9 \uc11c\ube44\uc2a4\ub098 \ubcc4\ub3c4\uc758 \uac80\uc0c9 API\ub97c \ud1b5\ud574 \uc81c\uacf5\ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\uae30 \ub54c\ubb38\uc5d0 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c\uc758 \ubcf5\uc7a1\uc131\uc774 \ub192\uc544\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\uc774\ub7ec\ud55c \uc694\uad6c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 Couchbase\ub294 v6.5\uc5d0 N1QL SEARCH() \ud568\uc218\ub97c \ub3c4\uc785\ud588\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74 N1QL \ucffc\ub9ac\uc5d0\uc11c \uac80\uc0c9\uc5b4\ubfd0\ub9cc \uc544\ub2c8\ub77c \uad00\ub828\uc131 \uc810\uc218\ub85c\ub3c4 \uacb0\uacfc\uac00 \uc608\uce21\ub418\ub294 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc5d0 \uac80\uc0c9()\uacfc \uc77c\uce58 \ubc0f \ubc94\uc704 \uac80\uc0c9\uc5d0 SQL \uc220\uc5b4\ub97c \ubaa8\ub450 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \uac80\uc0c9\uc5d0 \ud37c\uc9c0 \uc694\uc18c\uac00 \ucd94\uac00\ub418\uace0 \uc5b8\uc5b4 \uc778\uc2dd \uae30\ub2a5\ub3c4 \ucd94\uac00\ub429\ub2c8\ub2e4.<\/span><\/p>\n

N1QL SEARCH() \uae30\ub2a5\uc744 \ud1b5\ud574 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \ucc98\uc74c\uc73c\ub85c Couchbase N1QL \uc5b8\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2e8\uc77c API\uc5d0\uc11c \ub450 \ucffc\ub9ac \uac80\uc0c9 \uc11c\ube44\uc2a4\uc5d0 \ubaa8\ub450 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ud1b5\ud569\uc740 \ub9ce\uc740 \uc774\uc810\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uadf8\uc911\uc5d0\uc11c\ub3c4 \uac00\uc7a5 \uc911\uc694\ud55c \uac83\uc740 \uc11c\ub85c \ub2e4\ub978 API\ub97c \ucc98\ub9ac\ud560 \ud544\uc694\uac00 \uc5c6\uace0 \ub354 \ub9ce\uc740 \uac80\uc0c9 \ucc98\ub9ac\ub97c \ubc31\uc5d4\ub4dc \uc11c\ube44\uc2a4\uc5d0 \uc704\uc784\ud560 \uc218 \uc788\uc5b4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c \ud504\ub85c\uc138\uc2a4\uac00 \uac04\uc18c\ud654\ub41c\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n

Couchbase 6.6\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 N1QL\/FTS \ud1b5\ud569\uc744 \ud55c \ub2e8\uacc4 \ub354 \ubc1c\uc804\uc2dc\ucf30\uc2b5\ub2c8\ub2e4.<\/span> \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4<\/b>.<\/span><\/p>\n

\ud50c\ub809\uc2a4 \uc778\ub371\uc2a4\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/span><\/h2>\n

\ud50c\ub809\uc2a4 \uc778\ub371\uc2a4\ub294 \ud45c\uc900 N1QL \uc220\uc5b4\ub9cc\uc744 \uc0ac\uc6a9\ud558\uc5ec Couchbase \ucffc\ub9ac \uc11c\ube44\uc2a4\uc5d0\uc11c \uac80\uc0c9 \uae30\ub2a5\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. \uc989, N1QL \ucffc\ub9ac\uc5d0\uc11c FTS \uc778\ub371\uc2a4\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574 FTS \uad6c\ubb38\uc774\ub098 SEARCH() \ud568\uc218\ub97c \uc0ac\uc6a9\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/p>\n

\uac80\uc0c9 \ub370\uc774\ud130 \uc720\ud615 \uc9c0\uc6d0\uc5d0\ub294 \ud14d\uc2a4\ud2b8, \ub0a0\uc9dc\/\uc2dc\uac04, \uc22b\uc790, \ubd80\uc6b8\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud14d\uc2a4\ud2b8\uc758 \uacbd\uc6b0 \ud0a4\uc6cc\ub4dc \uac80\uc0c9\ub9cc \uc9c0\uc6d0\ub429\ub2c8\ub2e4.<\/p>\n

\ud0a4\uc6cc\ub4dc \uac80\uc0c9 -<\/b> \ub294 \uc778\ub371\uc2a4\uc5d0 \ucd94\uac00\ud558\uae30 \uc804\uc5d0 \ud14d\uc2a4\ud2b8 \ud544\ub4dc\uac00 \ucc98\ub9ac\ub418\ub294 \ubc29\uc2dd\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. FTS \uc778\ub371\uc2a4\uc5d0\uc11c \ud45c\uc900<\/code> \ubd84\uc11d\uae30\ub294 \uc0c9\uc778\ud654\ud558\uae30 \uc804\uc5d0 \ud14d\uc2a4\ud2b8\ub97c \uac1c\ubcc4 \uc6a9\uc5b4\ub85c \uad6c\ubb38 \ubd84\uc11d\ud558\ub294 \ubc18\uba74\uc5d0 \ud0a4\uc6cc\ub4dc<\/code> \ubd84\uc11d\uae30\ub294 \uc778\ub371\uc2a4\uc5d0 \uc804\uccb4 \ud14d\uc2a4\ud2b8\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\ud50c\ub809\uc2a4 \uc778\ub371\uc2a4\uc758 \uc791\ub3d9 \ubc29\uc2dd\uc744 \uc774\ud574\ud558\uae30 \uc704\ud574 \uc774 \uac80\uc0c9 \uc870\uac74\uc758 \ucffc\ub9ac\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4: \uc601\uc5c5 \ud65c\ub3d9 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uace0\uac1d\uc778 'Horizon Communications'\uc640 \uad00\ub828\ub41c \ubaa8\ub4e0 \ud65c\ub3d9\uc744 \ucc3e\uace0\uc790 \ud558\uba70, 2020\ub144 8\uc6d4\uc5d0 \ubc1c\uc0dd\ud588\uace0 \ubaa8\uc2a4\ucf58 \uc13c\ud130\uc5d0\uc11c \uc5f4\ub9b0 \ub9c8\ucf00\ud305 \uc774\ubca4\ud2b8 \uc911\uc5d0 \uc774\ub8e8\uc5b4\uc84c\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/p>\n

SELECT * FROM crm\u00a0\r\n\u00a0 WHERE type='activity'\r\n\u00a0 \u00a0 AND event.location = 'Moscone Center'\r\n\u00a0 \u00a0 AND account.name = 'Horizon Communications'\r\n\u00a0 \u00a0 AND act_date BETWEEN '2020-08-01' AND '2020-08-31'<\/pre>\n
\ub610\ud55c \uc774 GSI \uc778\ub371\uc2a4\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4:\u00a0<\/span><\/p>\n
CREATE INDEX adv_account_name_event_site_actdate\r\nON `crm`(`account`.`name`,`event`.`location`,`act_date`)\r\n\u00a0 \u00a0 WHERE type='activity'<\/pre>\n
\uc774 \ucffc\ub9ac\ub294 \uc791\uc131\ub41c \ub300\ub85c \uc704\uc758 GSI \uc9c0\uc218\ub97c \ud65c\uc6a9\ud569\ub2c8\ub2e4:<\/p>\n
    \n
  1. \ubaa8\ub4e0 \ucffc\ub9ac \uc220\uc5b4\ub294 \uc778\ub371\uc2a4\uc5d0 \ud3ec\ud568\ub429\ub2c8\ub2e4.\u00a0<\/span><\/li>\n
  2. \ucffc\ub9ac\uc5d0\ub294 \uc220\uc5b4 \uc720\ud615<\/code>\uc778\ub371\uc2a4\uc758 \ud544\ud130\uc640 \uc77c\uce58\ud558\ub294 ='\ud65c\ub3d9'\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4.\u00a0<\/span><\/li>\n
  3. In fact, the index will be considered as long as the leading key `account`.`name` is one of the predicates, and that the query is restricted to \uc720\ud615<\/code>='\ud65c\ub3d9'.<\/span><\/li>\n<\/ol>\n
    \ucffc\ub9ac \uacc4\ud68d:<\/h5>\n
    \"\"<\/p>\n
    \ud568\uaed8<\/span> \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4<\/b>\ub97c \ud074\ub9ad\ud558\uba74 \uc774\uc81c \ucffc\ub9ac \uc11c\ube44\uc2a4\uc5d0 \ucffc\ub9ac\uc5d0 FTS \uc778\ub371\uc2a4 \uc0ac\uc6a9\uc744 \uace0\ub824\ud558\ub3c4\ub85d \uc694\uccad\ud560 \uc218 \uc788\ub294 \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/p>\n
    SELECT * FROM crm  USE INDEX (USING FTS)\r\n   WHERE type='activity'\r\n     AND event.site = 'Moscone Center'\r\n     AND account.name = 'Horizon Communications' \r\n     AND act_date BETWEEN '2020-08-01' AND '2020-08-31'<\/pre>\n
    \"<\/span>\uc778\ub371\uc2a4 \uc0ac\uc6a9(FTS \uc0ac\uc6a9)<\/b>\" \ud78c\ud2b8\ub294 \ucffc\ub9ac\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub294 FTS \uc778\ub371\uc2a4\uac00 \uc788\ub294 \uacbd\uc6b0 \uc774\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \ucffc\ub9ac \uc11c\ube44\uc2a4\uc5d0 \uc81c\uc548\ud569\ub2c8\ub2e4.\u00a0\u00a0<\/span><\/p>\n
    \uadf8\ub9ac\uace0 \uc544\ub798\uc640 \uac19\uc774 \uc815\uc758\ub41c FTS \uc778\ub371\uc2a4\uac00 \uc788\ub294 \uacbd\uc6b0:<\/span><\/p>\n
    \"\"<\/p>\n
    The `a<\/span>ct_search`<\/span>\u00a0\uc778\ub371\uc2a4\uc758 \uc815\uc758\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n
      \n
    1. It has a `type` mapping that restricts the index content to include only the documents of \uc720\ud615<\/code> = '\ud65c\ub3d9'.<\/span><\/li>\n
    2. \uc5ec\uae30\uc5d0\ub294 \ud558\uc704 \ud544\ub4dc\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4. act_date<\/code>.<\/span><\/li>\n
    3. \uc5ec\uae30\uc5d0\ub294 \ub2e4\uc74c\uc5d0 \ub300\ud55c \ub450 \uac00\uc9c0 \ud558\uc704 \ub9e4\ud551\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. \uacc4\uc815<\/code> \uadf8\ub9ac\uace0 \uc774\ubca4\ud2b8<\/code> \uac1d\uccb4\uc785\ub2c8\ub2e4.<\/span><\/li>\n
    4. \uc774 \uae30\ub2a5\uc740 \ud0a4\uc6cc\ub4dc<\/code> \ubd84\uc11d\uae30.<\/span><\/li>\n<\/ol>\n
      \uc774 \uacbd\uc6b0 <\/span>`act_search` <\/span>\ub294 \uc704\uc758 N1QL \ucffc\ub9ac\uc5d0 \uc644\ubcbd\ud558\uac8c \uc801\ud569\ud558\uba70, \uc704\uc640 \uac19\uc774<\/span> \uc778\ub371\uc2a4 \uc0ac\uc6a9(FTS \uc0ac\uc6a9)<\/b> \ud78c\ud2b8\ub97c \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac\uc5d0\uc11c <\/span>`act_search`<\/span> FTS \uc9c0\uc218.<\/span><\/p>\n
      \ucffc\ub9ac \uacc4\ud68d:<\/span><\/p>\n
      \"\"<\/p>\n
      \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4<\/strong> \ub294 \ud45c\uc900 N1QL \uc220\uc5b4 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\ub294 N1QL \ucffc\ub9ac\uac00 GSI \ub610\ub294 FTS \uc778\ub371\uc2a4\ub97c \ud22c\uba85\ud558\uac8c \ud65c\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. <\/span>N1QL \ubb38\uc744 \uc218\uc815\ud558\uc9c0 \uc54a\uace0\ub3c4<\/i><\/b>.\u00a0<\/span><\/p>\n
      \ud558\uc9c0\ub9cc \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4\uc758 \uac00\uce58\ub294 FTS\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c \ub354 \uac04\ub2e8\ud55c \uad6c\ubb38\ubfd0\ub9cc \uc544\ub2c8\ub77c \ub2e4\uc74c \uc139\uc158\uc5d0\uc11c \uc124\uba85\ud560 FTS \uc778\ub371\uc2a4\uc758 \ub2e4\uc591\ud55c \uae30\ub2a5\uc5d0\uc11c\ub3c4 \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
      \uadf8\ub807\ub2e4\uba74 \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4\ub294 \uc5b8\uc81c \uc0ac\uc6a9\ud574\uc57c \ud560\uae4c\uc694?<\/span><\/h2>\n
      \ub192\uc740 \uc218\uc900\uc5d0\uc11c, \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4<\/strong> \ub294 \uac80\uc0c9\uc744 \uc81c\uacf5\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \ud754\ud788 \ubcfc \uc218 \uc788\ub294 \ub9ce\uc740 \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
        \n
      1. N1QL \ubb38\uc758 \uac80\uc0c9 \uc870\uac74\uc774 \ubbf8\ub9ac \uc815\ud574\uc838 \uc788\uc9c0 \uc54a\uc740 \uacbd\uc6b0, \uc989 \uc0ac\uc6a9\uc790\uc758 \uc120\ud0dd\uc5d0 \ub530\ub77c \ub2e4\uc591\ud55c \uc218\uc758 \uc220\uc5b4\uac00 \ud3ec\ud568\ub420 \uc218 \uc788\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubaa8\ub4e0 \uac80\uc0c9 \uc870\uac74\uc744 \ud3ec\uad04\ud558\ub294 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 \uac83\ub3c4 \uc5b4\ub835\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n
      2. \uac80\uc0c9 \uc870\uac74\uc5d0 AND\/OR \uc870\ud569\uacfc \uac19\uc740 \ub17c\ub9ac \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub9ce\uc740 \uc220\uc5b4\ub97c \ud3ec\ud568\ud558\ub294 \uac80\uc0c9 \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc785\ub2c8\ub2e4.<\/span><\/li>\n
      3. \uac80\uc0c9 \uc870\uac74\uc5d0 \ubc30\uc5f4 \ub610\ub294 \uc5ec\ub7ec \ubc30\uc5f4\uc758 \ubc30\uc5f4 \uc694\uc18c\ub97c \ud3ec\ud568\ud558\ub294 \uac80\uc0c9\uacfc \uac19\uc774 \uacc4\uce35\uc801 \ubb38\uc11c \uc694\uc18c\uc5d0 \ub300\ud55c \uc220\uc5b4\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/span><\/li>\n
      4. \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 FTS\uc758 \uac15\ub825\ud55c \uae30\ub2a5\uc774 \ud544\uc694\ud558\uc9c0\ub9cc \ub2e4\ub978 \uac1c\uccb4\uc758 \uad00\ub828 \uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uae30 \uc704\ud574 SQL \uc9d1\uacc4 \ubc0f JOIN\ub3c4 \ud544\uc694\ud55c \uacbd\uc6b0.<\/span><\/li>\n
      5. \ub610\ub294 \ub2e8\uc21c\ud788 FTS \uad6c\ubb38 \ub300\uc2e0 N1QL \uc220\uc5b4 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uace0 \uc2f6\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n
        Note that Flex Index can also be used retrospectively on existing applications by adding the `use_fts` parameter to the query API calls.\u00a0<\/em><\/strong><\/p>\n
        1) \uac80\uc0c9 \ud328\ud134\uc774 \ubbf8\ub9ac \uc815\ud574\uc838 \uc788\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/h3>\n
        \ucd5c\uc885 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uac80\uc0c9 \uae30\ub2a5\uc744 \uc81c\uacf5\ud560 \ub54c \ud56d\uc0c1 \uc5b4\ub824\uc6b4 \uc810\uc740 \uc0ac\uc6a9\uc790\uac00 \ubb34\uc5c7\uc744 \uac80\uc0c9\ud560 \uc218 \uc788\ub3c4\ub85d \ud5c8\uc6a9\ud560 \uac83\uc778\uac00 \ud558\ub294 \uc810\uc785\ub2c8\ub2e4. \ud45c\uc900 \uc9c0\uce68\uc5d0 \ub530\ub974\uba74 \uc0ac\uc6a9\uc790\uc758 \ud544\uc694\uc5d0 \ub530\ub77c \uacb0\uc815\ud558\ub3c4\ub85d \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uac80\uc0c9 \uac00\ub2a5\ud55c \ud544\ub4dc\uac00 \uba87 \uac00\uc9c0 \uc8fc\uc694 \ud544\ub4dc\uc5d0 \uad6d\ud55c\ub418\uc9c0 \uc54a\uace0 \uac1d\uccb4\uc758 \ubaa8\ub4e0 \ud544\ub4dc\ub97c \ud3ec\uad04\ud560 \uc218 \uc788\ub294 \ubcf5\uc7a1\ud55c \uc2dc\uc2a4\ud15c\uc5d0\uc11c\ub294 \uae30\ubcf8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc774 \uc9c0\uc6d0\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc5d0 \ub530\ub77c \uac80\uc0c9\uc5d0 \ub300\ud55c \uacb0\uc815\uc774 \ub0b4\ub824\uc9c0\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
        \ube60\ub978 \uc870\ud68c\ub97c \uc704\ud574 \uae30\uc874\uc758 B-Tree \uc778\ub371\uc2a4\ub97c \uae30\ubc18\uc73c\ub85c \ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \uc774\ub7ec\ud55c \uc720\ud615\uc758 \uac80\uc0c9 \uc694\uad6c \uc0ac\ud56d\uc744 \uc704\ud55c \uc720\uc5f0\ud55c \ud504\ub808\uc784\uc6cc\ud06c\ub97c \uc81c\uacf5\ud558\ub294 \ub370 \uc788\uc5b4 \ubd80\uc871\ud55c \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/p>\n
        \uc774 \ubb38\uc11c\ub97c \ucc38\uace0\ud558\uc138\uc694:<\/span><\/p>\n
        \"activity\" : {\r\n\u00a0 \"id\": \"act1000\",\r\n\u00a0 \"title\": \"Announcing Couchbase Flex Index CB6.6\",\r\n\u00a0 \"reference\": \"24-i2y5J3928\",\r\n\u00a0 \"dept\": \"st55\",\r\n\u00a0 \"region\": \"00528\",\r\n\u00a0 \"notes\": \"Review the 100 N1QL Flex Index queries that ElasticSQL cannot do. The important point here is that Couchbase has integrated Text Search capability into its N1QL. Whereas ElasticSearch, relatively new SQL, has added SQL to its search engine....\",\r\n\u00a0 \"owner\": {\r\n\u00a0 \u00a0 \"id\": \"usr24\",\r\n\u00a0 \u00a0 \"name\": \"John Higgins\"\r\n\u00a0 },\r\n\u00a0 \"priority\": \"Medium\",\r\n\u00a0 \"act_type\": \"Appointment\",\r\n\u00a0 \"event\": {\r\n\u00a0 \u00a0 \"name\": \"N1QL Flex Index vs. ElasticSQL\",\r\n\u00a0 \u00a0 \"location\": \"Moscone Center\",\r\n\u00a0 \u00a0 \"theme\": \"CouchbaseRed\",\r\n\u00a0 \u00a0 \"vendor\": \"Kempinski\"\r\n\u00a0 },\r\n\u00a0 \"account\": {\r\n\u00a0 \u00a0 \"id\": \"acc134\",\r\n\u00a0 \u00a0 \"name\": \"Horizon Communications\"\r\n\u00a0 },\r\n\u00a0 \"act_date\": \"2020-08-06\",\r\n\u00a0 \"appointment\": {\r\n\u00a0 \u00a0 \"duration\": 90,\r\n\u00a0 \u00a0 \"start_date\": \"2020-08-06 11:00:00\",\r\n\u00a0 \u00a0 \"contacts\": [\r\n\u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"id\": \"contact2493\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"title\": \"SalesRep\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"name\": \"Miranda Sullivan\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"email\": \"msullivan@horizoncell.com\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"phone\": \"778-096-1351\"\r\n\u00a0 \u00a0 \u00a0 }\r\n\u00a0 ],\r\n\u00a0 \"participants\": [\r\n\u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \"role\": \"Support Analyst\",\r\n\u00a0 \u00a0 \u00a0 \"userid\": \"usr57\",\r\n\u00a0 \u00a0 \u00a0 \"name\": \"Raven Peterson\"\r\n\u00a0 \u00a0 },\r\n\u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \"role\": \"Product Specialist\",\r\n\u00a0 \u00a0 \u00a0 \"userid\": \"usr24\",\r\n\u00a0 \u00a0 \u00a0 \"name\": \"John Higgins\"\r\n\u00a0 \u00a0 }\r\n\u00a0 ],\r\n\u00a0 \"type\": \"activity\"\r\n}<\/pre>\n
        \uac15\uc870 \ud45c\uc2dc\ub41c 13\uac1c\uc758 \ud544\ub4dc\ub294 \uc0ac\uc6a9\uc790\uac00 \uac80\uc0c9\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 \uac00\ub2a5\ud55c \ud544\ub4dc\uc785\ub2c8\ub2e4. \uadf8\ub807\ub2e4\uba74 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uac80\uc0c9 \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\ub824\uba74 \uc5b4\ub5a4 \uc0c9\uc778 \uc804\ub7b5\uc744 \uc0ac\uc6a9\ud574\uc57c \ud560\uae4c\uc694?<\/p>\n\n\n\n\n\n\n\n
        \uc778\ub371\uc2a4 \uc804\ub7b5<\/b><\/td>\n\uc7a5\uc810<\/b><\/td>\n\ub2e8\uc810<\/b><\/td>\n<\/tr>\n
        13\uac1c\uc758 \uac1c\ubcc4 \uc778\ub371\uc2a4 \uc0dd\uc131<\/span><\/td>\n1- \ub2e8\uc77c \ud544\ub4dc \uac80\uc0c9\uc5d0 \ud6a8\uc728\uc801\uc785\ub2c8\ub2e4.\u00a0<\/span><\/td>\n1-\uac80\uc0c9\uc5d0 \ub458 \uc774\uc0c1\uc758 \ud544\ub4dc\uac00 \uc788\ub294 \uacbd\uc6b0 \uc5ec\ub7ec \uc778\ub371\uc2a4\uac00 \uc0ac\uc6a9\ub418\ubbc0\ub85c \uad50\ucc28 \uc2a4\uce94\uc774 \ubc1c\uc0dd\ud558\uc5ec \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4.<\/span><\/p>\n
        2-\ub354 \ub9ce\uc740 \uac80\uc0c9 \ud544\ub4dc\uac00 \ud3ec\ud568\ub428\uc5d0 \ub530\ub77c \uc810\uc810 \ub354 \ube44\ud6a8\uc728\uc801\uc784<\/span><\/td>\n<\/tr>\n
        \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \uac80\uc0c9 \uc870\ud569\uc5d0 \ub300\ud55c \ubcf5\ud569 \uc0c9\uc778 \ub9cc\ub4e4\uae30<\/span><\/td>\n1- \ube60\ub978 \uc751\ub2f5 \uc2dc\uac04<\/span><\/td>\n1-\ud2b9\uc815 \uac80\uc0c9 \uc870\ud569\ub9cc \uc9c0\uc6d0\ub418\ubbc0\ub85c \uc720\uc5f0\uc131\uc774 \ub5a8\uc5b4\uc9d1\ub2c8\ub2e4.<\/span><\/p>\n
        2-App UI\ub294 \uc778\ub371\uc2a4 \uc120\ud589 \ud0a4\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/td>\n<\/tr>\n
        \ubaa8\ub4e0 \uac80\uc0c9 \uc870\ud569\uc5d0 \ub300\ud55c \ubcf5\ud569 \uc0c9\uc778 \uc0dd\uc131<\/span><\/td>\n1- \uac00\uc7a5 \ube60\ub978 \uc751\ub2f5 \uc2dc\uac04<\/span><\/td>\n1- \ucd1d \uc778\ub371\uc2a4 \uc218(13\uac1c!)\ub294 \ube44\uc2e4\uc6a9\uc801\uc785\ub2c8\ub2e4.<\/span><\/td>\n<\/tr>\n
        \uac80\uc0c9 \uc5d4\uc9c4 \ud65c\uc6a9 - ElasticSearch \ub610\ub294 Couchbase FTS<\/span><\/td>\n1- \ube60\ub978 \uc751\ub2f5 \uc2dc\uac04<\/span><\/p>\n
        2-\ub2e8\uc77c \uc778\ub371\uc2a4\ub9cc \ud544\uc694\ud569\ub2c8\ub2e4.<\/span><\/td>\n
        		1-\uac80\uc0c9 \uc5d4\uc9c4\uc744 \ud65c\uc6a9\ud558\ub824\uba74 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub2e4\uc2dc \uc791\uc131\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n
        2-\ub354 \ubcf5\uc7a1\ud55c \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ucf54\ub4dc<\/span><\/p>\n
        3-\uc720\uc9c0 \uad00\ub9ac \ube44\uc6a9<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \uc704\uc758 \uc635\uc158 \ubaa9\ub85d\uc5d0\uc11c \uac00\uc7a5 \uc720\uc5f0\ud55c \uac80\uc0c9 \uae30\ub2a5\uc744 \uc704\ud574\uc11c\ub294 ElasticSearch \ub610\ub294 Couchbase FTS\uc640 \uc720\uc0ac\ud55c \uac80\uc0c9 \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4\ub294 \uac83\uc740 \ubd84\uba85\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774\ub7ec\ud55c \uac80\uc0c9 \uc5d4\uc9c4\uc744 \ud2b9\ubcc4\ud788 \uc5fc\ub450\uc5d0 \ub450\uace0 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud558\uc9c0 \uc54a\ub294 \ud55c, \uac80\uc0c9 \uad6c\ubb38\uc744 \ubcc0\ud658\ud558\uace0 API\ub97c \ubcc0\uacbd\ud558\ub294 \ub178\ub825\uc740 \uc0ac\uc18c\ud558\uc9c0 \uc54a\uc744 \uac83\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n
        \ubc14\ub85c \uc774 \uc9c0\uc810\uc5d0\uc11c Couchbase Flex Index\uc758 \uac00\uce58\uac00 \ube5b\uc744 \ubc1c\ud569\ub2c8\ub2e4.  \uc774 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc744 \ud1b5\ud574 \uac1c\ubc1c\uc790\ub294 \ud45c\uc900 N1QL \uc220\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec N1QL \ucffc\ub9ac \ubb38\uc744 \uc791\uc131\ud560 \uc218 \uc788\uc73c\uba70, \ucffc\ub9ac \uc11c\ube44\uc2a4\ub294 FTS \uc778\ub371\uc2a4\ub97c \ud22c\uba85\ud558\uac8c \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
        2) \ubaa8\ub4e0 \uc220\uc5b4 \uc870\ud569\uc73c\ub85c \ucffc\ub9ac\ud558\uae30<\/span><\/h3>\n
        GSI B-Tree\uc640 FTS \ud14d\uc2a4\ud2b8 \uc778\ub371\uc2a4\uc758 \uc8fc\uc694 \ucc28\uc774\uc810 \uc911 \ud558\ub098\ub294 \ud0a4 \ud544\ub4dc\uac00 \uad6c\ucd95\ub418\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4. GSI B-Tree \uc778\ub371\uc2a4\ub294 \uc778\ub371\uc2a4\uc758 \ubaa8\ub4e0 \ud0a4 \ud544\ub4dc\ub97c \ud568\uaed8 \uc5f0\uacb0\ud558\uc5ec \ub178\ub4dc \ud0a4\ub97c \uad6c\uc131\ud558\uae30 \ub54c\ubb38\uc5d0 \uc778\ub371\uc2a4\ub97c \uace0\ub824\ud558\uae30 \uc804\uc5d0 \ucffc\ub9ac\uc5d0 \uc120\ud589 \ud0a4\uac00 \uc788\uc5b4\uc57c\ub9cc \ud558\ub294 \uc8fc\ub41c \uc774\uc720\uac00 \ub429\ub2c8\ub2e4. \ubc18\uba74\uc5d0 FTS \uc778\ub371\uc2a4\ub294 \uac01 \ud544\ub4dc\uc5d0 \ub300\ud574 \ubcc4\ub3c4\uc758 \ubc18\uc804\ub41c \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc774 \uc124\uacc4\ub97c \uc0ac\uc6a9\ud558\uba74 \uc778\ub371\uc2f1\ub41c \ud544\ub4dc \uc911 \ud558\ub098 \uc774\uc0c1\uc774 \uc788\ub294 \ubaa8\ub4e0 \ucffc\ub9ac\uc5d0 \ub300\ud574 FTS \uc778\ub371\uc2a4\ub97c \uace0\ub824\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/p>\n
        Consider the following query which has 13 different predicates, as well as the `type`=’activity predicate.\u00a0<\/span><\/p>\n
         <\/p>\n
        SELECT * FROM crm a\r\nWHERE a.type='activity'\r\n\/* 1\u00a0 *\/ AND a.title LIKE 'Announcing Couchbase Flex Index%'\r\n\/* 2\u00a0 *\/ AND a.dept = 'st55'\r\n\/* 3\u00a0 *\/ AND a.region = '00528'\r\n\/* 4\u00a0 *\/ AND a.priority = 'High'\r\n\/* 5\u00a0 *\/ AND a.act_date BETWEEN '2020-08-01' AND '2020-08-31'\r\n\/* 6\u00a0 *\/ AND a.event.location = 'Moscone Center South'\r\n\/* 7\u00a0 *\/ AND a.event.name = 'N1QL Flex Index vs ElasticSQL'\r\n\/* 8\u00a0 *\/ AND a.event.vendor = 'Kempskinki'\r\n\/* 9\u00a0 *\/ AND a.event.theme = 'CouchbaseRed'\r\n\/* 10 *\/ AND a.account.id = 'acc134'\r\n\/* 11 *\/ AND a.account.name = 'Horizon Communications'\r\n\/* 12 *\/ AND a.owner.id = 'usr24'\r\n\/* 13 *\/ AND a.owner.name = 'John Higgins'<\/pre>\n
        \ucd5c\uc0c1\uc758 \uc131\ub2a5\uc744 \uc5bb\uc73c\ub824\uba74 \ucffc\ub9ac\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4\uac00 \uc788\uc5b4\uc57c \ud558\uba70, \uac00\uc7a5 \uc88b\uc740 \uc778\ub371\uc2a4\ub294 ADVISE\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\uc785\ub2c8\ub2e4:<\/span><\/p>\n
        CREATE INDEX adv_idx13 ON crm`\r\n(`account`.`name`,`event`.`vendor`,`account`.`id`,`event`.`location`,\r\n `event`.`theme`,`priority`,`owner`.`name`,`dept`,`event`.`name`,\r\n `owner`.`id`,`region`,`act_date`,`title`) \r\nWHERE `type` = 'activity'\r\n<\/pre>\n
        \ucffc\ub9ac \uacc4\ud68d:<\/span><\/h5>\n
        \"\"<\/p>\n
        \ud558\uc9c0\ub9cc \ub9cc\uc57d \uadf8\ub807\ub2e4\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694?<\/span><\/h5>\n
          \n
        1. The query does not have the leading key `account`.`name`?<\/span><\/li>\n
        2. \ucffc\ub9ac\uc5d0 13\uac1c\uc758 \uc220\uc5b4\uac00 \ub2e4\uc591\ud558\uac8c \uc870\ud569\ub418\uc5b4 \uc788\ub098\uc694?<\/span><\/li>\n<\/ol>\n
          GSI\ub294 \uc815\ud655\ud55c \ucffc\ub9ac \uc220\uc5b4\ub97c \uc54c \uc218 \uc788\ub294 \uac00\uc7a5 \uc88b\uc740 \uc778\ub371\uc2a4\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc870\uac74\uc5b4 \uc9d1\ud569\uc744 \ubbf8\ub9ac \uacb0\uc815\ud560 \uc218 \uc5c6\ub294 \uc560\ub4dc\ud639 \ucffc\ub9ac\ub97c \uc9c0\uc6d0\ud574\uc57c \ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uacbd\uc6b0 FTS \uc0ac\uc6a9\uc744 \uace0\ub824\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \uc88b\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
          \uc774\uc81c \ub2e4\uc74c FTS \uc9c0\uc218\ub97c \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
          \"\"<\/p>\n
          \ucc38\uace0:<\/span><\/h5>\n
            \n
          1. The index contains a `type` mapping to specify that only documents with the `type` = ‘activity’ will be included in the index. Refer to this <\/span>FTS \uc720\ud615 \ub9e4\ud551<\/span><\/a> \ubb38\uc11c\uc5d0\uc11c \uc790\uc138\ud55c \ub0b4\uc6a9\uc744 \ud655\uc778\ud558\uc138\uc694.<\/span><\/li>\n
          2. \uc778\ub371\uc2a4\ub294 \ud0a4\uc6cc\ub4dc \ubd84\uc11d\uae30\ub97c \uc0ac\uc6a9\ud558\ubbc0\ub85c \ub370\uc774\ud130 \uac12\uc774 \uac1c\ubcc4 \uc6a9\uc5b4\ub85c \uad6c\ubb38 \ubd84\uc11d\ub418\uc9c0 \uc54a\uace0 \uc778\ub371\uc2a4 \uc804\uccb4\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4.<\/span><\/li>\n
          3. \uac01 \ud544\ub4dc\ub294 GSI \uc778\ub371\uc2a4\uc640 \uac70\uc758 \ub3d9\uc77c\ud55c \ubc29\uc2dd\uc73c\ub85c \uac1c\ubcc4\uc801\uc73c\ub85c \uc778\ub371\uc2f1\ub429\ub2c8\ub2e4. <\/span>\ub2e4\ub978 \ubaa8\ub4e0 \uc635\uc158\uc740 \ud0a4\uc6cc\ub4dc \uac80\uc0c9\uacfc \uad00\ub828\uc774 \uc5c6\uc73c\ubbc0\ub85c \uc120\ud0dd\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. FTS \ud558\uc704 \ub9e4\ud551<\/a> \ubb38\uc11c\uc5d0\uc11c \uc790\uc138\ud55c \ub0b4\uc6a9\uc744 \ud655\uc778\ud558\uc138\uc694.\u00a0<\/span>\"\"<\/span><\/li>\n<\/ol>\n
            \uc774 FTS \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \uc704\uc640 \ub3d9\uc77c\ud55c \ucffc\ub9ac\uc774\uc9c0\ub9cc <\/span>\uc778\ub371\uc2a4 \uc0ac\uc6a9(FTS\ub97c \uc0ac\uc6a9\ud558\ub294 \ubaa8\ub4e0_\ud589\uc704) <\/b>hint, will instruct the query service to consider using FTS index instead. Note that the index name `all_acts` is optional.<\/span><\/p>\n
            SELECT * FROM crm a\r\nWHERE a.type='activity' USE INDEX (USING FTS) \r\n \/* 1  *\/ AND a.title LIKE 'Announcing Couchbase Flex Index%'\r\n \/* 2  *\/ AND a.dept = 'st55'\r\n \/* 3  *\/ AND a.region = '00528'\r\n \/* 4  *\/ AND a.priority = 'High'\r\n \/* 5  *\/ AND a.act_date BETWEEN '2020-08-01' AND '2020-08-31'\r\n \/* 6  *\/ AND a.event.location = 'Moscone Center' \r\n \/* 7  *\/ AND a.event.name = 'N1QL Flex Index vs ElasticSQL'\r\n \/* 8  *\/ AND a.event.vendor = 'Kempinski'\r\n \/* 9  *\/ AND a.event.theme = 'CouchbaseRed'\r\n \/* 10 *\/ AND a.account.id = 'acc134'\r\n \/* 11 *\/ AND a.account.name = 'Horizon Cellular'\r\n \/* 12 *\/ AND a.owner.id = 'usr24'\r\n \/* 13 *\/ AND a.owner.name = 'John Higgins'\r\n<\/pre>\n
            \ucffc\ub9ac \uacc4\ud68d:<\/span><\/h5>\n
            \"\"<\/p>\n
            \ucffc\ub9ac \uc2e4\ud589:<\/h5>\n
            \"\"<\/p>\n
            \uc8fc\uc694 \ucc38\uace0 \uc0ac\ud56d<\/b>: \ucffc\ub9ac\ub294 \ub2e4\uc591\ud55c \uc218\uc758 \uc220\uc5b4\uc640 \ubaa8\ub4e0 \ud544\ub4dc \uc870\ud569\uc744 \uac00\uc9c8 \uc218 \uc788\uc73c\uba70, \ucffc\ub9ac\ub294 \uc5ec\uc804\ud788 FTS \uc778\ub371\uc2a4\ub97c \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n
            3) \ub17c\ub9ac \uc5f0\uc0b0\uc790 \uc870\ud569\uc744 \uc0ac\uc6a9\ud55c \uc720\uc5f0\ud55c \uc778\ub371\uc2a4 \ucffc\ub9ac - AND\/OR<\/span><\/h3>\n
            \uc220\uc5b4 \uc870\ud569\uacfc \uad00\ub828\ud55c FTS \uc778\ub371\uc2a4\uc758 \uc7a5\uc810\uc740 \uac01 \uc778\ub371\uc2a4 \ud544\ub4dc\uac00 \uc0dd\uc131\ub418\ub294 \ubc29\uc2dd\uc5d0\uc11c\ub3c4 \ub354\uc6b1 \ud655\uc7a5\ub429\ub2c8\ub2e4. \uc778\ub371\uc2f1\ub41c \uac01 \ud544\ub4dc\ub294 \uc790\uccb4\uc801\uc73c\ub85c \ubc18\uc804\ub41c \uad6c\uc870\ub97c \uac00\uc9c0\uace0 \uc788\uace0 Bleve \ub8e8\ud2f4\uc774 \uac01 \uac80\uc0c9 \uc870\uac74\uc5d0 \ub300\ud574 \ube44\ud2b8\ub9f5\uc744 \uc0dd\uc131\ud558\uae30 \ub54c\ubb38\uc5d0, AND\/OR\/NOT\uacfc \uac19\uc740 \uc220\uc5b4 \uc870\ud569\uc740 B-Tree \uc778\ub371\uc2a4\uc758 \uad50\ucc28 \uc2a4\uce94\uc5d0 \ube44\ud574 \ud6e8\uc52c \ub354 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ub429\ub2c8\ub2e4.<\/span><\/p>\n
            The example below shows that even though there are several logical operators OR in the query, the `all_acts` FTS index is still be considered.<\/span><\/p>\n
            SELECT * FROM crm a USE INDEX (USING FTS)\r\nWHERE a.type='activity'\r\nAND ( a.dept = 'iA88'\r\n    OR a.region > '59416' )\r\nAND a.priority = 'High'\r\nAND ( a.act_date BETWEEN '2018-01-01' AND '2018-08-31'\r\n    OR a.event.location = 'Moscone Center' )\r\nAND ( a.account.id = 'acc100'\r\n     OR a.owner.name = 'Amanda Morrison')\r\nLIMIT 10<\/pre>\n
            \ucffc\ub9ac \uacc4\ud68d:<\/h5>\n
            \"\"<\/p>\n
            \ucffc\ub9ac \uc2e4\ud589:<\/span><\/h5>\n
            \"\"<\/p>\n
            4) \ucffc\ub9ac\uc5d0 \uc5ec\ub7ec \ubc30\uc5f4 \uc220\uc5b4\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0\u00a0<\/span><\/h3>\n
            FTS \uc778\ub371\uc2a4\uc758 \ub2e4\uc591\uc131\uc740 \uac80\uc0c9 \uc870\uac74\uc5d0\uc11c \uc778\ub371\uc2f1\ub41c \ud544\ub4dc\uc758 \ud558\uc704 \uc9d1\ud569\ub9cc\uc73c\ub85c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc774\ub098 \uac80\uc0c9 \uacb0\uacfc\ub97c \ub17c\ub9ac \uc5f0\uc0b0\uc790\uc640 \ud6a8\uc728\uc801\uc73c\ub85c \uacb0\ud569\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc5d0\ub9cc \uadf8\uce58\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub610\ud55c FTS \uc778\ub371\uc2a4\uac00 \ubc30\uc5f4 \uc694\uc18c\ub97c \ucc98\ub9ac\ud558\ub294 \ubc29\uc2dd\uc740 N1QL \ucffc\ub9ac\uac00 \ubc30\uc5f4 \uc220\uc5b4\ub97c \uc5bc\ub9c8\ub4e0\uc9c0 \uac00\uc9c8 \uc218 \uc788\ub3c4\ub85d \ud574\uc90d\ub2c8\ub2e4.\u00a0<\/span><\/p>\n
            \uc774\uc81c \ubc30\uc5f4 \uc220\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\ub97c \ub354 \ud655\uc7a5\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n
            SELECT * FROM crm a\r\nWHERE a.type='activity' USE INDEX (USING FTS) \r\n \/* 1  *\/ AND a.title LIKE 'Announcing Couchbase Flex Index%'\r\n \/* 2  *\/ AND a.dept = 'st55'\r\n \/* 3  *\/ AND a.region = '00528'\r\n \/* 4  *\/ AND a.priority = 'High'\r\n \/* 5  *\/ AND a.act_date BETWEEN '2020-08-01' AND '2020-08-31'\r\n \/* 6  *\/ AND a.event.location = 'Moscone Center South' \r\n \/* 7  *\/ AND a.event.name = 'N1QL Flex Index vs ElasticSQL'\r\n \/* 8  *\/ AND a.event.vendor = 'Kempskinki'\r\n \/* 9  *\/ AND a.event.theme = 'CouchbaseRed'\r\n \/* 10 *\/ AND a.account.id = 'acc134'\r\n \/* 11 *\/ AND a.account.name = 'Horizon Cellular'\r\n \/* 12 *\/ AND a.owner.id = 'usr24'\r\n \/* 13 *\/ AND a.owner.name = 'Binh Le'\r\n\r\n \/* 14 *\/ AND ANY pa IN a.participants SATISFIES pa.name LIKE 'Randy%' END\r\n \/* 15 *\/ AND ANY co IN a.appointment.contacts SATISFIES co.title LIKE 'System Arch%' END<\/pre>\n
            \ud558\uc9c0\ub9cc \uc544\ub798\uc640 \uac19\uc774 \ub450 \ubc30\uc5f4\uc744 \uc778\ub371\uc2a4\uc5d0 \ud558\uc704 \ub9e4\ud551\uc73c\ub85c \ucd94\uac00\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
            \"\"<\/p>\n
            5) \ucc28\uc774\uc810 \uac80\uc0c9 \uad6c\ubb38<\/span><\/h3>\n
            \uc774 \uc0ac\uc6a9 \uc0ac\ub840\ub294 \uc8fc\ub85c \ud0a4\uc6cc\ub4dc \uac80\uc0c9\uc5d0 FTS\ub97c \uc0ac\uc6a9\ud558\uba70 \uac80\uc0c9 \uc220\uc5b4 \uad6c\ubb38\uacfc \uac19\uc740 \uac04\ub2e8\ud55c SQL\uc744 \uc120\ud638\ud558\ub294 \uacbd\uc6b0\uc785\ub2c8\ub2e4.
            \n<\/span><\/p>\n
            \"\"<\/p>\n
            N1QL \ubc0f \uc81c\ud55c \uc5c6\ub294 \uac80\uc0c9<\/span><\/h2>\n
            \ucd5c\uc2e0 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\ub294 \uc815\ud655\ud55c \uac80\uc0c9\uacfc \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc774 \ubaa8\ub450 \ud544\uc694\ud569\ub2c8\ub2e4. \uc815\ud655\ud55c \uac80\uc0c9\uc744 \uc704\ud574 \ub300\ubd80\ubd84\uc758 RDBMS\ub294 \uc694\uad6c \uc0ac\ud56d\uc744 \ucda9\uc871\ud558\uae30 \uc704\ud574 B-Tree \uae30\ubc18 \uc778\ub371\uc2a4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc5d0 \ub300\ud55c \uc694\uad6c \uc0ac\ud56d\uc73c\ub85c \uc778\ud574 ElasticSearch \ubc0f Solr\uc640 \uac19\uc740 Lucene \uae30\ubc18 \uac80\uc0c9 \uc5d4\uc9c4\uc758 \uc778\uae30\uac00 \ub192\uc544\uc84c\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
              \n
            1. \uc774\uc81c Oracle NoSQL\uc774 ElasticSearch\uc640 \ud1b5\ud569\ub418\uc5c8\uc2b5\ub2c8\ub2e4: <\/span>https:\/\/docs.oracle.com\/en\/database\/other-databases\/nosql-database\/18.1\/full-text-search\/index.html#NSFTL-GUID-E409CC44-9A8F-4043-82C8-6B95CD939296<\/a><\/li>\n
            2. \ub610\ud55c, \uc624\ub77c\ud074 \uc5d4\ud130\ud504\ub77c\uc774\uc988 RDBMS \uae30\ubc18 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 CX \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc81c\ud488\uad70\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc635\uc158\uc73c\ub85c ElasticSearch \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. https:\/\/www.oracle.com\/webfolder\/technetwork\/tutorials\/tutorial\/cloud\/r13\/wn\/engagement\/releases\/20B\/20B-engagement-wn.htm<\/a><\/span><\/li>\n<\/ol>\n
              \uadf8\ub7ec\ub098 \uace0\ub3c4\ub85c \uc815\uaddc\ud654\ub41c RDBMS \ub370\uc774\ud130 \ubaa8\ub378\uc5d0 ElasticSearch \uae30\ub2a5\uc744 \ub3c4\uc785\ud558\ub294 \ub370\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc5b4\ub824\uc6c0\uc774 \ub530\ub985\ub2c8\ub2e4.<\/span><\/p>\n
                \n
              1. ElasticSearch\ub97c \uc124\uc815\ud558\uae30 \uc704\ud55c \ub9ac\uc18c\uc2a4 \uc694\uad6c \uc0ac\ud56d\uacfc ElasticSearch \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c RDBMS \ub370\uc774\ud130\ub97c \uc218\uc9d1\ud558\uae30 \uc704\ud55c \uc2a4\ud1a0\ub9ac\uc9c0 \uc694\uad6c \uc0ac\ud56d\uc785\ub2c8\ub2e4.<\/span><\/li>\n
              2. \ub8e8\uc52c \uae30\ubc18 \uac80\uc0c9\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc870\uc778\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uad11\ubc94\uc704\ud558\uac8c \ube44\uc815\uaddc\ud654\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/li>\n
              3. ElasticSearch API\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac80\uc0c9\uc744 \uad6c\ud604\ud558\uae30 \uc704\ud55c \uac1c\ubc1c \ub178\ub825.<\/span><\/li>\n<\/ol>\n
                ElasticSearch\ub97c \uc0ac\uc6a9\ud558\uace0\uc790 \ud558\ub294 \uace0\uac1d\ub4e4\uc744 \uc704\ud55c \ub178\ub825\uc740 \uc774\ub7ec\ud55c NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c SQL\uc774 \ucc44\ud0dd\ub41c \uc8fc\uc694 \uc774\uc720 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4.<\/span><\/p>\n
                  \n
                1. SQL\uc744 \uc0ac\uc6a9\ud55c Elasticsearch. https:\/\/www.elastic.co\/what-is\/elasticsearch-sql<\/a><\/span><\/li>\n
                2. SQL\uc744 \uc0ac\uc6a9\ud55c Elasticsearch\uc6a9 Opendistro. https:\/\/opendistro.github.io\/for-elasticsearch\/features\/SQL%20Support.html<\/a><\/span><\/li>\n
                3. MongoDB\ub294 Atlas \uc81c\ud488\uc5d0\uc11c Lucene\uc744 \uc0ac\uc6a9\ud558\uc5ec MQL\uc5d0 \uac80\uc0c9 \uae30\ub2a5\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4. https:\/\/www.mongodb.com\/atlas\/search<\/a><\/span><\/li>\n<\/ol>\n
                  \uadf8\ub7ec\ub098 \uc774\ub7ec\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 SQL \uad6c\ud604\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc81c\ud55c \uc0ac\ud56d\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
                    \n
                  1. ElasticSQL \uc81c\ud55c \uc0ac\ud56d: <\/span>https:\/\/www.elastic.co\/guide\/en\/elasticsearch\/reference\/current\/sql-limitations.html<\/span><\/a>\n
                      \n
                    1. \uc9d1\ud569 \uc791\uc5c5 \uc870\uc778 \ub4f1\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n
                    2. \ucc3d \uae30\ub2a5\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<\/li>\n
                    3. MongoDB\uc758 MQL \uac80\uc0c9 \ud1b5\ud569\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc81c\ud55c \uc0ac\ud56d\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/span>\n
                        \n
                      1. \uc628\ud504\ub808\ubbf8\uc2a4 \uc81c\ud488\uc774 \uc544\ub2cc Atlas \uac80\uc0c9 \uc11c\ube44\uc2a4\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n
                      2. \uac80\uc0c9\uc740 \uc9d1\uacc4() \ud30c\uc774\ud504\ub77c\uc778 \ub0b4\uc5d0\uc11c \uccab \ubc88\uc9f8 \uc791\uc5c5\ub9cc \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n
                      3. \uc9d1\uacc4 \ud30c\uc774\ud504\ub77c\uc778(aggregate()) \ub0b4\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc5c5\ub370\uc774\ud2b8 \ub610\ub294 \uc0ad\uc81c\uc640 \ud568\uaed8 \uc220\uc5b4\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                        \ubc18\uba74\uc5d0 Couchbase\ub294 \uc218\ub144 \ub3d9\uc548 N1QL\uacfc \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \uc81c\uacf5\ud574 \uc654\uc2b5\ub2c8\ub2e4. \uc774 \ucffc\ub9ac \uc5b8\uc5b4\ub294 \uc131\uc219\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ubcfc \uc218 \uc788\ub294 \ubaa8\ub4e0 \uc5f0\uc0b0\uc744 \uc9c0\uc6d0\ud558\uba70, \uaddc\uce59 \uae30\ubc18 \ubc0f \ube44\uc6a9 \uae30\ubc18 \ucffc\ub9ac \ucd5c\uc801\ud654\uc640 \uac19\uc740 \uc870\uc778, \uc9d1\uacc4, RDBMS\uc640 \uac19\uc740 \uc5f0\uc0b0\uc744 \ubaa8\ub450 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.  \uac00\uc7a5 \uc911\uc694\ud55c \uac83\uc740 N1QL \uc5b8\uc5b4\uac00 \uae30\ubcf8\uc801\uc73c\ub85c JSON \ubb38\uc11c\uc640 \ud568\uaed8 \uc791\ub3d9\ud560 \uc218 \uc788\ub3c4\ub85d NEST, UNNEST \ubc0f ARRAY \uc5f0\uc0b0\uacfc \uac19\uc740 \ucd94\uac00 \uad6c\uc870\uc785\ub2c8\ub2e4.<\/span><\/p>\n
                        \uac80\uc0c9 \uae30\ub2a5\uacfc \uad00\ub828\ud558\uc5ec Couchbase N1QL\uc758 \uc911\uc694\ud55c \uc810\uc740 Couchbase \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc774 N1QL \uc5b8\uc5b4\uc5d0 \uc644\ubcbd\ud558\uac8c \ud1b5\ud569\ub418\uc5b4 \uc788\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4.<\/span><\/p>\n
                          \n
                        1. Couchbase 6.5 N1QL \uac80\uc0c9 \uae30\ub2a5. https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/searchfun.html<\/a><\/span><\/li>\n
                        2. \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 6.6 \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4(\uc774 \uae00\uc758 \uc8fc\uc81c). https:\/\/docs.couchbase.com\/server\/6.6\/n1ql\/n1ql-language-reference\/flex-indexes.html<\/a><\/span><\/li>\n<\/ol>\n
                          N1QL\uc758 \uac15\ub825\ud55c \uae30\ub2a5\uc744 \uac16\ucd98 \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4<\/span><\/h3>\n
                          \ub2e4\uc74c\uc740 i) \uc601\uc5c5\ud300\uc774 \ubaa8\ub4e0 \uace0\uac1d\uacfc \uc791\uc5c5\ud55c \uc2dc\uac04\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \ubd84\uc11d\ud558\ub824\ub294 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub300\ud55c N1QL \ucffc\ub9ac\uc758 \uc608\uc785\ub2c8\ub2e4. \uc0b0\uc5c5<\/code>\ub97c \ubc18\ud658\ud558\uace0 ii) \uc0c1\uc704 3\uac1c \uae30\uc220 \uc138\ud2b8<\/code> \uc774\ub7ec\ud55c \uace0\uac1d\uacfc \ud568\uaed8 \uc77c\ud55c \uc601\uc5c5 \ud300\uc6d0\ub4e4\uc758 \uc774\uc57c\uae30\ub97c \ub4e4\uc5b4\ubcf4\uc138\uc694.<\/p>\n
                          \uc774 \ucffc\ub9ac\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4\uac00 \ubaa8\ub4e0 N1QL \uae30\ub2a5\uc758 \uc870\ud569\uacfc \ud568\uaed8 \uc0ac\uc6a9\ub420 \uc218 \uc788\uc74c\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.\u00a0<\/span><\/p>\n
                          \"Full<\/p>\n
                           <\/p>\n
                          \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4 \uace0\ub824 \uc0ac\ud56d<\/span><\/h2>\n
                          \uc9c0\uae08\uae4c\uc9c0 \uc608\uc81c\ub97c \ud1b5\ud574 Flex \uc778\ub371\uc2a4 \uae30\ub2a5\uc774 \uc5b4\ub5bb\uac8c \ub2e8\uc77c \ub2e4\uc911 \ud544\ub4dc FTS \uc778\ub371\uc2a4\ub97c \ud65c\uc6a9\ud558\uc5ec \ub2e4\uc591\ud55c \uc720\ud615\uc758 \uc220\uc5b4 \uc870\ud569\uacfc \uc5ec\ub7ec \ubc30\uc5f4\uc744 \uac00\uc9c4 \ucffc\ub9ac\ub97c \ubaa8\ub450 \ucda9\uc871\uc2dc\ud0ac \uc218 \uc788\ub294\uc9c0 \uc124\uba85\ud588\uc9c0\ub9cc, GSI\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec \uc778\ub371\uc2a4\uac00 \ud544\uc694\ud560 \uac83\uc785\ub2c8\ub2e4.  \uadf8\ub807\ub2e4\uba74 GSI \ub300\uc2e0 FTS \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \uc778\ub371\uc2a4 \ud06c\uae30\uc5d0 \uc5b4\ub5a4 \uc601\ud5a5\uc774 \uc788\uc744\uae4c\uc694? \uc544\ub798 \ud45c\ub294 \uc81c \ub85c\uceec Couchbase \uc124\uc815\uc758 \uc778\ub371\uc2a4 \ud06c\uae30\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/span><\/p>\n
                          \uc0c9\uc778 \ud06c\uae30<\/h3>\n
                          \uc544\ub798 \ud45c\ub294 CRM \ud65c\ub3d9 \ubaa8\ub378 \ub370\uc774\ud130 \uc9d1\ud569\uc744 \uae30\ubc18\uc73c\ub85c \ud55c \uc778\ub371\uc2a4 \ud06c\uae30\uc758 \uc608\uc785\ub2c8\ub2e4.<\/p>\n
                          \ubb38\uc11c \ud06c\uae30: <\/span> 1.5K.\u00a0 \u00a0 \u00a0 <\/span>\ubb38\uc11c \uc218: <\/span> 500K<\/span><\/p>\n\n\n\n\n\n
                          \uc0c9\uc778 \uc635\uc158<\/b><\/td>\nGSI \uc778\ub371\uc2a4 \ud06c\uae30<\/b><\/td>\nFTS \uc778\ub371\uc2a4 \ud06c\uae30<\/b><\/td>\n\uc2a4\ud1a0\ub9ac\uc9c0 \ucc28\uc774<\/b><\/td>\n<\/tr>\n
                          13\uac1c \ud544\ub4dc\uc5d0 \ub300\ud55c \uc0c9\uc778<\/span><\/td>\n205 MB<\/span><\/td>\n252 MB<\/span><\/td>\n+25%<\/span><\/td>\n<\/tr>\n
                          13\uac1c \ud544\ub4dc +<\/span> \ubaa8\ub450<\/b> \ub450 \ubc30\uc5f4\uc758 \uc694\uc18c<\/span><\/td>\nN\/A<\/span><\/td>\n357 MB<\/span><\/td>\n–<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                          \uc704 \ud45c\uc758 \ubaa9\uc801\uc740 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \uc778\ub371\uc2a4\uc758 \uc815\ud655\ud55c \ud06c\uae30\ub97c \uc81c\uacf5\ud558\uae30 \uc704\ud55c \uac83\uc774 \uc544\ub2c8\ub77c \ub450 \uc778\ub371\uc2a4 \uac04\uc758 \uc0c1\ub300\uc801\uc778 \ud06c\uae30 \ucc28\uc774\ub97c \uc81c\uacf5\ud558\uae30 \uc704\ud55c \uac83\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n
                            \n
                          1. FTS \uc778\ub371\uc2a4\ub294 GSI \uc778\ub371\uc2a4\uc5d0 \ube44\ud574 \ud06c\uae30\uac00 \uc57d 25% \ub354 \ud07d\ub2c8\ub2e4. \uc774 \uc218\uce58\ub294 \uc0d8\ud50c \ub370\uc774\ud130\uc640 \uc778\ub371\uc2f1\ub41c \ud544\ub4dc\uc758 \ubd84\ud3ec\ub97c \ubc18\uc601\ud569\ub2c8\ub2e4.<\/span><\/li>\n
                          2. \ubc30\uc5f4 \uc694\uc18c\ub97c \uc0ac\uc6a9\ud558\uba74 \ub9ce\uc740 \ube44\uc6a9\uc744 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n
                          3. FTS \uc778\ub371\uc2a4\ub294 \ub450 \ubc30\uc5f4\uc758 \ubaa8\ub4e0 \uc694\uc18c\ub97c \ub2e8\uc77c \uc778\ub371\uc2a4\uc5d0 \ud3ec\ud568\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n
                            \ucffc\ub9ac \uc131\ub2a5<\/h3>\n
                            \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc778\ub371\uc2f1\uacfc \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \uc778\ub371\uc2f1<\/a> \uc11c\ube44\uc2a4\ub294 \ub2e4\ucc28\uc6d0 \ud655\uc7a5 \ubc0f \uace0\uac00\uc6a9\uc131\uc744 \ud1b5\ud574 \ud655\uc7a5\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc989, \uc774\ub7ec\ud55c \uc11c\ube44\uc2a4\ub294 \uc11c\ub85c \ub2e4\ub978 \ubaa9\ud45c\ub97c \ucda9\uc871\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2f1 \uc11c\ube44\uc2a4\ub294 \uc9c0\uc5f0 \uc2dc\uac04\uc774 \uae38\uace0 \ucc98\ub9ac\ub7c9\uc774 \ub9ce\uc740 \uc694\uad6c\uc0ac\ud56d\uc5d0 \uac00\uc7a5 \uc801\ud569\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ucffc\ub9ac\uc758 \uac80\uc0c9 \uc870\uac74\uc740 \uc791\uc740 \uacb0\uacfc \uc9d1\ud569\uc73c\ub85c \uc798 \uc815\uc758\ub418\uc5b4 \uc788\uc744 \uac83\uc73c\ub85c \uc608\uc0c1\ub429\ub2c8\ub2e4. \ubc18\uba74\uc5d0 FTS \uc11c\ube44\uc2a4\ub294 \uace0\uae09 \ubd84\uc11d\uae30\ub97c \uc9c0\uc6d0\ud558\uc5ec \ud37c\uc9c0 \uc694\uc18c\ub97c \ucd94\uac00\ud558\uace0 \uc5b8\uc5b4\ub97c \uc778\uc2dd\ud558\uba70 \uac01 \uacb0\uacfc\uc5d0 \ub300\ud55c \uad00\ub828\uc131 \uc810\uc218\ub97c \uc81c\uacf5\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
                              \n
                            1. \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4\uc5d0 \uae30\ubc18\ud55c \ucffc\ub9ac\uc5d0\ub294 \ud56d\uc0c1 fetch<\/code> \ub2e8\uacc4\ub85c \ub118\uc5b4\uac00\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ucffc\ub9ac \uc11c\ube44\uc2a4\uac00 \uc5ec\uc804\ud788 \ucffc\ub9ac \ucc98\ub9ac\uc5d0\uc11c \ud544\ud130<\/code> \ub2e8\uacc4\uc785\ub2c8\ub2e4.<\/li>\n
                            2. \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \uc9d1\uacc4 \ud478\uc2dc\ub2e4\uc6b4\uacfc \uac19\uc740 \ucffc\ub9ac \uc131\ub2a5 \ucd5c\uc801\ud654\ub294 GSI\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70 Flex Index\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n
                            3. \uc9c0\uc6d0\ub418\ub294 \uc778\ub371\uc2a4 \ucffc\ub9ac\ub294 GSI\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
                            4. Flex Index\ub97c \uc0ac\uc6a9\ud558\uba74 \ud398\uc774\uc9c0 \ub9e4\uae40\uc744 FTS\ub85c \ud478\uc2dc\ub2e4\uc6b4\ud560 \uc218 \uc5c6\uc73c\ubbc0\ub85c \ucffc\ub9ac \uc218\uc900\uc5d0\uc11c \ucffc\ub9ac \ud398\uc774\uc9c0 \ub9e4\uae40\uc774 \uc218\ud589\ub429\ub2c8\ub2e4.<\/li>\n
                            5. JOIN \ucffc\ub9ac\uc758 \uacbd\uc6b0, FTS \uac80\uc0c9 \ucffc\ub9ac\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud544\ub4dc\ub9cc Flex Index\uc5d0 \uc804\ub2ec\ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n
                              \uc694\uc57d<\/span><\/h2>\n
                              \ub9ce\uc740 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294 \uac80\uc0c9\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\uae30 \uc704\ud574 MQL\uc744 \ud1b5\ud574 \uac04\uc811\uc801\uc73c\ub85c SQL\uc744 \ubaa8\ubc29\ud558\uac70\ub098 ElasticSQL\uc5d0\uc11c SQL\uc744 \uc9c1\uc811 \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc5b8\uc5b4\ub97c \uac1c\uc120\ud558\ub824\uace0 \ub178\ub825\ud558\uace0 \uc788\uc9c0\ub9cc, \ub9ce\uc740 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294 \uac80\uc0c9\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\uae30 \uc704\ud574 \ub178\ub825\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc624\uc9c1 Couchbase N1QL Flex Index\ub9cc\uc774 N1QL SEARCH()\ub97c \ud1b5\ud574 \uc774 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \uac80\uc0c9\uc744 \ubaa8\ub450 \uc6d0\ud65c\ud558\uac8c \uc81c\uacf5\ud558\uba70, \uc774\uc81c N1QL Flex Index\uc5d0\uc11c \ud45c\uc900 \uc220\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQL \uc9c0\uc2dd\ub9cc \uc788\uc73c\uba74 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \uac80\uc0c9\uc744 \ubaa8\ub450 \ud65c\uc6a9\ud560 \uc218 \uc788\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c, \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc740 \ubaa8\ub4e0 N1QL \uae30\ub2a5, JOIN\/Aggregation\/CTE \ubc0f \uace0\uae09 \ubd84\uc11d \ucc3d \ud568\uc218, JSON \ubb38\uc11c\ub97c \uc704\ud55c NEST\/UNNEST\/ARRAY\uc640\ub3c4 \uacb0\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
                              \ucc38\uc870<\/span><\/h2>\n
                                \n
                              1. \uc774 \ubb38\uc11c\uc5d0\uc11c \uc0ac\uc6a9\ub41c \ud65c\ub3d9 \uad00\ub9ac \ub370\uc774\ud130 \ubaa8\ub378 \uc0d8\ud50c \ub370\uc774\ud130 \uc138\ud2b8\uc785\ub2c8\ub2e4. https:\/\/couchbase-sample-datasets.s3.us-east-2.amazonaws.com\/crm.tar<\/a><\/span><\/li>\n<\/ol>\n
                                Couchbase Server 6.6 \ub9ac\uc18c\uc2a4 \uc0b4\ud3b4\ubcf4\uae30<\/strong><\/p>\n
                                 <\/p>\n\n\n\n\n\n\n\n\n\n\n
                                \ube14\ub85c\uadf8<\/strong><\/td>\n\ubb38\uc11c \ubc0f \ud29c\ud1a0\ub9ac\uc5bc<\/strong><\/td>\n\uc6f9\ud398\uc774\uc9c0 \ubc0f \uc6f9 \uc138\ubbf8\ub098<\/strong><\/td>\n<\/tr>\n
                                Couchbase Server 6.6\uc758 \uc0c8\ub85c\uc6b4 \uae30\ub2a5<\/a><\/td>\n\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 6.6\uc758 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<\/a><\/td>\nCouchbase Server 6.6\uc758 \uc0c8\ub85c\uc6b4 \uae30\ub2a5: \ubd84\uc11d, \ubc31\uc5c5, \ucffc\ub9ac \ub4f1<\/a><\/td>\n<\/tr>\n
                                \uc774\ubca4\ud2b8 \uac1c\uc120 \uc0ac\ud56d(\ud0c0\uc774\uba38, \ud578\ub4e4\ub7ec, \ud1b5\uacc4)<\/a><\/td>\n\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 6.6 \ub9b4\ub9ac\uc2a4 \ub178\ud2b8<\/a><\/td>\n\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc560\ub110\ub9ac\ud2f1\uc2a4 \uc11c\ube44\uc2a4<\/a><\/td>\n<\/tr>\n
                                \uc6d0\uaca9 \ub9c1\ud06c - \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc560\ub110\ub9ac\ud2f1\uc2a4\ub85c \uae30\uc5c5 \ubd84\uc11d\ud558\uae30<\/a><\/td>\n\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uc11c\ube44\uc2a4 \uccb4\ud5d8\ud558\uae30<\/a><\/td>\nCouchbase Server\uc758 \uc0c8\ub85c\uc6b4 \uae30\ub2a5(\uc81c\ud488 \ud398\uc774\uc9c0)<\/a><\/td>\n<\/tr>\n
                                \uc678\ubd80 \ub370\uc774\ud130 \uc138\ud2b8 - Couchbase \ubd84\uc11d\uc73c\ub85c \ub3c4\ub2ec \ubc94\uc704 \ud655\uc7a5\ud558\uae30<\/a><\/td>\nREST API\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc560\ub110\ub9ac\ud2f1\uc2a4 \uc6d0\uaca9 \ubc0f S3 \ub9c1\ud06c \uc124\uc815\ud558\uae30<\/a><\/td>\n\uc5d0\ub514\uc158 \ube44\uad50<\/a><\/td>\n<\/tr>\n
                                \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc640 \ud568\uaed8 \ud50c\ub809\uc2a4 \uc778\ub371\uc2a4 \ubc1c\ud45c<\/a><\/td>\n\ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4(DDL)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc678\ubd80 \ub370\uc774\ud130 \uc9d1\ud569 \ub9cc\ub4e4\uae30<\/a><\/td>\n<\/td>\n<\/tr>\n
                                \uac1c\uccb4 \uc800\uc7a5\uc18c\uc5d0 \ubc31\uc5c5(S3) \uc18c\uac1c<\/a><\/td>\nCLI\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc560\ub110\ub9ac\ud2f1\uc2a4 \uc6d0\uaca9 \ubc0f S3 \ub9c1\ud06c \uc124\uc815\ud558\uae30<\/a><\/td>\n<\/td>\n<\/tr>\n
                                \uc6f9 \uad00\ub9ac \ucf58\uc194\ub85c \ubb38\uc11c \uac00\uc838\uc624\uae30<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                 <\/p>","protected":false},"excerpt":{"rendered":"
                                Flex Index Explained What is a Flex Index? One of the key tasks of a database engine is how to efficiently manage the search and retrieval of the data therein. The efficiency and balance between resource consumption and performance are […]<\/p>","protected":false},"author":26326,"featured_media":9153,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1814,2165,1812],"tags":[1725],"ppma_author":[8919],"class_list":["post-9025","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-design","category-full-text-search","category-n1ql-query","tag-nosql-database"],"acf":[],"yoast_head":"\nAnnouncing Flex Index With Couchbase - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"The Flex Index is a unique Couchbase innovation that uses the inverted indexes from Full-Text Search in complex Couchbase N1QL queries.\" \/>\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\/announcing-flex-index-with-couchbase\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Announcing Flex Index With Couchbase\" \/>\n<meta property=\"og:description\" content=\"The Flex Index is a unique Couchbase innovation that uses the inverted indexes from Full-Text Search in complex Couchbase N1QL queries.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/announcing-flex-index-with-couchbase\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-12T16:00:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T03:27:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1400\" \/>\n\t<meta property=\"og:image:height\" content=\"553\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Binh Le\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Binh Le\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/\"},\"author\":{\"name\":\"Binh Le\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f89064928e262c71eb43bee996c48c63\"},\"headline\":\"Announcing Flex Index With Couchbase\",\"datePublished\":\"2020-08-12T16:00:13+00:00\",\"dateModified\":\"2025-06-14T03:27:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/\"},\"wordCount\":3186,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg\",\"keywords\":[\"NoSQL Database\"],\"articleSection\":[\"Application Design\",\"Full-Text Search\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/\",\"name\":\"Announcing Flex Index With Couchbase - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg\",\"datePublished\":\"2020-08-12T16:00:13+00:00\",\"dateModified\":\"2025-06-14T03:27:37+00:00\",\"description\":\"The Flex Index is a unique Couchbase innovation that uses the inverted indexes from Full-Text Search in complex Couchbase N1QL queries.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg\",\"width\":1400,\"height\":553,\"caption\":\"Flex Index is Amazing\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Announcing Flex Index With Couchbase\"}]},{\"@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\/f89064928e262c71eb43bee996c48c63\",\"name\":\"Binh Le\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/5b68c37e30928a9d7b2c8470b1a303b7\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g\",\"caption\":\"Binh Le\"},\"description\":\"Binh Le is a Principal Product Manager for Couchbase Query service. Prior to Couchbase, he worked at Oracle and led the product management team for Sales Cloud Analytics and CRM OnDemand. Binh holds a Bachelor's Degree in Computer Science from the University of Brighton, UK.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/binh-le-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Announcing Flex Index With Couchbase - The Couchbase Blog","description":"The Flex Index is a unique Couchbase innovation that uses the inverted indexes from Full-Text Search in complex Couchbase N1QL queries.","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\/announcing-flex-index-with-couchbase\/","og_locale":"ko_KR","og_type":"article","og_title":"Announcing Flex Index With Couchbase","og_description":"The Flex Index is a unique Couchbase innovation that uses the inverted indexes from Full-Text Search in complex Couchbase N1QL queries.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/announcing-flex-index-with-couchbase\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-08-12T16:00:13+00:00","article_modified_time":"2025-06-14T03:27:37+00:00","og_image":[{"width":1400,"height":553,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg","type":"image\/jpeg"}],"author":"Binh Le","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Binh Le","Est. reading time":"16\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/"},"author":{"name":"Binh Le","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f89064928e262c71eb43bee996c48c63"},"headline":"Announcing Flex Index With Couchbase","datePublished":"2020-08-12T16:00:13+00:00","dateModified":"2025-06-14T03:27:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/"},"wordCount":3186,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg","keywords":["NoSQL Database"],"articleSection":["Application Design","Full-Text Search","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/","url":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/","name":"Announcing Flex Index With Couchbase - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg","datePublished":"2020-08-12T16:00:13+00:00","dateModified":"2025-06-14T03:27:37+00:00","description":"The Flex Index is a unique Couchbase innovation that uses the inverted indexes from Full-Text Search in complex Couchbase N1QL queries.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/indexing.jpg","width":1400,"height":553,"caption":"Flex Index is Amazing"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/announcing-flex-index-with-couchbase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Announcing Flex Index With Couchbase"}]},{"@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\/f89064928e262c71eb43bee996c48c63","name":"Binh Le","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/5b68c37e30928a9d7b2c8470b1a303b7","url":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","caption":"Binh Le"},"description":"Binh Le is a Principal Product Manager for Couchbase Query service. Prior to Couchbase, he worked at Oracle and led the product management team for Sales Cloud Analytics and CRM OnDemand. Binh holds a Bachelor's Degree in Computer Science from the University of Brighton, UK.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/binh-le-2\/"}]}},"authors":[{"term_id":8919,"user_id":26326,"is_guest":0,"slug":"binh-le-2","display_name":"Binh Le","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","author_category":"","last_name":"Le","first_name":"Binh","job_title":"","user_url":"","description":"Binh Le\ub294 Couchbase \ucffc\ub9ac \uc11c\ube44\uc2a4\uc758 \uc218\uc11d \uc81c\ud488 \uad00\ub9ac\uc790\uc785\ub2c8\ub2e4. Couchbase\uc5d0 \uc785\uc0ac\ud558\uae30 \uc804\uc5d0\ub294 Oracle\uc5d0\uc11c \uadfc\ubb34\ud558\uba70 Sales Cloud Analytics \ubc0f CRM OnDemand\uc758 \uc81c\ud488 \uad00\ub9ac \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. \uc601\uad6d \ube0c\ub77c\uc774\ud2bc \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/9025","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\/26326"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=9025"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/9025\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/9153"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=9025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=9025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=9025"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=9025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}