{"id":4193,"date":"2017-11-16T00:00:26","date_gmt":"2017-11-16T08:00:26","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=4193"},"modified":"2025-06-13T17:23:02","modified_gmt":"2025-06-14T00:23:02","slug":"database-indexing-best-practices","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/database-indexing-best-practices\/","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2f1 \ubaa8\ubc94 \uc0ac\ub840"},"content":{"rendered":"

\uc804\uc8fc\uace1: \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2f1\uc774\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/b><\/p>\n

\ube44\ub3d9\uae30 \uc778\ub371\uc2f1:<\/b> \uc608\ub97c \ub4e4\uc5b4 Couchbase\uc640 \uac19\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uae00\ub85c\ubc8c \ubcf4\uc870 \uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130 \ub178\ub4dc\uc758 JSON \ubb38\uc11c\uc5d0 \ub300\ud55c \uc77d\uae30 \ubc0f \uc4f0\uae30\uc5d0 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uace0 \uc0dd\uc131, \uc5c5\ub370\uc774\ud2b8 \ubc0f \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc989, \uc778\ub371\uc2a4\ubcc4 \uc0bd\uc785\/\uc5c5\ub370\uc774\ud2b8\/\uc0ad\uc81c\uac00 \ube44\ub3d9\uae30\uc801\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uba70 \uc6cc\ud06c\ub85c\ub4dc\uac00 \uc2dc\uc2a4\ud15c\uc758 \ub098\uba38\uc9c0 \ubd80\ubd84\uacfc \uaca9\ub9ac\ub429\ub2c8\ub2e4.<\/span><\/p>\n

\ucffc\ub9ac SLA\ub97c \uc774\ud574\ud558\uace0 \uc801\uc808\ud558\uac8c \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\uc138\uc694: <\/b>\uc778\ub371\uc2a4\ub294 \uc2e4\ud589\ub418\ub294 N1QL \ucffc\ub9ac\uc640 \uc9c1\uc811\uc801\uc73c\ub85c \uad00\ub828\uc774 \uc788\uc2b5\ub2c8\ub2e4. N1QL\uacfc GSI\ub294 \ud568\uaed8 \ud0f1\uace0\ub97c \ucda5\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub300\uae30 \uc2dc\uac04 \ube44\uc6a9\uc744 \uc904\uc774\uace0 \ucc98\ub9ac\ub7c9\uc744 \uc99d\uac00\uc2dc\ud0a4\ub294 N1QL \ucffc\ub9ac\uc758 \uc2a4\ud14c\ub85c\uc774\ub4dc \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub610\ud55c \uc790\uccb4 \uc2a4\ud1a0\ub9ac\uc9c0\ub97c \ud544\uc694\ub85c \ud558\uc9c0\ub9cc, \ub290\ub9b0(\ub610\ub294 \uc870\uc7a1\ud55c) \uace0\uac1d \ucc38\uc5ec \uacbd\ud5d8\uc73c\ub85c \uc778\ud574 \ube44\uc988\ub2c8\uc2a4\ub97c \uc783\uc744 \uc704\ud5d8\uc774 \uad00\ub828 \ube44\uc6a9\ubcf4\ub2e4 \ub192\uc2b5\ub2c8\ub2e4. \ub610\ud55c \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 \uc778\ub371\uc2a4\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc678\ubd80\uc5d0 \uc874\uc7ac\ud558\ubbc0\ub85c \uc218\uba85 \uc8fc\uae30\ub97c \uc801\uc808\ud558\uac8c \uad00\ub9ac\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/span><\/p>\n

\ucd5c\uace0\uc758 \uace0\uac1d \uacbd\ud5d8\uc744 \uc81c\uacf5\ud558\uae30 \uc704\ud55c \uba87 \uac00\uc9c0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4 \ubaa8\ubc94 \uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

1. \uc790\uccb4 \ub178\ub4dc \uc9d1\ud569\uc5d0\uc11c \uc778\ub371\uc2a4 \uc11c\ube44\uc2a4 \uc2e4\ud589<\/b><\/p>\n

\ub370\uc774\ud130, \ucffc\ub9ac, \uc778\ub371\uc2a4, \uac80\uc0c9 \ub4f1 Couchbase\uc758 \ubaa8\ub4e0 \uc11c\ube44\uc2a4\ub97c \ubaa8\ub4e0 \ub178\ub4dc\uc5d0\uc11c \uc2e4\ud589\ud560 \uc218 \uc788\uc9c0\ub9cc, \uac1c\ubcc4 \uc6cc\ud06c\ub85c\ub4dc\ub294 \uc790\uccb4 \ub178\ub4dc \uc138\ud2b8\uc5d0\uc11c \uc2e4\ud589\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \uc6cc\ud06c\ub85c\ub4dc\ub97c \uaca9\ub9ac\ud558\uace0 \ub3c5\ub9bd\uc801\uc73c\ub85c \ud655\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uc6cc\ud06c\ub85c\ub4dc\uc758 \ud2b9\uc131\uc5d0 \ub530\ub77c \ud558\ub4dc\uc6e8\uc5b4\ub97c \uc801\uc808\ud788 \ud560\ub2f9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc778\ub371\uc2a4\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uba54\ubaa8\ub9ac \uc9d1\uc57d\uc801\uc774\uace0 \ucffc\ub9ac\ub294 CPU \uc9d1\uc57d\uc801\uc785\ub2c8\ub2e4. \uc774\ub807\uac8c \uc11c\ub85c \ub2e4\ub978 \uc11c\ube44\uc2a4\ub97c \uc704\ud574 \uc11c\ub85c \ub2e4\ub978 \ud558\ub4dc\uc6e8\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc11c\ube44\uc2a4\ubcc4\ub85c \ucd5c\uc0c1\uc758 \ucef4\ud4e8\ud305 \uc6a9\ub7c9\uc744 \uc704\ud55c \ub3c5\ub9bd\uc801\uc778 \ud655\uc7a5\uc131\uc740 \ub2e4\ucc28\uc6d0 \ud655\uc7a5(MDS)\uc774 \uc81c\uacf5\ud558\ub294 \uc544\ud0a4\ud14d\ucc98\uc758 \uc7a5\uc810\uc73c\ub85c \ub2ec\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\"\"

\ubaa8\ub4e0 \uc11c\ube44\uc2a4\uac00 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ubaa8\ub4e0 \ub178\ub4dc\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 \uacbd\uc6b0<\/p><\/div>\n

\"\"

\uac1c\ubcc4 \uc11c\ube44\uc2a4\uac00 \uc790\uccb4 \uc804\uc6a9 \ub178\ub4dc\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 \uacbd\uc6b0<\/p><\/div>\n

2. MOI\uc640 \ud45c\uc900 GSI\uc5d0 \ub300\ud55c \uc774\ud574:\u00a0<\/b><\/p>\n

\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 5.0\uc740 \ud50c\ub77c\uc988\ub9c8\ub97c <\/span>GSI\uc6a9 \uc0c8\ub85c\uc6b4 \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4<\/span><\/a>. \uc124\uc815 \uc2dc '\ud45c\uc900 \uae00\ub85c\ubc8c \ubcf4\uc870'\ub97c \uc120\ud0dd\ud558\uba74 \ubc11\uc904\uc774 \uadf8\uc5b4\uc9c4 \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc774 \ud50c\ub77c\uc988\ub9c8\uc785\ub2c8\ub2e4. \ub450 \uc2a4\ud1a0\ub9ac\uc9c0 \uc720\ud615\uc740 \uc11c\ub85c \ub2e4\ub978 \ud2b9\uc131\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9 \uc0ac\ub840\uc5d0\uc11c \uc804\uccb4 \uc778\ub371\uc2a4\uac00 \uba54\ubaa8\ub9ac\uc5d0 \uc0c1\uc8fc\ud574\uc57c \ud558\ub294 \uacbd\uc6b0(\ub354 \uc5c4\uaca9\ud55c SLA, \ub354 \ub0ae\uc740 \ub808\uc774\ud134\uc2dc + \ub354 \ub192\uc740 \ucc98\ub9ac\ub7c9), MOI\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4. \ud45c\uc900 GSI(\ud50c\ub77c\uc988\ub9c8)\ub294 \uc804\uccb4 \uc778\ub371\uc2a4\uac00 \uba54\ubaa8\ub9ac\uc5d0 \uc0c1\uc8fc\ud560 \uc218 \uc5c6\uc744 \ub54c \ub9e4\uc6b0 \uc720\uc6a9\ud558\uba70, \uc774\ub97c DGM(Data-Greater-Than-Memory) \uc2dc\ub098\ub9ac\uc624\ub77c\uace0 \ud569\ub2c8\ub2e4. \ub610\ud55c \uba54\ubaa8\ub9ac \ube44\uc6a9\uc774 \uc778\ub371\uc2a4 \uc720\ud615\uc744 \uacb0\uc815\ud558\ub294 \ub370 \uc911\uc694\ud55c \uc694\uc18c\uc77c \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4. MOI\ub294 \uba54\ubaa8\ub9ac\uac00 \uc644\uc804\ud788 \uc0ac\uc6a9\ub418\uba74 \uc77c\uc2dc \uc911\uc9c0 \ubaa8\ub4dc\uc5d0 \ub4e4\uc5b4\uac08 \uc218 \uc788\uc9c0\ub9cc(\uc989, \ucffc\ub9ac\ub294 \uc11c\ube44\uc2a4\ub418\uc9c0\ub9cc \uc778\ub371\uc2a4 \uc5c5\ub370\uc774\ud2b8\ub294 \uc911\uc9c0\ub428), Plasma\ub294 \uc801\uc808\ud558\uac8c \ub514\uc2a4\ud06c\ub85c \ub118\uc5b4\uac00\uc11c \uc27d\uac8c \uc791\ub3d9(\uadf8\ub9ac\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc778\ub371\uc2a4\ub294 \uc5c5\ub370\uc774\ud2b8\ub428)\ud569\ub2c8\ub2e4. Couchbase 5.0\uc5d0\uc11c Plasma\ub294 20% DGM \uc2dc\ub098\ub9ac\uc624(\uc989, \uc778\ub371\uc2a4 \ub370\uc774\ud130\uc758 20%\uac00 \uba54\ubaa8\ub9ac\uc5d0 \uc788\ub294 \uacbd\uc6b0)\uae4c\uc9c0 \uc798 \uc791\ub3d9\ud558\uba70, \ucffc\ub9ac\uac00 \uba54\ubaa8\ub9ac\uc640 \ub514\uc2a4\ud06c \ubaa8\ub450\uc5d0\uc11c \ud0a4\uc5d0 \uc561\uc138\uc2a4\ud558\ub294 \uacbd\uc6b0 \ucffc\ub9ac \uc911\uc5d0 \ub514\uc2a4\ud06c \uc561\uc138\uc2a4\uac00 \ubd84\uba85\ud558\uae30 \ub54c\ubb38\uc5d0 \ucffc\ub9ac \uc131\ub2a5\uc5d0 \uc801\uc808\ud55c \uc601\ud5a5\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\uc644\uc804\ud788 \uba54\ubaa8\ub9ac\uc5d0 \uc0c1\uc8fc\ud558\ub294 \ud2b9\uc131\uc73c\ub85c \uc778\ud574 MOI\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ud45c\uc900 GSI(\ud2b9\ud788 \uc774\uc804\uc758 ForestDB)\ubcf4\ub2e4 \ud6e8\uc52c \ube60\ub985\ub2c8\ub2e4. \ud604\uc7ac\ub85c\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \uc778\ub371\uc2f1\uc774 \ub3d9\uc77c\ud55c \ud074\ub7ec\uc2a4\ud130\uc5d0 \uc0c1\uc8fc\ud558\ub294 \uac83\uc740 \ubd88\uac00\ub2a5\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\ub2e4\uc74c \ub3c4\uc2dd\uc5d0\uc11c\ub294 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ub2e4\uc591\ud55c \uc778\ub371\uc2a4 \uc800\uc7a5\uc18c \uc5d4\uc9c4\uacfc \uadf8 \uc0c1\uc704 \uae30\ub2a5\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\"\"3. \uc778\ub371\uc2a4 \ubcf5\uc81c\ubcf8 \uc0ac\uc6a9 : GSI\uc758 \ubcf5\uc81c\ubcf8\uc740 \ud65c\uc131 \ubcf5\uc81c\ubcf8\uc73c\ub85c, N1QL \ucffc\ub9ac\uc758 \ubd80\ud558\ub97c \ubd84\uc0b0\ud558\uace0 \ub2e4\ub978 \uc778\ub371\uc2a4 \ubcf5\uc81c\ubcf8\uc774 \uc2e4\ud328\ud560 \uacbd\uc6b0 \ud2b8\ub798\ud53d\uc744 \uc218\uc6a9\ud558\ub294 \ub450 \uac00\uc9c0 \uc6a9\ub3c4\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/span><\/b><\/p>\n

create index idx on bucket(field1) with {\u201cnum_replica\u201d: 2}<\/pre>\n
 \u00a0(\ub610\ub294)<\/span><\/p>\n
create index idx on bucket(field1) with {\u201cnodes\u201d:[\u201c1.2.3.1:8091\u201d, \u201c1.2.3.2:8091\u201d, \u201c1.2.3.3:8091\u201d]}<\/pre>\n
\ub370\uc774\ud130 \ub178\ub4dc\uc5d0\uc11c \ubb38\uc11c \uc5c5\ub370\uc774\ud2b8\uac00 \ubc1c\uc0dd\ud558\uba74 \ub450 \uc778\ub371\uc2a4 \ubcf5\uc0ac\ubcf8\uc774 \ube44\ub3d9\uae30\uc2dd\uc73c\ub85c \uc790\ub3d9 \uc5c5\ub370\uc774\ud2b8\ub429\ub2c8\ub2e4. \ud56d\uc0c1 \ubcf5\uc81c\ubcf8\uc774 \ud558\ub098 \uc774\uc0c1 \uc788\uc5b4\uc57c \ud558\uba70, \uc774\ub294 N1QL \ucffc\ub9ac\ub97c \uc11c\ube44\uc2a4\ud558\uae30 \uc704\ud574 \ucd5c\uc18c\ud55c \ub450 \uac1c\uc758 \uc778\ub371\uc2a4 \ub178\ub4dc\uac00 \uc788\uc5b4\uc57c \ud568\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. 5.0\uc5d0\uc11c\ub294 \uc2a4\uc651 \ub9ac\ubc38\ub7f0\uc2f1\uc774 \uc9c0\uc6d0\ub418\ubbc0\ub85c \uc778\ub371\uc2a4 \ub178\ub4dc\uac00 \ub2e4\uc6b4\ub418\uace0 \uc0c8 \ub178\ub4dc\uac00 \ub2e4\uc2dc \ucd94\uac00\ub418\uba74 \ud1a0\ud3f4\ub85c\uc9c0\uac00 \uc720\uc9c0\ub429\ub2c8\ub2e4. \uc774\ub294 \ucffc\ub9ac\uc758 \uacc4\uc808\uc131\uc73c\ub85c \uc778\ud55c \uc2a4\ucf00\uc77c\uc5c5\/\ub2e4\uc6b4 \uc791\uc5c5, \ub354 \ud070 \ub178\ub4dc\uc640 \ub354 \uc791\uc740 \ub178\ub4dc \uc0ac\uc774\ub97c \uc774\ub3d9\ud558\ub824\ub294 \uacbd\uc6b0\uc5d0 \ub9e4\uc6b0 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/span><\/p>\n
\uc774\ubbf8 \ub3d9\ub4f1\ud55c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4\uba74 \ubcf5\uc81c\ubcf8\uc73c\ub85c \uc804\ud658\ud558\uc138\uc694. \uc774 \ud504\ub85c\uc138\uc2a4\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694. <\/span>\uc5ec\uae30<\/span><\/a>.<\/span><\/p>\n
4. \uc778\ub371\uc2a4 \ubcc0\ud615<\/b><\/p>\n
GSI\ub294 \ub2e4\uc591\ud55c \uc0ac\uc6a9 \uc0ac\ub840\uc5d0 \ub530\ub77c \ub2e4\uc591\ud55c \ubcc0\ud615\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub2e4\uc591\ud55c \ubcc0\ud615\uc740 \ucffc\ub9ac\uc758 \ud2b9\uc131\uc5d0 \ub9de\uac8c \uad6c\ucd95\ub418\uc5c8\uc73c\ubbc0\ub85c \ucffc\ub9ac\uc758 \ub3d9\uc791\uc744 \uc774\ud574\ud558\uace0 \uc774\ub7ec\ud55c \uc778\ub371\uc2a4 \ubcc0\ud615\uc744 \uc801\uc808\ud788 \ud65c\uc6a9\ud558\ub294 \uac83\uc774 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n\n\n\n
\uae30\ubcf8 \uc0c9\uc778<\/span><\/a><\/td>\n\uae30\ub2a5 \uc0c9\uc778<\/span><\/td>\n<\/tr>\n
\uba85\uba85\ub41c \uae30\ubcf8 \uc0c9\uc778<\/span><\/td>\n\ubc30\uc5f4 \uc0c9\uc778<\/span><\/a><\/td>\n<\/tr>\n
\uc885\ud569 \uc9c0\uc218<\/span><\/td>\n\ucee4\ubc84\ub41c \uc0c9\uc778<\/span><\/a><\/td>\n<\/tr>\n
\ubd80\ubd84 \uc0c9\uc778<\/span><\/td>\n\uc801\uc751\ud615 \uc778\ub371\uc2a4<\/span><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\ud655\uc778\ud574 \ubcf4\uc138\uc694 <\/span>\uc774 DZone \uae30\uc0ac<\/span><\/a> \uadf8\ub9ac\uace0 <\/span>\uc774 \ubb38\uc11c<\/span><\/a> \ub97c \ucc38\uc870\ud558\uc138\uc694.<\/span><\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4\uc758 \uc608\ub85c \ucee4\ubc84\ub41c \uc778\ub371\uc2a4\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \ubcc0\ud615\uc5d0\ub294 \uc220\uc5b4\uc640 \uc815\uc758\uc5d0\uc11c \uc778\ub371\uc2f1\ub41c \ubaa8\ub4e0 \uc18d\uc131\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \ub370\uc774\ud130 \ub178\ub4dc\ub85c\uc758 \ucd94\uac00 \ud649\uc774 \ubc29\uc9c0\ub429\ub2c8\ub2e4. \ucffc\ub9ac \uc9c0\uc5f0 \uc2dc\uac04\uc774 \ud06c\uac8c \uc904\uc5b4\ub4ed\ub2c8\ub2e4.<\/span><\/p>\n
\uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n
CREATE INDEX `idx_ts_type_iata` ON `travel-sample`(`type`,`iata`);<\/pre>\n
\uadf8\ub9ac\uace0 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4:<\/span><\/p>\n
select iata from `travel-sample` where type=\"airline\" and iata = \"TQ\"<\/pre>\n
\uadf8\ub7ec\uba74 \uc124\uba85 \uacc4\ud68d\uc5d0\uc11c \ucffc\ub9ac\uac00 \uc778\ub371\uc2a4\uc5d0 '\ud3ec\ud568'\ub418\uace0 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n
\"~children\": [ \u00a0\u00a0\u00a0\u00a0\u00a0\r\n  { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n    \"#operator\": \"IndexScan2\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n      \"covers\": [ \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n      \"cover ((`travel-sample`.`type`))\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n      \"cover ((`travel-sample`.`iata`))\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n      \"cover ((meta(`travel-sample`).`id`))\" \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n  ], \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n  \"index\": \"idx_ts_type_iata\",<\/pre>\n
\uadf8\ub9ac\uace0 '\ubaa8\ub450'('select *' \uc0ac\uc6a9) \uc18d\uc131\uc744 \uc120\ud0dd\ud558\ub824\uace0 \ud569\ub2c8\ub2e4:<\/span><\/p>\n
select * from `travel-sample` where type=\"airline\" and iata = \"TQ\";<\/span><\/pre>\n
\uadf8\ub7f0 \ub2e4\uc74c \uc124\uba85 \uacc4\ud68d\uc740 \ucffc\ub9ac \uc11c\ube44\uc2a4\uac00 \ubaa8\ub4e0 \uc18d\uc131\uc744 \uac00\uc838\uc624\uae30 \uc704\ud574 \ub370\uc774\ud130 \uc11c\ube44\uc2a4\ub85c \uc774\ub3d9\ud574\uc57c \ud558\ubbc0\ub85c \ucffc\ub9ac\uac00 \ucee4\ubc84\ub418\uc9c0 \uc54a\ub294('\ucee4\ubc84' \ud544\ub4dc \ub204\ub77d) \uac83\uc73c\ub85c \ub098\ud0c0\ub0ac\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n
\"~children\": [ \u00a0\u00a0\u00a0\u00a0\u00a0\r\n  { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n    \"#operator\": \"IndexScan2\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n    \"index\": \"idx_ts_type_iata\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n    \"index_id\": \"240cf64d8c6ddce3\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n    \"index_projection\": {\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"primary_key\": true \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n     },<\/pre>\n
\ub9c8\ucc2c\uac00\uc9c0\ub85c \ubc30\uc5f4 \uc778\ub371\uc2a4\ub294 \uc8fc\ub85c \uace0\uac1d\uc774 JSON \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\ub294 \ub370 \ub3c4\uc6c0\uc744 \uc8fc\uae30 \uc704\ud574 \ub9cc\ub4e4\uc5b4\uc84c\uc73c\uba70, \ubc30\uc5f4\uc740 \ub9e4\uc6b0 \uc77c\ubc18\uc801\uc785\ub2c8\ub2e4. \uc774\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ud3ec\uc2a4\ud305\uc774 \uace7 \uc62c\ub77c\uc624\uaca0\uc2b5\ub2c8\ub2e4!<\/p>\n
5.\u00a0<\/strong>\ud504\ub85c\ub355\uc158 \ud658\uacbd\uc5d0\uc11c \uae30\ubcf8 \ud0a4 \uc0ac\uc6a9 \ubc29\uc9c0<\/b><\/p>\n
\uc608\uae30\uce58 \uc54a\uc740 \uc804\uccb4 \uae30\ubcf8 \uc778\ub371\uc2a4 \uc2a4\uce94\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \ud504\ub85c\ub355\uc158\uc5d0\uc11c\ub294 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc544\uc608 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc74c\uc73c\ub85c\uc368 \uc774\ub7ec\ud55c \ubc1c\uc0dd \uac00\ub2a5\uc131\uc744 \uc81c\uac70\ud574\uc57c \ud569\ub2c8\ub2e4. N1QL \uc778\ub371\uc2a4 \uc120\ud0dd\uc740 \ud604\uc7ac \uaddc\uce59 \uae30\ubc18 \uc2dc\uc2a4\ud15c\uc73c\ub85c \ucffc\ub9ac\ub97c \ucda9\uc871\ud560 \uc218 \uc788\ub294 \uc778\ub371\uc2a4\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uace0, \uc778\ub371\uc2a4\uac00 \uc5c6\ub294 \uacbd\uc6b0 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uae30\ubcf8 \uc778\ub371\uc2a4\uc5d0\ub294 \ubb38\uc11c\uc758 \ubaa8\ub4e0 \ud0a4\uac00 \uc788\uc73c\ubbc0\ub85c \ucffc\ub9ac\ub294 \uae30\ubcf8 \uc778\ub371\uc2a4\uc5d0\uc11c \ubaa8\ub4e0 \ud0a4\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ub370\uc774\ud130 \uc11c\ube44\uc2a4\ub85c \uc774\ub3d9\ud558\uc5ec \ubb38\uc11c\ub97c \uac00\uc838\uc628 \ub2e4\uc74c \ud544\ud130\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4. \ubcf4\uc2dc\ub2e4\uc2dc\ud53c \uc774 \uc791\uc5c5\uc740 \ub9e4\uc6b0 \ube44\uc6a9\uc774 \ub9ce\uc774 \ub4dc\ub294 \uc791\uc5c5\uc774\ubbc0\ub85c \uc5b4\ub5a4 \ub300\uac00\ub97c \uce58\ub974\ub354\ub77c\ub3c4 \ud53c\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n
\uc0dd\uc131\ub41c \uae30\ubcf8 \uc778\ub371\uc2a4\uac00 \uc5c6\uace0 \ucffc\ub9ac\ub97c \ucc98\ub9ac\ud560 \uc77c\uce58\ud558\ub294 \uc778\ub371\uc2a4\ub97c \ucc3e\uc744 \uc218 \uc5c6\ub294 \uacbd\uc6b0 \ucffc\ub9ac \uc11c\ube44\uc2a4\uc5d0\uc11c \ub2e4\uc74c \uba54\uc2dc\uc9c0\uc640 \ud568\uaed8 \uc624\ub958\ub97c \ud45c\uc2dc\ud558\ubbc0\ub85c \ud544\uc694\ud55c \ubcf4\uc870 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4dc\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4:<\/span><\/p>\n
\"<\/span>\ucffc\ub9ac\uc640 \uc77c\uce58\ud558\ub294 \ud0a4 \uc2a4\ud398\uc774\uc2a4 \uc5ec\ud589 \uc0d8\ud50c\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc778\ub371\uc2a4\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4 \ub9cc\ub4e4\uae30 \ub610\ub294 \uae30\ubcf8 \uc778\ub371\uc2a4 \ub9cc\ub4e4\uae30\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4\uac70\ub098 \uc608\uc0c1 \uc778\ub371\uc2a4\uac00 \uc628\ub77c\uc778 \uc0c1\ud0dc\uc778\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/span><\/i>.\"<\/span><\/p>\n
\ub610\ud55c \uace0\uc720\ud55c \uc778\ub371\uc2f1 \ubaa8\ubc94 \uc0ac\ub840\ub85c\uc11c, \uae30\ubcf8 \uc778\ub371\uc2a4\uc758 \ud30c\ud2f0\uc154\ub2dd\uc740 Couchbase\uc5d0\uc11c \uc9c0\uc6d0\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub9ce\uc740 RDBMS\uc640 \ub2ec\ub9ac, \uae30\ubcf8 \ud0a4\ub294 Couchbase\uc5d0\uc11c \uc120\ud0dd \uc0ac\ud56d\uc785\ub2c8\ub2e4.<\/span><\/p>\n
6. \uc124\uba85 \uc694\uae08\uc81c \uc0ac\uc6a9<\/b><\/p>\n
N1QL \ucffc\ub9ac\uac00 \uc2e4\uc81c\ub85c \uc0dd\uc131\ub41c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud558\ub824\uba74 \ub2e4\uc74c\uc744 \ud655\uc778\ud569\ub2c8\ub2e4. \uacc4\ud68d \uc124\uba85 <\/a>\uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Couchbase \uad00\ub9ac \ucf58\uc194\uc5d0\uc11c \ucf54\ub4dc \ud3b8\uc9d1\uae30\uc5d0 \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uace0 '\uc124\uba85' \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \uc27d\uac8c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \"1TP5\uc6b4\uc601\uc790<\/b>\" \ubc0f \"\uc0c9\uc778<\/b>\" \uc18d\uc131\uc744 \ud655\uc778\ud558\uc5ec \uc778\ub371\uc2a4 \uc0ac\uc6a9\uc744 \ud655\uc778\ud569\ub2c8\ub2e4. \ubb38\uc11c \ub9c1\ud06c.<\/p>\n
\"\"7. \uc220\uc5b4\ubcc4 \uc0c9\uc778<\/b><\/p>\n
\ucffc\ub9ac\uc5d0\uc11c WHERE \uc808\uc744 \uc220\uc5b4\ub77c\uace0 \ud558\uace0 SELECT \uc808\uc5d0\uc11c \uc120\ud0dd\ud55c \ud544\ub4dc\/\uc18d\uc131\uc744 \ud22c\uc601\uc774\ub77c\uace0 \ud569\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ud56d\uc0c1 Predicate \uc808\uc744 \uc5fc\ub450\uc5d0 \ub450\uace0 \uc0dd\uc131\ud574\uc57c \ud569\ub2c8\ub2e4. \uc778\ub371\uc2a4 \uc120\ud0dd\uc740 Predicate\uc5d0 \uc788\ub294 \uc778\ub371\uc2a4\uc758 \uc120\ud589 \ud0a4\ub97c \uae30\ubc18\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n
\uc608\ub97c \ub4e4\uc5b4 4\uac1c\uc758 \uc18d\uc131\uc5d0 \ub300\ud574 \ub2e4\uc74c\uacfc \uac19\uc740 \uc778\ub371\uc2a4\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4:<\/span><\/p>\n
CREATE INDEX `idx_ts_type_iata_name_icao` ON `travel-sample`(`type`,`iata`, `name`,`icao`);<\/pre>\n
\uadf8\ub9ac\uace0 \ucffc\ub9ac\ud558\ub294 \ub3d9\uc548 \uc2e4\uc81c\ub85c icao \uc18d\uc131\uc744 \uac74\ub108\ub6f0\ub294 \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uba74 \ucffc\ub9ac \uc5d4\uc9c4\uc740 \ucd5c\uc0c1\uc758 \ucffc\ub9ac \uc131\ub2a5\uc744 \uc704\ud574 \uc704\uc758 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4\ub294 \uac83\uc744 \ucda9\ubd84\ud788 \ub611\ub611\ud558\uac8c \uc54c\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
select name from `travel-sample` where icao=\"MLA\" and type=\"airline\";<\/pre>\n
\uc120\ud0dd\ud55c \uc778\ub371\uc2a4\ub294 \uc544\ub798 \uc124\uba85 \uacc4\ud68d\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc220\uc5b4\uc5d0 \uc5c6\ub294 'name'\uc774 Projection\uc5d0 \uc788\uc73c\ubbc0\ub85c \ucffc\ub9ac\ub294 \ucee4\ubc84\ub9c1 \ucffc\ub9ac\uac00 \ub418\uba70, \ub530\ub77c\uc11c \ub370\uc774\ud130 \uc11c\ube44\uc2a4\ub85c\uc758 \ud649\uc740 \ud53c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
\"~children\": [ \u00a0\u00a0\u00a0\u00a0\u00a0\r\n   { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n      \"#operator\": \"IndexScan2\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n      \"covers\": [ \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n        \"cover ((`travel-sample`.`type`))\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n        \"cover ((`travel-sample`.`iata`))\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n        \"cover ((`travel-sample`.`name`))\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n        \"cover ((`travel-sample`.`icao`))\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n        \"cover ((meta(`travel-sample`).`id`))\" \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n      ], \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n      \"index\": \"idx_ts_type_iata_name_icao\",<\/pre>\n
8. \uc120\ud589 \ud0a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4 \uac15\uc81c \uc120\ud0dd<\/b><\/p>\n
\ucffc\ub9ac\uc5d0 \uc0ac\uc6a9\ub41c \uc220\uc5b4\uac00 \uc778\ub371\uc2a4\uc758 \uc120\ud589 \ud0a4\uc640 \uc77c\uce58\ud558\uc9c0 \uc54a\uc73c\uba74 \uc778\ub371\uc2a4\uac00 \ucffc\ub9ac\uc5d0 \ub300\ud574 \uc790\ub3d9\uc73c\ub85c \uc120\ud0dd\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc124\uba85 \uacc4\ud68d\uc5d0\uc11c \uc778\ub371\uc2a4\uac00 \uac15\uc81c\ub85c \uc120\ud0dd\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0 'IS NOT MISSING' \ub610\ub294 'IS NOT NULL' \uc808\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4\ub97c \uac15\uc81c\ub85c \uc120\ud0dd\ud558\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n
Fo<\/span>\uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c \ucffc\ub9ac \uc911 \ud558\ub098\ub97c \uc785\ub825\ud569\ub2c8\ub2e4:<\/span><\/p>\n
select count(1) from `travel-sample` where type IS NOT NULL; \r\nselect count(1) from `travel-sample` where type IS NOT MISSING;<\/pre>\n
\uc740 \uc778\ub371\uc2a4\uc758 \uc120\ud589 \ud0a4\uac00 'type'\uc774\ubbc0\ub85c \ub2e4\uc74c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4:<\/span><\/p>\n
CREATE INDEX `idx_ts_type_iata` ON `travel-sample`(`type`,`iata`);<\/pre>\n
\uc774\ubbf8 \uc0dd\uc131\ub41c \uc778\ub371\uc2a4\ub9cc \uc120\ud0dd\ud558\ub824\uba74 <\/span>\uc0ac\uc6a9 \uc0c9\uc778<\/span><\/a> \uc9c0\uc2dc\uc5b4\ub97c N1QL \ucffc\ub9ac\uc758 \uc77c\ubd80\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 USE INDEX\uc5d0 \uc5b8\uae09\ub41c \uc778\ub371\uc2a4\uac00 N1QL \uaddc\uce59 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c\uc5d0\uc11c \uc120\ud0dd\ud55c \uc778\ub371\uc2a4\ubcf4\ub2e4 \ub354 \ub098\uc740 \uc120\ud0dd\uc131\uc744 \uac00\uc9c0\uace0 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c\uace0 \uc788\ub294 \uacbd\uc6b0\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4:<\/span><\/p>\n
select count(1) from `travel-sample` USE INDEX (idx_ts_type_iata) where type=\"airline\";<\/pre>\n
9. \ubd80\ubd84 \uc778\ub371\uc2a4 \uc0ac\uc6a9<\/b><\/p>\n
\ub54c\ub54c\ub85c \uc778\ub371\uc2f1\ud560 \uc220\uc5b4\uac00 \ud06c\uae30 \uc81c\ud55c\uc73c\ub85c \uc778\ud574 \ud558\ub098\uc758 \ub178\ub4dc\uc5d0 \ub9de\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  Couchbase\uc758 GSI\ub294 \ud604\uc7ac\ub85c\uc11c\ub294 \uc790\ub3d9\uc73c\ub85c \ubd84\ud560\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uad00\ub9ac\uc790\uac00 \ubd80\ubd84 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud574\uc57c \ud558\uba70, N1QL \ucffc\ub9ac\ub294 \ubd80\ubd84 \uc778\ub371\uc2a4\uac00 \uc788\ub294 \uacbd\uc6b0 \ucffc\ub9ac\uc5d0 \uc0ac\uc6a9\ub41c \uc220\uc5b4\uc758 \uc885\ub958\uc5d0 \ub530\ub77c \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc120\ud0dd\ud560 \uc218 \uc788\uc744 \ub9cc\ud07c \ub611\ub611\ud569\ub2c8\ub2e4. <\/span><\/p>\n
\uc608\ub97c \ub4e4\uc5b4, \uc774\ub984\uc774 \ub450 \uac1c\uc758 \uc11c\ub85c \ub2e4\ub978 \ubc94\uc704\uc5d0 \uc788\ub294 \uac83\uc744 \uae30\uc900\uc73c\ub85c \ub2e4\uc74c \ub450 \uac1c\uc758 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4:<\/span><\/p>\n
CREATE INDEX `idx_ts_name_ak` ON `travel-sample`(`name`) WHERE name BETWEEN \"A\" AND \"K\"; \r\nCREATE INDEX `idx_ts_name_kz` ON `travel-sample`(`name`) WHERE name BETWEEN \"K\" AND \"Z\";<\/pre>\n
\uc774\uc81c \ub2e4\uc74c \ucffc\ub9ac\ub294 \uac01 \uc124\uba85 \uacc4\ud68d\uc5d0 \uba85\uc2dc\ub41c \ub300\ub85c \uc801\ud569\ud55c \uc778\ub371\uc2a4\ub97c \uc790\ub3d9\uc73c\ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4:<\/span><\/p>\n
select * from `travel-sample` where name=\"Astraeus\"; \r\n\r\nEXPLAIN PLAN : \r\n\"~children\": [ \u00a0\u00a0\u00a0\u00a0\u00a0\r\n   { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n     \"#operator\": \"IndexScan2\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n     \"index\": \"idx_ts_name_ak\",<\/pre>\n
select * from `travel-sample` where name=\"Texas Wings\"; \r\n\r\nEXPLAIN PLAN : \r\n\"~children\": [ \u00a0\u00a0\u00a0\u00a0\u00a0\r\n  { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n     \"#operator\": \"IndexScan2\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n     \"index\": \"idx_ts_name_kz\",<\/pre>\n
\uc220\uc5b4\uc5d0 LIKE \uc808\uc744 \uc0ac\uc6a9\ud560 \ub54c \uc778\ub371\uc2a4\uac00 \uc801\uc808\ud558\uac8c \uc120\ud0dd\ub429\ub2c8\ub2e4. <\/span>\uc608\ub97c \ub4e4\uc5b4 \ud504\ub791\uc2a4\uc5b4 \uc774\ub984('L'\ub85c \uc2dc\uc791)\ucc98\ub7fc \ub4e4\ub9ac\ub294 \ubaa8\ub4e0 \uc774\ub984\uc744 \uac00\uc838\uc624\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n
select * from `travel-sample` where name like \"L'%\";\r\nEXPLAIN PLAN : \r\n\"~children\": [ \u00a0\u00a0\u00a0\u00a0\u00a0\r\n  { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n     \"#operator\": \"IndexScan2\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n     \"index\": \"idx_ts_name_kz\",<\/pre>\n
10. \uc77c\uad00\uc131 \uc635\uc158<\/b><\/p>\n
\ube44\ub3d9\uae30\uc801 \ud2b9\uc131\uc73c\ub85c \uc778\ud574 Couchbase\uc758 GSI\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uc77c\uad00\uc131\uc744 \uc720\uc9c0\ud558\uba70 \uc774\ubbf8 \uc5b8\uae09\ud588\ub4ef\uc774 \ube44\ub3d9\uae30\uc801\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub429\ub2c8\ub2e4. \ubcc0\uacbd \ud53c\ub4dc(DCP)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac00\ub2a5\ud55c \ud55c \ube68\ub9ac \uc778\ub371\uc2a4\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\uc9c0\ub9cc, \ud2b9\uc815 \ubb38\uc11c \ubcc0\uacbd\uc774 \uc778\ub371\uc2a4\uc5d0\uc11c \uc5c5\ub370\uc774\ud2b8\ub418\uc9c0 \uc54a\uc558\uc744 \uac00\ub2a5\uc131\uc774 \ub9e4\uc6b0 \ub192\uc2b5\ub2c8\ub2e4. \ucffc\ub9ac \uc758\ubbf8\ub860\uc5d0\uc11c \ub354 \uc5c4\uaca9\ud55c \ub370\uc774\ud130 \uc77c\uad00\uc131\uc774 \uc694\uad6c\ub418\ub294 \uacbd\uc6b0, Couchbase\ub294 \ucffc\ub9ac \uc2dc\uc810\uc5d0 \uc870\uc815 \uac00\ub2a5\ud55c \uc77c\uad00\uc131 \ubaa8\ub378\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/span><\/p>\n
Couchbase\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc77c\uad00\uc131 \uc635\uc158\uc740 \uc138 \uac00\uc9c0\uc785\ub2c8\ub2e4:<\/span><\/p>\n
    \n
  1. \uc2a4\uce94 \uc77c\uad00\uc131=not_bounded<\/span><\/li>\n
  2. \uc2a4\uce94 \uc77c\uad00\uc131=at_plus<\/span><\/li>\n
  3. \uc2a4\uce94 \uc77c\uad00\uc131 = \uc694\uccad_\ud50c\ub7ec\uc2a4<\/span><\/li>\n<\/ol>\n
    \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uae30: <\/span>\ubb38\uc11c \ub9c1\ud06c<\/span><\/a><\/p>\n
    \uc694\uccad_\ud50c\ub7ec\uc2a4 \uc758\ubbf8\ub860\uc740 \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud558\uc9c0\ub9cc \ucffc\ub9ac \ub300\uae30 \uc2dc\uac04\uc774 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uba70, \ucffc\ub9ac\ub294 \ub370\uc774\ud130\uac00 \ubc18\ud658\ub418\uae30 \uc804\uc5d0 \uad00\ub828 \uc778\ub371\uc2a4\uac00 \ucd5c\uc2e0 \ubcc0\ud615\uc744 \ub530\ub77c\uc7a1\uc744 \ub54c\uae4c\uc9c0 \uae30\ub2e4\ub9bd\ub2c8\ub2e4. 'not_bounded'(\uae30\ubcf8 \uc77c\uad00\uc131 \uc635\uc158)\ub294 3\uac00\uc9c0 \uc77c\uad00\uc131 \uc635\uc158 \uc911 \uac00\uc7a5 \ube60\ub978 \uc635\uc158\uc785\ub2c8\ub2e4.<\/span><\/p>\n
    11. \ubaa8\ub2c8\ud130 \uc778\ub371\uc2a4 \ub530\ub77c\uc7a1\uae30<\/b><\/p>\n
    \uc77c\ubc18\uc801\uc73c\ub85c \uc778\ub371\uc2a4 \uc11c\ube44\uc2a4\ub294 \ubb38\uc11c \ubcc0\uacbd\uc744 \ub9e4\uc6b0 \ube60\ub974\uac8c \ub530\ub77c\uc7a1\uc544 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uac70\uc758 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uad00\ub9ac\uc790\ub85c\uc11c (\uc0c9\uc778\uc5d0\uc11c \uc5c5\ub370\uc774\ud2b8\ub420) \ubb38\uc11c \ubcc0\uacbd\uc774 \uac00\ub2a5\ud55c \ud55c \ucd5c\uc18c\ud654\ub418\uace0 \uacc4\uc18d \uc99d\uac00\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud558\ub824\uba74 \uc0c9\uc778 \uc774\ub984 \uc544\ub798\uc758 '\ub0a8\uc740 \ud56d\ubaa9' \uba54\ud2b8\ub9ad\uc744 \uc0b4\ud3b4\ubcf4\uc138\uc694.<\/p>\n
    \"\"<\/p>\n
    12. \ube4c\ub4dc \uc9c0\uc5f0 \uc0ac\uc6a9<\/b><\/p>\n
    \ub514\ud37c \ube4c\ub4dc\ub294 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 2\ub2e8\uacc4 \ud504\ub85c\uc138\uc2a4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub178\ub4dc\uc5d0\uc11c \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 \ub370 \ub3d9\uc77c\ud55c \ubcc0\uacbd \ud53c\ub4dc\uac00 \uc0ac\uc6a9\ub418\ubbc0\ub85c \ud56d\uc0c1 \ub514\ud37c \ube4c\ub4dc\ub97c \ucd5c\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \ub514\ud37c \ube4c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74 \ub370\uc774\ud130 \ub178\ub4dc\uc758 \ubcc0\uacbd \ud53c\ub4dc\uc5d0 \uc5ec\ub7ec \ubc88 \uc561\uc138\uc2a4\ud574\uc57c \ud558\ubbc0\ub85c \ub124\ud2b8\uc6cc\ud06c\ub97c \ud1b5\ud574 \ub354 \ub9ce\uc740 \ub370\uc774\ud130\uac00 \uc804\uc1a1\ub418\uace0 \ub370\uc774\ud130 \ub178\ub4dc\uc758 \ubd80\ud558\uac00 \uc57d\uac04 \uc99d\uac00\ud569\ub2c8\ub2e4.<\/span><\/p>\n
    \uc608\uc2dc:<\/span><\/p>\n
    CREATE INDEX `idx_ts_type_iata` ON `travel-sample`(`type`,`iata`) WITH { \"defer_build\":true }; \r\nBUILD INDEX ON `travel-sample`(`idx_ts_type_iata`);<\/pre>\n
    \uc778\ub371\uc2a4 \uc0dd\uc131 \uad6c\ubb38\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <\/span>\ubb38\uc11c<\/span><\/a>.<\/span><\/p>\n
    13. \uc778\ub371\uc2f1\ud560 \ud070 \ud0a4\ub294 \ud53c\ud558\uc138\uc694.<\/b><\/p>\n
    5.0 \uc774\uc804\uc5d0\ub294 \uc778\ub371\uc2a4\uc758 \ud0a4 \ud06c\uae30\uc5d0 \uc81c\ud55c\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4(\ucd5c\ub300 4k). \uc774 \uc81c\ud55c\uc740 5.0\uc5d0\uc11c \uc81c\uac70\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130 \uc561\uc138\uc2a4 \uacbd\ub85c\ub97c \uc704\ud55c \uac83\uc774\ubbc0\ub85c, \ub370\uc774\ud130 \ubaa8\ub378\uacfc \ucffc\ub9ac(\uc778\ub371\uc2a4 \ud3ec\ud568)\ub294 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \ucd5c\ub2e8 \uc2dc\uac04\uc5d0 \uc5bb\uc744 \uc218 \uc788\ub3c4\ub85d \uad6c\uc870\ud654\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uace0\uac1d\uc740 \ubcf5\ud569 \uc778\ub371\uc2a4\uc5d0 \ud544\ub4dc\ub97c \uc5bc\ub9c8\ub4e0\uc9c0 \ud3ec\ud568\ud560 \uc218 \uc788\uc9c0\ub9cc, \uc778\ub371\uc2a4 \ud0a4 \ud06c\uae30\ub3c4 \uadf8\uc5d0 \ube44\ub840\ud558\uc5ec \ucee4\uc9d1\ub2c8\ub2e4.  \ud0a4 \ud06c\uae30\uac00 \ub108\ubb34 \ud06c\uba74 \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \ubcf5\ud569 \uc778\ub371\uc2a4\uc758 \ubaa8\ub4e0 \ud544\ub4dc\ub97c \ud569\uce5c \ud06c\uae30\uac00 1kB\uac00 \ub418\ub3c4\ub85d \ud558\uace0, \uc774\uac83\uc774 \ubd88\uac00\ub2a5\ud558\ub2e4\uba74 \ucffc\ub9ac\ub97c \uc801\uc808\ud788 \ub9ac\ud329\ud130\ub9c1\ud558\uc138\uc694.<\/p>\n
    14. \ud0a4 \uc0ac\uc6a9, \uc778\ub371\uc2a4 \ud53c\ud558\uae30<\/b><\/p>\n
    \ubaa8\ub4e0 N1QL \ucffc\ub9ac\uc5d0 \uc778\ub371\uc2a4\uac00 \ud544\uc694\ud55c \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4. \ud0a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubb38\uc11c\ub97c \uc9c1\uc811 \ucffc\ub9ac\ud568\uc73c\ub85c\uc368 N1QL \ucffc\ub9ac\uac00 \uc778\ub371\uc2a4\uc640 \ub3c5\ub9bd\uc801\uc73c\ub85c \uc791\ub3d9\ud560 \uc218 \uc788\ub294 \uacbd\uc6b0 USE KEYS \uc9c0\uc2dc\ubb38\uc774 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n
    \uc608\ub97c \ub4e4\uc5b4<\/span><\/p>\n
    SELECT * FROM `travel-sample` USE KEYS [\"landmark_37588\"];<\/pre>\n
    \uacb0\uacfc \uc124\uba85 \uacc4\ud68d\uc5d0\ub294 (\uc778\ub371\uc2a4 \uc2a4\uce94\uc5d0 \ub300\ud55c \uc5b8\uae09 \uc5c6\uc774) \ud0a4 \uc2a4\uce94\uc774 \uc218\ud589\ub418\ub294 \uac83\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4:<\/span><\/p>\n
    \"~children\": [\r\n \u00a0\u00a0\u00a0\u00a0\u00a0{\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"#operator\": \"KeyScan\", \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n        \"keys\": \"[\\\"landmark_37588\\\"]\" \u00a0\u00a0\u00a0\u00a0\u00a0\r\n      }<\/pre>\n
    USE KEYS\ub294 \ucffc\ub9ac \uc11c\ube44\uc2a4\uc5d0\uc11c \uacb0\uacfc\ub97c \ubc18\ud658\ud558\ub294 \ub370 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c \uc774\ub294 \ubaa8\ubc94 \uc0ac\ub840\ub77c\uae30\ubcf4\ub2e4\ub294 \uc54c\uc544\ub450\uc5b4\uc57c \ud560 \uc0ac\ud56d\uc785\ub2c8\ub2e4. \uace0\uac1d\uc774 \ud56d\uc0c1 USE KEYS\ub97c \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\ub9cc \uac00\uc9c8 \uac00\ub2a5\uc131\uc740 \uac70\uc758 \uc5c6\uc9c0\ub9cc, \uc774\ub7ec\ud55c \ub3d9\uc791\uc774 \ud544\uc218\uc778 \uc5e3\uc9c0 \ucf00\uc774\uc2a4\uc5d0\uc11c\ub294 \uc720\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
    \uae34 \uae00\uc785\ub2c8\ub2e4!! \ud558\uc9c0\ub9cc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc778\ub371\uc2a4\ub97c \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\uc5c8\uae30\ub97c \ubc14\ub77c\uba70, DBMS \ubaa8\ubc94 \uc0ac\ub840\uc5d0\uc11c \uc778\ub371\uc2f1\uc774 \uc5b4\ub5bb\uac8c \uc6b0\uc218\ud55c \uace0\uac1d \uacbd\ud5d8\uc744 \uc81c\uacf5\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub294\uc9c0 :)<\/p>\n
    \ucd94\uc2e0: GSI \uac1c\uc694 \ubc0f Couchbase Server 5.0\uc758 \uc0c8\ub85c\uc6b4 \uae30\ub2a5: https:\/\/www.youtube.com\/watch?v=OrC2gkm2OFA<\/p>","protected":false},"excerpt":{"rendered":"
    Prelude: What is Database Indexing? Asynchronous Indexing: Global Secondary Indexes in databases — Couchbase, for example — can be created, updated and deleted without impacting the reads and writes on the JSON documents in Data nodes. This means that index-specific […]<\/p>","protected":false},"author":3013,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816,1812],"tags":[1695,1505,1626,1641],"ppma_author":[9055],"class_list":["post-4193","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","category-n1ql-query","tag-gsi","tag-index","tag-index-managment","tag-secondary-indexing"],"acf":[],"yoast_head":"\nDatabase Indexing Best Practices & Types of Examples<\/title>\n<meta name=\"description\" content=\"What is database indexing? Couchbase is here to with examples of database index best practices for delivering a high-quality customer experience.\" \/>\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\/database-indexing-best-practices\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Indexing Best Practices\" \/>\n<meta property=\"og:description\" content=\"What is database indexing? Couchbase is here to with examples of database index best practices for delivering a high-quality customer experience.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/database-indexing-best-practices\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-16T08:00:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:23:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/11\/homogenous.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1580\" \/>\n\t<meta property=\"og:image:height\" content=\"366\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Venkat Subramanian, Product Manager\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@venkasub\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Venkat Subramanian, Product Manager\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/\"},\"author\":{\"name\":\"Venkat Subramanian, Product Manager\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/0756e2347c2166a32f93f9a7e07e9f90\"},\"headline\":\"Database Indexing Best Practices\",\"datePublished\":\"2017-11-16T08:00:26+00:00\",\"dateModified\":\"2025-06-14T00:23:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/\"},\"wordCount\":2099,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"keywords\":[\"GSI\",\"Index\",\"index managment\",\"Secondary Indexing\"],\"articleSection\":[\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/\",\"name\":\"Database Indexing Best Practices & Types of Examples\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2017-11-16T08:00:26+00:00\",\"dateModified\":\"2025-06-14T00:23:02+00:00\",\"description\":\"What is database indexing? Couchbase is here to with examples of database index best practices for delivering a high-quality customer experience.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Indexing Best Practices\"}]},{\"@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\/0756e2347c2166a32f93f9a7e07e9f90\",\"name\":\"Venkat Subramanian, Product Manager\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8f9acdf95e167a15007b71867fe87a9a\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/53cfc83eb606325239f7058417a02969ab8ff0106a374bcdcf5d78f9b749cccd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/53cfc83eb606325239f7058417a02969ab8ff0106a374bcdcf5d78f9b749cccd?s=96&d=mm&r=g\",\"caption\":\"Venkat Subramanian, Product Manager\"},\"description\":\"Venkat dabbles in product development and product management and has been developing data\/analytics platforms & products. Significant chunk of his experience has been with Oracle, where he transitioned from being an Engineer in Oracle\u2019s Enterprise Manager team to Product Manager for Oracle's BI\/Analytics suite of products. He has worked in startups in the past helping develop machine-learning\/NLP products and distributed decisioning systems. He lurks around at @venkasub.\",\"sameAs\":[\"https:\/\/x.com\/venkasub\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/venkatcouchbase-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Database Indexing Best Practices & Types of Examples","description":"What is database indexing? Couchbase is here to with examples of database index best practices for delivering a high-quality customer experience.","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\/database-indexing-best-practices\/","og_locale":"ko_KR","og_type":"article","og_title":"Database Indexing Best Practices","og_description":"What is database indexing? Couchbase is here to with examples of database index best practices for delivering a high-quality customer experience.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/database-indexing-best-practices\/","og_site_name":"The Couchbase Blog","article_published_time":"2017-11-16T08:00:26+00:00","article_modified_time":"2025-06-14T00:23:02+00:00","og_image":[{"width":1580,"height":366,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/11\/homogenous.png","type":"image\/png"}],"author":"Venkat Subramanian, Product Manager","twitter_card":"summary_large_image","twitter_creator":"@venkasub","twitter_misc":{"Written by":"Venkat Subramanian, Product Manager","Est. reading time":"12\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/"},"author":{"name":"Venkat Subramanian, Product Manager","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/0756e2347c2166a32f93f9a7e07e9f90"},"headline":"Database Indexing Best Practices","datePublished":"2017-11-16T08:00:26+00:00","dateModified":"2025-06-14T00:23:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/"},"wordCount":2099,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["GSI","Index","index managment","Secondary Indexing"],"articleSection":["Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/","url":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/","name":"Database Indexing Best Practices & Types of Examples","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2017-11-16T08:00:26+00:00","dateModified":"2025-06-14T00:23:02+00:00","description":"What is database indexing? Couchbase is here to with examples of database index best practices for delivering a high-quality customer experience.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/database-indexing-best-practices\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Database Indexing Best Practices"}]},{"@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\/0756e2347c2166a32f93f9a7e07e9f90","name":"\ubca4\uce87 \uc218\ube0c\ub77c\ub9c8\ub2c8\uc548, \uc81c\ud488 \uad00\ub9ac\uc790","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8f9acdf95e167a15007b71867fe87a9a","url":"https:\/\/secure.gravatar.com\/avatar\/53cfc83eb606325239f7058417a02969ab8ff0106a374bcdcf5d78f9b749cccd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/53cfc83eb606325239f7058417a02969ab8ff0106a374bcdcf5d78f9b749cccd?s=96&d=mm&r=g","caption":"Venkat Subramanian, Product Manager"},"description":"\ubca4\uce87\uc740 \uc81c\ud488 \uac1c\ubc1c \ubc0f \uc81c\ud488 \uad00\ub9ac \uc5c5\ubb34\ub97c \ub2f4\ub2f9\ud558\uba70 \ub370\uc774\ud130\/\ubd84\uc11d \ud50c\ub7ab\ud3fc \ubc0f \uc81c\ud488\uc744 \uac1c\ubc1c\ud574 \uc654\uc2b5\ub2c8\ub2e4. \uadf8\uc758 \uacbd\ub825\uc758 \uc0c1\ub2f9 \ubd80\ubd84\uc740 \uc624\ub77c\ud074\uc5d0\uc11c \uc313\uc740 \uac83\uc73c\ub85c, \uc624\ub77c\ud074 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uad00\ub9ac\uc790 \ud300\uc758 \uc5d4\uc9c0\ub2c8\uc5b4\uc5d0\uc11c \uc624\ub77c\ud074\uc758 BI\/\ubd84\uc11d \uc81c\ud488\uad70\uc758 \uc81c\ud488 \uad00\ub9ac\uc790\ub85c \uc804\ud658\ud588\uc2b5\ub2c8\ub2e4. \uacfc\uac70\uc5d0\ub294 \uc2a4\ud0c0\ud2b8\uc5c5\uc5d0\uc11c \uba38\uc2e0\ub7ec\ub2dd\/NLP \uc81c\ud488 \ubc0f \ubd84\uc0b0\ud615 \uc758\uc0ac\uacb0\uc815 \uc2dc\uc2a4\ud15c \uac1c\ubc1c\uc744 \ub3c4\uc654\uc2b5\ub2c8\ub2e4. \uadf8\ub294 @venkasub\uc5d0\uc11c \ud65c\ub3d9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.","sameAs":["https:\/\/x.com\/venkasub"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/venkatcouchbase-com\/"}]}},"authors":[{"term_id":9055,"user_id":3013,"is_guest":0,"slug":"venkatcouchbase-com","display_name":"Venkat Subramanian, Product Manager","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/53cfc83eb606325239f7058417a02969ab8ff0106a374bcdcf5d78f9b749cccd?s=96&d=mm&r=g","first_name":"Venkat","last_name":"Subramanian, Product Manager","user_url":"","author_category":"","description":"\ubca4\uce87\uc740 \uc81c\ud488 \uac1c\ubc1c \ubc0f \uc81c\ud488 \uad00\ub9ac \uc5c5\ubb34\ub97c \ub2f4\ub2f9\ud558\uba70 \ub370\uc774\ud130\/\ubd84\uc11d \ud50c\ub7ab\ud3fc \ubc0f \uc81c\ud488\uc744 \uac1c\ubc1c\ud574 \uc654\uc2b5\ub2c8\ub2e4. \uadf8\uc758 \uacbd\ub825\uc758 \uc0c1\ub2f9 \ubd80\ubd84\uc740 \uc624\ub77c\ud074\uc5d0\uc11c \uc313\uc740 \uac83\uc73c\ub85c, \uc624\ub77c\ud074 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uad00\ub9ac\uc790 \ud300\uc758 \uc5d4\uc9c0\ub2c8\uc5b4\uc5d0\uc11c \uc624\ub77c\ud074\uc758 BI\/\ubd84\uc11d \uc81c\ud488\uad70\uc758 \uc81c\ud488 \uad00\ub9ac\uc790\ub85c \uc804\ud658\ud588\uc2b5\ub2c8\ub2e4. \uacfc\uac70\uc5d0\ub294 \uc2a4\ud0c0\ud2b8\uc5c5\uc5d0\uc11c \uba38\uc2e0\ub7ec\ub2dd\/NLP \uc81c\ud488 \ubc0f \ubd84\uc0b0\ud615 \uc758\uc0ac\uacb0\uc815 \uc2dc\uc2a4\ud15c \uac1c\ubc1c\uc744 \ub3c4\uc654\uc2b5\ub2c8\ub2e4. \uadf8\ub294 @venkasub\uc5d0\uc11c \ud65c\ub3d9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4193","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\/3013"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=4193"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4193\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=4193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=4193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=4193"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=4193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}