{"id":12715,"date":"2022-01-25T13:41:03","date_gmt":"2022-01-25T21:41:03","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=12715"},"modified":"2025-06-13T19:26:34","modified_gmt":"2025-06-14T02:26:34","slug":"analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/","title":{"rendered":"Couchbase 7.0\uc5d0\uc11c \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654\ub97c \uc704\ud55c \ud1b5\uacc4 \ubd84\uc11d\ud558\uae30"},"content":{"rendered":"<p><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/products\/server\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 7.0<\/a> (\uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc5d0\ub514\uc158)\uc5d0\ub294 \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c(CBO)\uac00 \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\uc804 \ubc84\uc804\uc758 Couchbase Server\ub294 RBO(\uaddc\uce59 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c)\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uc8fc\uc694 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c Couchbase Server\ub3c4 \uc790\uc5f0\uc2a4\ub7fd\uac8c RBO\uc5d0\uc11c CBO\ub85c \ubc1c\uc804\ud574 \uc654\uc2b5\ub2c8\ub2e4.<\/p>\n<p>CBO\ub294 \ube44\uc6a9 \uacac\uc801\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\uc5d0\uc11c \uacc4\uc0b0\ub41c \ucffc\ub9ac \uacc4\ud68d\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4. \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\ub294 SQL++ \ucffc\ub9ac(\uc544\ub798\uc5d0\uc11c\ub294 N1QL\uc774\ub77c\uace0 \ud568)\uc5d0\uc11c UPDATE STATISTICS \ub610\ub294 ANALYZE \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc218\uc9d1\ud569\ub2c8\ub2e4.<\/p>\n<h4>\ud1b5\uacc4\/\ubd84\uc11d \ubb38 \uc5c5\ub370\uc774\ud2b8\ud558\uae30<\/h4>\n<p>\uc0c8\ub85c\uc6b4 <em>\ud1b5\uacc4 \uc5c5\ub370\uc774\ud2b8 \ub610\ub294 \ubd84\uc11d<\/em> \ubb38\uc740 CBO \uae30\ub2a5\uc5d0 \ud544\uc694\ud55c \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4 \uc218\uc9d1\uc744 \ud2b8\ub9ac\uac70\ud569\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc790\ub294 \uc774\ub7ec\ud55c \uc0c8\ub85c\uc6b4 \ubb38\uc744 \uc218\ub3d9\uc73c\ub85c \uc2e4\ud589\ud558\uc5ec \ud0a4 \uacf5\uac04\/\uceec\ub809\uc158, \ud0a4 \uacf5\uac04\/\uceec\ub809\uc158\uc5d0 \uc815\uc758\ub41c \uc778\ub371\uc2a4 \ubc0f \uc6a9\uc5b4(\ud45c\ud604\uc2dd) \ubaa9\ub85d\uc758 \ubd84\ud3ec \uc815\ubcf4(\ud788\uc2a4\ud1a0\uadf8\ub7a8)\uc5d0 \ub300\ud55c \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\ub97c \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/p>\n<p>\ucffc\ub9ac \ub178\ub4dc\uac00 \uc5ec\ub7ec \uac1c \uc788\ub294 \uacbd\uc6b0 \ud55c \ucffc\ub9ac \ub178\ub4dc\uc5d0\uc11c \uc218\uc9d1\ud55c \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\ub294 \ubaa8\ub4e0 \ucffc\ub9ac \ub178\ub4dc\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h5><strong>\uc0c8\ub85c\uc6b4 N1QL_SYSTEM_BUCKET<\/strong><\/h5>\n<p>\uc0c8\ub85c\uc6b4 \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \ub2e4\uc74c\uc744 \ud1b5\ud574 \ud1b5\uacc4\ub97c \uc218\uc9d1\ud569\ub2c8\ub2e4. <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0dd\uc131\ud558\uace0 \uc0c8 \ubc84\ud0b7\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4(<em>n1ql_system_\ubc84\ud0b7<\/em>), \ud2b9\ud788 \uc0c8\ub85c\uc6b4 \ubc94\uc704(<em>n1ql_system_scope<\/em>) \ubc0f \uc0c8 \uceec\ub809\uc158(<em>N1QL_CBO_STATS<\/em>).<\/p>\n<p>\ucc98\uc74c \uc2e4\ud589\ud558\uba74 <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \uc774 \uc0c8 \ubc84\ud0b7\/\ubc94\uc704\/\uceec\ub809\uc158\uc774 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ub429\ub2c8\ub2e4. \uae30\ubcf8 \uc778\ub371\uc2a4\ub3c4 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n<p><strong>\uc0c8 \ubc84\ud0b7\/\ubc94\uc704\/\uceec\ub809\uc158 \uc0ad\uc81c\ud558\uae30<\/strong><br \/>\n\uc774\ub7ec\ud55c \uc0c8\ub85c\uc6b4 \uc2dc\uc2a4\ud15c \uac1c\uccb4(\ubc84\ud0b7, \ubc94\uc704, \uceec\ub809\uc158)\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ad\uc81c\ub418\uc5b4 \ubaa8\ub4e0 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\ub97c \ub354 \uc774\uc0c1 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uac8c \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud5a5\ud6c4 \ucffc\ub9ac\ub294 \uc0ac\uc6a9\uc790\uac00 \ud1b5\uacc4\ub97c \ub2e4\uc2dc \ubd84\uc11d\ud558\ub3c4\ub85d \uc694\uccad\ud560 \ub54c\uae4c\uc9c0 CBO \uae30\ub2a5\uc744 \ud65c\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uadf8\ub54c\uae4c\uc9c0\ub294 \ucffc\ub9ac \uacc4\ud68d\uc744 \uc704\ud574 \uc2dc\uc2a4\ud15c\uc774 RBO\ub85c \ub3cc\uc544\uac11\ub2c8\ub2e4.<\/p>\n<p><strong>\uc0c8 \ubc84\ud0b7\/\ubc94\uc704\/\uceec\ub809\uc158\uc5d0 \ub300\ud55c \uba54\ubaa8\ub9ac \ud560\ub2f9\ub7c9<\/strong><br \/>\n\uc0c8\ub85c\uc6b4 \uc2dc\uc2a4\ud15c \ubc84\ud0b7(<em>n1ql_system_\ubc84\ud0b7<\/em>)\ub294 \ucd5c\uc18c 100MB\uc758 \uba54\ubaa8\ub9ac \ud560\ub2f9\ub7c9\uc73c\ub85c \uc0dd\uc131\ub429\ub2c8\ub2e4. \ub300\uaddc\ubaa8 \uc2dc\uc2a4\ud15c\uc5d0\uc11c DBA\ub294 \ubc84\ud0b7\uc758 \uba54\ubaa8\ub9ac \uc794\uc5ec\ub7c9\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud574\uc57c \ud558\uba70, \uba54\ubaa8\ub9ac \uc794\uc5ec\ub7c9\uc774 \uad8c\uc7a5\ub418\ub294 15% \uc218\uc900 \uc774\ud558\ub85c \ub5a8\uc5b4\uc9c0\uc9c0 \uc54a\ub3c4\ub85d \ud544\uc694\ud55c \uacbd\uc6b0 \uba54\ubaa8\ub9ac \ud560\ub2f9\ub7c9\uc744 \ub298\ub824\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<h5>\uad6c\ubb38<\/h5>\n<p>\ud06c\uac8c \ubcf4\uba74 \uc5c5\ub370\uc774\ud2b8 \ud1b5\uacc4\/\ubd84\uc11d \ubb38\uc5d0\ub294 \uc138 \uac00\uc9c0 \uce21\uba74\uc774 \uc788\uc2b5\ub2c8\ub2e4:<br \/>\n<strong>1. \ud0a4 \uc2a4\ud398\uc774\uc2a4\/\uc218\uc9d1 \ud1b5\uacc4<\/strong> - \uc5c5\ub370\uc774\ud2b8\/\ubd84\uc11d \uba85\uc138\uc11c\uac00 \ubc1c\ud589\ub420 \ub54c\ub9c8\ub2e4 \uc218\uc9d1\ub429\ub2c8\ub2e4.<br \/>\n2. <strong>\uc0c9\uc778 \ud1b5\uacc4<\/strong> - \"\uad00\ub828\" \uc778\ub371\uc2a4\ub97c \uc704\ud574 \uc218\uc9d1\ub41c<br \/>\n3. <strong>\ubd84\ud3ec \ud1b5\uacc4(\ud788\uc2a4\ud1a0\uadf8\ub7a8)<\/strong> - \uc9c0\uc815\ub41c \uc870\uac74\uc5d0 \ub530\ub77c \uc218\uc9d1\ub429\ub2c8\ub2e4.<\/p>\n<p>\ubc30\ud3ec \ud1b5\uacc4\uac00 \uc218\uc9d1\ub418\ub294 \uc6a9\uc5b4 \ubaa9\ub85d\uc744 \uc9c0\uc815\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>\ud1b5\uacc4\ub97c \uc791\uc131\ud560 \uc6a9\uc5b4 \ubaa9\ub85d \uc81c\uacf5<\/strong><\/p>\n<pre class=\"\">UPDATE STATISTICS [FOR] keyspace(term1, term2, \u2026)\r\n\r\nANALYZE [KEYSPACE\/COLLECTION] keyspace(term1, term2, \u2026)<\/pre>\n<p>\uc774 \ub450 \ubb38\uc7a5\uc740 \ub3d9\uc77c\ud569\ub2c8\ub2e4. The <em>\ud1b5\uacc4 \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc5d0\ub294 \uc120\ud0dd \uc0ac\ud56d\uc778 FOR \ud0a4\uc6cc\ub4dc \ub4a4\uc5d0 \ud0a4\uc2a4\ud398\uc774\uc2a4 \uc774\ub984\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ud0a4\uc2a4\ud398\uc774\uc2a4 \uc774\ub984 \ub4a4\uc5d0 <em>\ubd84\uc11d<\/em> \ubb38\uc5d0\ub294 \uc120\ud0dd\uc801 <em>\ud0a4\uc2a4\ud398\uc774\uc2a4<\/em> \ub610\ub294 <em>\uceec\ub809\uc158<\/em> \ud0a4\uc6cc\ub4dc \ub4a4\uc5d0 \ud0a4\uc2a4\ud398\uc774\uc2a4 \uc774\ub984\uc744 \ubd99\uc785\ub2c8\ub2e4.<\/p>\n<p>\ud0a4\uc2a4\ud398\uc774\uc2a4 \uc774\ub984\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \uceec\ub809\uc158 \uc774\ub984\uc785\ub2c8\ub2e4. \ubc84\ud0b7 \uc774\ub984\uc744 \ud0a4\uc2a4\ud398\uc774\uc2a4 \uc774\ub984\uc73c\ub85c \uc9c0\uc815\ud560 \uc218 \uc788\uc73c\uba70, \uc774 \uacbd\uc6b0 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\uac00 <em>_\uae30\ubcf8\uac12<\/em> \uceec\ub809\uc158 \uc544\ub798\uc758 <em>_\uae30\ubcf8\uac12<\/em> \ubc84\ud0b7\uc758 \ubc94\uc704\ub97c \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc6a9\uc5b4 \ubaa9\ub85d\uc740 \ub2e4\uc74c\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \ud45c\ud604\uc2dd \ubaa9\ub85d\uacfc \uc720\uc0ac\ud569\ub2c8\ub2e4. <em>\uc778\ub371\uc2a4 \uc0dd\uc131<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc2e4\uc81c\ub85c \uc9c0\uc6d0\ub418\ub294 \ubaa8\ub4e0 \ud45c\ud604\uc2dd\uc740 <em>\uc778\ub371\uc2a4 \uc0dd\uc131<\/em> \uba85\ub839\ubb38\uc740 \ub610\ud55c <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR `travel-sample`.inventory.airport(city, country)\r\n\r\nANALYZE `travel-sample`.inventory.airport(city, country)<\/pre>\n<p>\uc704\uc758 \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0 \ub2e8\uc21c\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em>\ucffc\ub9ac \ucee8\ud14d\uc2a4\ud2b8<\/em> \ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. <em>travel-sample.inventory:<\/em><\/p>\n<pre class=\"\">UPDATE STATISTICS FOR airport(city, country)\r\nANALYZE airport(city, country)<\/pre>\n<p><strong>\uae30\ub2a5 \ud0a4 \ud45c\ud604\uc2dd<\/strong><\/p>\n<p>\ud568\uc218 \uc778\ub371\uc2a4 \ud0a4\ub97c \uc9c0\uc815\ud558\ub294 \uac83\uacfc \uc720\uc0ac\ud558\uac8c <em>\uc778\ub371\uc2a4 \uc0dd\uc131<\/em> \ubb38\uc5d0\uc11c \ud568\uc218 \ud0a4\ub97c \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR airport(lower(country))\r\n\r\nANALYZE airport(lower(country))<\/pre>\n<p><strong>\ubc30\uc5f4 \ud0a4 \ud45c\ud604\uc2dd<\/strong><\/p>\n<p>\ubc30\uc5f4 \uc778\ub371\uc2a4 \ud0a4\ub97c \uc9c0\uc815\ud558\ub294 \uac83\ucc98\ub7fc <em>\uc778\ub371\uc2a4 \uc0dd\uc131<\/em> \ubb38\uc5d0\uc11c \ubc30\uc5f4 \uc778\ub371\uc2a4 \ud0a4\ub97c \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR route(DISTINCT ARRAY v.flight FOR v IN schedule END)\r\n\r\nANALYZE COLLECTION route(DISTINCT ARRAY v.flight FOR v IN schedule END)<\/pre>\n<p>\ub610\ub294 \uc18d\uae30 \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\uc138\uc694:<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR hotel(ALL public_likes)\r\n\r\nANALYZE KEYSPACE hotel(ALL public_likes)<\/pre>\n<p><strong>\ud558\ub098 \uc774\uc0c1\uc758 \uc778\ub371\uc2a4 \ubd84\uc11d<\/strong><\/p>\n<p>\ubd84\uc11d \ubb38\uc740 \uc120\ud0dd\uc801\uc73c\ub85c \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud558\ub098 \uc774\uc0c1\uc758 \uc778\ub371\uc2a4\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em>INDEX<\/em> \uc635\uc158\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR airport INDEX(def_inventory_airport_city, def_inventory_airport_faa)\r\n\r\nANALYZE airport INDEX(def_inventory_airport_city, def_inventory_airport_faa)<\/pre>\n<p>\uc5b8\uc81c <em>INDEX<\/em> \uc635\uc158\uc744 \uc9c0\uc815\ud558\uba74 \ubaa8\ub4e0 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4 \ud0a4 \ud45c\ud604\uc2dd \ubaa9\ub85d\uc774 <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>\ud45c\ud604\uc2dd\uc758 <em>\uc5b4\ub514<\/em> \uc808\ub3c4 \ubd84\uc11d\uc6a9 \uc6a9\uc5b4\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4. \ub530\ub77c\uc11c <em>INDEX<\/em> \uc635\uc158\uc740 \uc0ac\uc6a9\uc790\uac00 \ubaa8\ub4e0 \uc6a9\uc5b4\ub97c \uba85\uc2dc\uc801\uc73c\ub85c \ub098\uc5f4\ud560 \ud544\uc694\uac00 \uc5c6\uc73c\ubbc0\ub85c \ud3b8\ub9ac\ud55c \ubc14\ub85c \uac00\uae30\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc704\uc758 \ubb38\uc740 \uac01 \uc778\ub371\uc2a4\uc5d0 \ud558\ub098\uc758 \uc778\ub371\uc2a4 \ud0a4\ub9cc \uc788\uace0 <em>\uc5b4\ub514<\/em> \uc808\uc744 \ucc38\uc870\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR airport(city, faa)\r\n\r\nANALYZE airport(city, faa)<\/pre>\n<p><strong>\ubaa8\ub4e0 \uc778\ub371\uc2a4 \ubd84\uc11d<\/strong><\/p>\n<p>\ud55c \ub2e8\uacc4 \ub354 \ub098\uc544\uac00 \uceec\ub809\uc158\uc5d0 \uc815\uc758\ub418\uc5b4 \uc788\uace0 \uc628\ub77c\uc778 \uc0c1\ud0dc\uc778 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ubaa8\ub4e0 \uc778\ub371\uc2a4\ub97c \uace0\ub824\ud558\ub294 \uc5c5\ub370\uc774\ud2b8 \ud1b5\uacc4\/\ubd84\uc11d \ubb38\uc5d0 INDEX ALL \uc635\uc158\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR airport INDEX ALL\r\n\r\nANALYZE airport INDEX ALL<\/pre>\n<p>\ub2e4\ub978 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \ubc84\ud0b7 \uc774\ub984\uc774\ub098 \uceec\ub809\uc158 \uc774\ub984\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc9c0\ub9cc <em>\uc778\ub371\uc2a4 \ubaa8\ub450<\/em> \uc635\uc158\uc740 \uceec\ub809\uc158\uc5d0\ub9cc \uc720\ud6a8\ud569\ub2c8\ub2e4. \uc9c0\uc815 <em>\uc778\ub371\uc2a4 \ubaa8\ub450<\/em> \uc744 \ubc84\ud0b7 \uc774\ub984\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud558\uba74 \uc624\ub958\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/p>\n<h5>\uc778\ub371\uc2a4 \ub808\uc9c0\ub358\uc2dc<\/h5>\n<p>\ubd84\uc11d\uc740 \uad00\ub828 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\ub3c4 \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4. \uc6a9\uc5b4 \ubaa9\ub85d\uc774 \uc9c0\uc815\ub418\uba74 \ubaa9\ub85d\uc5d0 \uc788\ub294 \uc6a9\uc5b4\ub97c \ucc38\uc870\ud558\ub294 \uc778\ub371\uc2a4 \ud0a4\ub97c \ud655\uc778\ud558\uc5ec \ud574\ub2f9 \uc778\ub371\uc2a4 \ubaa9\ub85d\uc774 \uad6c\uc131\ub429\ub2c8\ub2e4. \uad00\ub828 \uc778\ub371\uc2a4 \ubaa9\ub85d\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0 \uc778\ub371\uc2a4\uc5d0\uc11c \ucd94\ub860\ub429\ub2c8\ub2e4. <em>INDEX<\/em> \ub610\ub294 <em>\uc778\ub371\uc2a4 \uc54c<\/em>L \uc635\uc158\uc774 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<p>\uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\ub294 \uc778\ub371\uc2a4\uac00 \uc801\uc5b4\ub3c4 \ubd80\ubd84\uc801\uc73c\ub85c \uba54\ubaa8\ub9ac\uc5d0 \uc0c1\uc8fc\ud558\ub294 \uacbd\uc6b0\uc5d0\ub9cc \uc218\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\ub294 \uc778\ub371\uc2a4\uc758 \uba54\ubaa8\ub9ac \uc0c1\uc8fc \ubd80\ubd84\uc5d0\uc11c \uc218\uc9d1\ub429\ub2c8\ub2e4. \uba54\ubaa8\ub9ac \uc0c1\uc8fc \ube44\uc728\uc774 \ub192\uc744\uc218\ub85d \ud574\ub2f9 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\uac00 \ub354 \uc815\ud655\ud574\uc9d1\ub2c8\ub2e4.<\/p>\n<p>\uc778\ub371\uc2a4\uc758 \uba54\ubaa8\ub9ac \uc0c1\uc8fc \ube44\uc728\uc774 0\uc778 \uacbd\uc6b0 \ucd5c\uc801\ud654 \ubb38\uc5d0 \uc758\ud574 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uace0\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4:<\/p>\n<pre class=\"\">\"warnings\": [\r\n{\r\n\"code\": 5390,\r\n\"msg\": \"Index def_inventory_airport_city is not in memory\"\r\n}\r\n],<\/pre>\n<h5>\uc120\ud0dd\uc801 WITH \uc808<\/h5>\n<p>\uc720\uc0ac\ud558\uac8c <em>\uc778\ub371\uc2a4 \uc0dd\uc131<\/em> \ubb38\uc744 \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <em>WITH<\/em> \uc808\uc744 \ucd94\uac00\ud558\uc5ec \ud1b5\uacc4 \ubd84\uc11d \uc635\uc158\uc744 \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR airport(city, country) WITH {\"resolution\": 0.5}\r\n\r\nANALYZE airport(city, country) WITH {\"resolution\": 0.5}<\/pre>\n<p>\ud604\uc7ac \uc9c0\uc6d0\ub418\ub294 \uc635\uc158\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <em>WITH<\/em> \uc870\ud56d\uc758 <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4: <em>\ud574\uc0c1\ub3c4, \uc0d8\ud50c \ud06c\uae30, \ubc30\uce58 \ud06c\uae30, \uc5c5\ub370\uc774\ud2b8_\ud1b5\uacc4_\ud0c0\uc784\uc544\uc6c3<\/em>. \uc544\ub798\uc5d0\uc11c \uac01\uac01\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n<p><strong>\ud574\uc0c1\ub3c4 \uc635\uc158<\/strong><\/p>\n<p>\uc6a9\uc5b4\uc758 \ubd84\ud3ec \ud1b5\uacc4(\ud788\uc2a4\ud1a0\uadf8\ub7a8)\ub294 \uc77c\ub828\uc758 '\uad6c\uac04\ucc28\uc6d0'\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ud574\uc0c1\ub3c4\ub294 \uac01 \uad6c\uac04\ucc28\uc6d0\uc5d0 \ud45c\uc2dc\ub418\ub294 \ubb38\uc11c\uc758 \ube44\uc728\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c 1.0(\uc989, 100\uac1c\uc758 \uad6c\uac04\ucc28\uc6d0)\uc758 \ud574\uc0c1\ub3c4\uac00 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<p>WITH \uc808\uc5d0 \ub2e4\ub978 \ud574\uc0c1\ub3c4\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub354 \uc138\ubd84\ud654\ub41c \ubd84\ud3ec \ud1b5\uacc4\uac00 \ud544\uc694\ud55c \uacbd\uc6b0 \ub354 \uc791\uc740 \ud574\uc0c1\ub3c4(\ub354 \ub9ce\uc740 \uc218\uc758 \uad6c\uac04\ucc28\uc6d0\uc5d0 \ud574\ub2f9)\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud574\uc0c1\ub3c4\uac00 \uc791\uc744\uc218\ub85d(\ube48 \uc218\uac00 \ub9ce\uc744\uc218\ub85d) \ud788\uc2a4\ud1a0\uadf8\ub7a8\uc744 \uad6c\uc131\ud558\ub294 \ub370 \ub354 \ub9ce\uc740 \uc0d8\ud50c\uc774 \ud544\uc694\ud558\uba70, \ud788\uc2a4\ud1a0\uadf8\ub7a8\uc744 \uc644\uc131\ud558\ub294 \ub370 \ub354 \ub9ce\uc740 \uc2dc\uac04\/\ub9ac\uc18c\uc2a4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>\ud574\uc0c1\ub3c4 \uc635\uc158\uc758 \uc720\ud6a8\ud55c \ubc94\uc704\ub294 0.02 - 5.0\uc785\ub2c8\ub2e4.<\/p>\n<p><strong>sample_size \uc635\uc158<\/strong><\/p>\n<p>\uc5d0 \uc9c0\uc815\ub41c \uc6a9\uc5b4\uc5d0 \ub300\ud55c \ubd84\ud3ec \ud1b5\uacc4(\ud788\uc2a4\ud1a0\uadf8\ub7a8)\ub97c \uad6c\uc131\ud558\ub824\uba74 \uc0d8\ud50c\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4. \ud574\uc0c1\ub3c4\uc5d0 \ub530\ub77c \uc0d8\ud50c \ud06c\uae30\uac00 \uacb0\uc815\ub418\uba70 \uceec\ub809\uc158\uc758 \ubb38\uc11c \uc218\uc640\ub294 \uc9c1\uc811\uc801\uc778 \uad00\ub828\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc0ac\uc6a9\ud560 \uc0d8\ud50c \ud06c\uae30\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc9c0\uc815\ub41c \ud574\uc0c1\ub3c4\uc5d0\ub294 \ucd5c\uc18c \uc0d8\ud50c \ud06c\uae30\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \uc0d8\ud50c \ud06c\uae30\uac00 \ucd5c\uc18c \ud544\uc218 \uc0d8\ud50c \ud06c\uae30\ubcf4\ub2e4 \uc791\uc73c\uba74 \ucd5c\uc18c \ud544\uc218 \uc0d8\ud50c \ud06c\uae30\uac00 \ub300\uc2e0 \uc0ac\uc6a9\ub418\uba70 \uacbd\uace0\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/p>\n<p><strong>batch_size \uc635\uc158<\/strong><\/p>\n<p>\ud788\uc2a4\ud1a0\uadf8\ub7a8\uc744 \ub9cc\ub4e4\ub824\uba74 \uc815\ub82c \uc791\uc5c5\uc774 \ud544\uc694\ud558\ubbc0\ub85c \ub9ac\uc18c\uc2a4\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uacfc\ub3c4\ud55c \ub9ac\uc18c\uc2a4 \uc0ac\uc6a9\uc744 \ud53c\ud558\uae30 \uc704\ud574 \ud788\uc2a4\ud1a0\uadf8\ub7a8\uc740 \uc77c\uad04\uc801\uc73c\ub85c \uad6c\ucd95\ub429\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c \uac01 \ubc30\uce58\ub294 \ud788\uc2a4\ud1a0\uadf8\ub7a8 \uad6c\uc131\uc744 \uc704\ud574 \ucd5c\ub300 10\uac1c\uc758 \uc6a9\uc5b4\ub97c \ucc98\ub9ac\ud569\ub2c8\ub2e4. \ub354 \ub9ce\uc740 \uc6a9\uc5b4\uac00 \ub098\uc5f4\ub418\uac70\ub098 \uc778\ub371\uc2a4 \ud0a4 \ud45c\ud604\uc2dd(\uc778\ub371\uc2a4 \uc635\uc158\uc73c\ub85c \uc9c0\uc815\ub41c \uc778\ub371\uc2a4\uc5d0\uc11c)\uc758 \uc870\ud569\uc774 10\uac1c \uc6a9\uc5b4\ub97c \ucd08\uacfc\ud558\ub294 \uacbd\uc6b0 \ubaa8\ub4e0 \uc6a9\uc5b4\ub97c \ucc98\ub9ac\ud558\ub824\uba74 \uc5ec\ub7ec \uac1c\uc758 \ubc30\uce58\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em>\ubc30\uce58 \ud06c\uae30<\/em> \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc5ec \uac01 \ubc30\uce58\uc5d0\uc11c \ucc98\ub9ac\ud560 \uc6a9\uc5b4 \uc218\ub97c \uc11c\ubc84\uc5d0 \uc54c\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc2dc\uc2a4\ud15c\uc774 \uc0ac\uc6a9 \uc911\uc774\uc9c0 \uc54a\uace0 \ucef4\ud4e8\ud305 \ub9ac\uc18c\uc2a4\ub97c \ucda9\ubd84\ud788 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uacbd\uc6b0 \uc0ac\uc6a9\uc790\ub294 \ub354 \ud070 \ubc30\uce58 \ud06c\uae30\ub97c \uc694\uccad\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\uba74\uc5d0 \uc2dc\uc2a4\ud15c\uc774 \uc774\ubbf8 \uacfc\ubd80\ud558 \uc0c1\ud0dc\ub77c\uba74 \ub354 \uc791\uc740 \ubc30\uce58 \ud06c\uae30\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ub9ac\uc18c\uc2a4 \uc0ac\uc6a9\ub7c9\uacfc \ubd84\uc11d \ubb38 \uc9c0\uc18d \uc2dc\uac04 \uac04\uc758 \uade0\ud615\uc785\ub2c8\ub2e4.<\/p>\n<p><strong>\uc5c5\ub370\uc774\ud2b8_\ud1b5\uacc4_\ud0c0\uc784\uc544\uc6c3 \uc635\uc158<\/strong><\/p>\n<p>\uadf8\ub9ac\uace0 <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc740 \uc720\uc9c0 \uad00\ub9ac \uc791\uc5c5\uc774\uba70 \ud2b9\ud788 \uc5ec\ub7ec \uac1c\uc758 \ubc30\uce58\uac00 \ud544\uc694\ud55c \uacbd\uc6b0 \uc751\ub2f5 \uc2dc\uac04\uc774 \ub2e8\uc21c \ucffc\ub9ac\ubcf4\ub2e4 \ud6e8\uc52c \ub354 \uae38\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uae30\ubcf8\uc801\uc73c\ub85c 60\ucd08\uc758 \uc2dc\uac04 \uc81c\ud55c \uac12\uc774 \uc5c5\ub370\uc774\ud2b8\/\ubd84\uc11d \ubb38\uc5d0 \uc801\uc6a9\ub429\ub2c8\ub2e4. \uc2dc\uac04 \uc81c\ud55c \uac12\uc5d0 \uc120\ud0dd\uc801 \uac12(\ucd08 \ub2e8\uc704)\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\ub7ec \ubc30\uce58\uac00 \ud544\uc694\ud55c \uacbd\uc6b0 \uc2dc\uac04 \ucd08\uacfc \uac12\uc740 \uac01 \ubc30\uce58\uc5d0 \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<h5>\uc0ad\uc81c \uc808<\/h5>\n<p>\uc0ac\uc6a9\uc790\ub294 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud604\uc7ac \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\ub97c \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em>\uc0ad\uc81c<\/em> \uc808\uc744 \uc5c5\ub370\uc774\ud2b8\/\ubd84\uc11d \ubb38\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud558\uc138\uc694. \uc774 \uc808\uc740 \ucffc\ub9ac \ub610\ub294 \ucffc\ub9ac \uc9d1\ud569\uc5d0 \ub300\ud574 CBO\ub97c \uc120\ud0dd\uc801\uc73c\ub85c \ube44\ud65c\uc131\ud654\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc9c0\uc815\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 \uba87 \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. <em>\uc0ad\uc81c<\/em> \uc635\uc158 - \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\ub97c \uc0ad\uc81c\ud560 \uc6a9\uc5b4 \ubaa9\ub85d\uc744 \uc9c0\uc815\ud558\uac70\ub098 \ud0a4\uc2a4\ud398\uc774\uc2a4\/\uceec\ub809\uc158\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\ub97c \uc0ad\uc81c\ud558\ub3c4\ub85d \uc694\uccad\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc6a9\uc5b4 \ubaa9\ub85d\uc774 \ud3ec\ud568\ub41c \uc0ad\uc81c \uc808<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR airport DELETE (city, country)\r\n\r\nANALYZE COLLECTION airport DELETE STATISTICS(city, country)<\/pre>\n<p>\uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac\uc5d0\uc11c \uc9c0\uc815\ub41c \uc6a9\uc5b4\uc5d0 \ub300\ud55c \ubc30\ud3ec \ud1b5\uacc4\ub9cc \uc0ad\uc81c\ub429\ub2c8\ub2e4. \ud0a4 \uc2a4\ud398\uc774\uc2a4 \ubc0f \uc778\ub371\uc2a4 \ud1b5\uacc4\uc640 \uac19\uc740 \ub2e4\ub978 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\ub294 \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac\uc5d0 '\uacf5\ud56d' \uceec\ub809\uc158\uc758 '\ub3c4\uc2dc' \ub610\ub294 '\uad6d\uac00' \ud544\ub4dc\uc5d0 \uc220\uc5b4\uac00 \uc788\ub294 \uacbd\uc6b0 \ud574\ub2f9 \ucffc\ub9ac\uc5d0 \ub300\ud574 CBO\uac00 \ube44\ud65c\uc131\ud654\ub429\ub2c8\ub2e4.<\/p>\n<p>\ud0a4\uc2a4\ud398\uc774\uc2a4\/\uceec\ub809\uc158\uc758 \ubaa8\ub4e0 \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\uc5d0 \ub300\ud55c \uc0ad\uc81c \uc808<\/p>\n<pre class=\"\">UPDATE STATISTICS FOR airport DELETE ALL\r\n\r\nANALYZE KEYSPACE airport DELETE STATISTICS<\/pre>\n<p>\uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \ud0a4 \uacf5\uac04 \ud1b5\uacc4, \uc778\ub371\uc2a4 \ud1b5\uacc4, \ubc30\ud3ec \ud1b5\uacc4\ub97c \ud3ec\ud568\ud558\uc5ec \"airport\" \uceec\ub809\uc158\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\uac00 \uc0ad\uc81c\ub429\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 \"airport\" \uceec\ub809\uc158\uc744 \ucc38\uc870\ud558\ub294 \ubaa8\ub4e0 \ucffc\ub9ac\uc5d0\ub294 CBO\uac00 \ube44\ud65c\uc131\ud654\ub429\ub2c8\ub2e4.<\/p>\n<h5>\uc5b4\ub5a4 \ud544\ub4dc\/\ud45c\ud604\uc2dd\uc744 \ubd84\uc11d\ud560\uae4c\uc694?<\/h5>\n<p>\uc5b4\ub5a4 \ud544\ub4dc\/\ud45c\ud604\uc2dd\uc744 \ud3ec\ud568\ud560\uc9c0 \uc5b4\ub5bb\uac8c \uc54c \uc218 \uc788\ub098\uc694? <em>\ud1b5\uacc4\/\ubd84\uc11d \uc5c5\ub370\uc774\ud2b8<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud574\uc57c \ud558\ub098\uc694? \uc77c\ubc18\uc801\uc73c\ub85c \ucffc\ub9ac\uc5d0\uc11c \ucc38\uc870\ub418\ub294 \ubaa8\ub4e0 \ud45c\ud604\uc2dd(\ud22c\uc601 \uc808\uc5d0 \uc788\ub294 \ud45c\ud604\uc2dd\ub9cc \uc81c\uc678)\uc5d0\ub294 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p>WHERE, ON, GROUP BY, ORDER BY \uc808<\/p>\n<p>\uc5d0 \ucc38\uc870\ub41c \ud45c\ud604\uc2dd <em>\uc5b4\ub514\uc11c, \ucf1c\uae30, \uadf8\ub8f9\ud654 \uae30\uc900<\/em> \uadf8\ub9ac\uace0 <em>\uc8fc\ubb38 \uae30\uc900<\/em> \uc808\uc5d0\ub294 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<pre class=\"\">SELECT a.airportname, r.airline\r\nFROM airport a JOIN route r ON a.faa = r.sourceairport\r\nWHERE a.city = \"San Francisco\"\r\nORDER BY a.airportname;<\/pre>\n<p>\uc774 \ucffc\ub9ac\uc758 \uacbd\uc6b0 \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">airport(faa, city, airportname)\r\nroute(sourceairport)<\/pre>\n<p>\ub354 \ubcf5\uc7a1\ud55c \ud45c\ud604\uc2dd\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0:<\/p>\n<pre class=\"\">SELECT *\r\nFROM airport\r\nWHERE lower(country) = \"us\";<\/pre>\n<p>\uc774 \ucffc\ub9ac\uc758 \uacbd\uc6b0 \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">airport(lower(country))<\/pre>\n<p><strong>\ubc30\uc5f4 \uc778\ub371\uc2a4 \ud45c\ud604\uc2dd<\/strong><\/p>\n<p>For <em>ANY<\/em> \ub610\ub294 <em>\ub204\uad6c\uc5d0\uac8c\ub098<\/em> \uc808\uc5d0\uc11c \ubc30\uc5f4 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \ud574\ub2f9 \ubc30\uc5f4 \uc778\ub371\uc2a4 \ud0a4 \ud45c\ud604\uc2dd\uc5d0 \ub300\ud55c \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<pre class=\"\">SELECT *\r\nFROM route\r\nWHERE ANY v IN schedule SATISFIES v.flight = \"FL121\" END;<\/pre>\n<p>\uc774 \ucffc\ub9ac\uc758 \uacbd\uc6b0 \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">route(DISTINCT ARRAY v.flight FOR v IN schedule END)<\/pre>\n<p>\uc0ac\uc6a9\ub41c \ud45c\ud604\uc2dd\uc740 \ud574\ub2f9 \ubc30\uc5f4 \uc778\ub371\uc2a4 \uc815\uc758\uc758 \ubc30\uc5f4 \uc778\ub371\uc2a4 \ud0a4 \ud45c\ud604\uc2dd\uacfc \ub3d9\uc77c\ud558\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud558\uc138\uc694.<\/p>\n<p>\uc758 \uacbd\uc6b0 <em>UNNEST<\/em> \uc791\ub3d9\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">SELECT r.destinationairport\r\nFROM route r UNNEST r.schedule AS s\r\nWHERE s.flight = \"FL121\";<\/pre>\n<p>\uc774 \ucffc\ub9ac\uc758 \uacbd\uc6b0 \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">route(ALL ARRAY v.flight FOR v IN schedule END)<\/pre>\n<p>\ub2e4\uc2dc \ub9d0\ud558\uc9c0\ub9cc, \uc0ac\uc6a9\ub41c \ud45c\ud604\uc2dd\uc740 \ud574\ub2f9 \ubc30\uc5f4 \uc778\ub371\uc2a4 \uc815\uc758\uc5d0 \ub300\ud55c \ubc30\uc5f4 \uc778\ub371\uc2a4 \ud0a4 \ud45c\ud604\uc2dd\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/p>\n<p><strong>\ud558\uc704 \ucffc\ub9ac \ubc0f CTE(\uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd)<\/strong><\/p>\n<p>\ud558\uc704 \ucffc\ub9ac \ub610\ub294 CTE\uac00 \ud3ec\ud568\ub41c \ucffc\ub9ac\uc758 \uacbd\uc6b0, \ud558\uc704 \ucffc\ub9ac \ub610\ub294 CTE\uc758 \ucffc\ub9ac \ube14\ub85d\uc744 \ud655\uc778\ud558\uc5ec \uc5b4\ub5a4 \ud45c\ud604\uc2dd\uc5d0 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\uac00 \ud544\uc694\ud55c\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">WITH usairport AS (SELECT airportname, faa\r\nFROM airport\r\nWHERE lower(country) = \"us\")\r\nSELECT * FROM usairport;<\/pre>\n<p>CTE\ub97c \uc815\uc758\ud558\ub294 \ucffc\ub9ac \ube14\ub85d\uc744 \ubcf4\uba74 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">airport(lower(country))<\/pre>\n<p><strong>\ucc3d \uae30\ub2a5<\/strong><\/p>\n<p>\ucc3d \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 PARTITION BY \ubc0f ORDER BY \uc808\uc5d0 \uc0ac\uc6a9\ub41c \ud45c\ud604\uc2dd\uc5d0 \ub300\ud55c \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">SELECT COUNT(1) OVER (PARTITION BY country)\r\nFROM airline;<\/pre>\n<p>\uc774 \ucffc\ub9ac\uc758 \uacbd\uc6b0 \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"\">airline(country)<\/pre>\n<h5><span style=\"font-weight: 400\">\ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4 \ubcf4\uae30<\/span><\/h5>\n<p>\uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\ub97c \uc704\ud574 \uc0c8\ub85c \ub3c4\uc785\ub41c \uc2dc\uc2a4\ud15c \ud0a4 \uacf5\uac04\uc740 \uc2dc\uc2a4\ud15c:\uc0ac\uc804\uacfc \uc2dc\uc2a4\ud15c:\uc0ac\uc804_\uce90\uc2dc \ub450 \uac00\uc9c0\uc785\ub2c8\ub2e4. \uccab \ubc88\uc9f8\ub294 \ub2e4\uc74c\uc5d0 \uc800\uc7a5\ub41c \uc628\ub514\uc2a4\ud06c \ubb38\uc11c\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4. <em>n1ql_system_bucket.n1ql_system_scope.n1ql_cbo_stats,<\/em> \uc2dc\uc2a4\ud15c:\uc0ac\uc804_\uce90\uc2dc\ub294 \ub3d9\uc77c\ud55c \uc815\ubcf4\uc758 \ud558\uc704 \uc9d1\ud569\uc5d0 \ub300\ud55c \uc778\uba54\ubaa8\ub9ac \uce90\uc2dc \ud45c\ud604\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc0ac\uc804 \uce90\uc2dc\ub294 \ucffc\ub9ac \ub178\ub4dc\uac00 \uc2dc\uc791\ub420 \ub54c \ucd08\uae30\ud654\ub418\uba70 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \ub54c \uce90\uc2dc \uc815\ubcf4\uac00 \ucc44\uc6cc\uc9d1\ub2c8\ub2e4. \ub2e4\uc74c\uc5d0\uc11c \uac80\uc0c9\ub41c \ub370\uc774\ud130\ub294 <em>\uc2dc\uc2a4\ud15c:\uc0ac\uc804<\/em> \ub294 \uc5ec\ub7ec \ucffc\ub9ac \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud560 \ub54c \uc5b4\ub5a4 \ucffc\ub9ac \ub178\ub4dc\uac00 \uc815\ubcf4\ub97c \uac00\uc838\uc624\ub294\uc9c0\uc5d0 \uad00\uacc4\uc5c6\uc774 \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub7ec\ub098 \uba40\ud2f0\ub178\ub4dc \ud074\ub7ec\uc2a4\ud130\uc758 \ubaa8\ub4e0 \ucffc\ub9ac \ub178\ub4dc\uc5d0\uc11c \uce90\uc2dc\ub41c \uc815\ubcf4\ub294 <em>\uc2dc\uc2a4\ud15c:\uc0ac\uc804_\uce90\uc2dc,<\/em> \uac01 \ub178\ub4dc\ub294 \uc7a0\uc7ac\uc801\uc73c\ub85c \uce90\uc2dc\ub41c \uc815\ubcf4\uc758 \ub2e4\ub978 \ud558\uc704 \uc9d1\ud569\uc744 \uac00\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 \ucffc\ub9ac\ub294 \uc2dc\uc2a4\ud15c:\uc0ac\uc804\uc758 \ud1b5\uacc4\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4:<\/p>\n<pre class=\"\">SELECT * FROM system:dictionary\r\nWHERE `bucket` = \"travel-sample\" AND `scope` = \"inventory\"\r\nAND `keyspace` = \"airport\";<\/pre>\n<p>\ucffc\ub9ac \uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<pre class=\"\">{\r\n\"dictionary\": {\r\n\"avgDocKeySize\": 12,\r\n\"avgDocSize\": 278,\r\n\"bucket\": \"travel-sample\",\r\n\"distributionKeys\": [\r\n\"country\",\r\n\"lower(country)\"\r\n],\r\n\"docCount\": 1968,\r\n\"indexes\": [\r\n{\r\n\"indexId\": \"4978a27d62bc592a\",\r\n\"indexName\": \"def_inventory_airport_primary\",\r\n\"indexStats\": [\r\n{\r\n\"avgItemSize\": 23,\r\n\"avgPageSize\": 7202,\r\n\"numItems\": 1968,\r\n\"numPages\": 6,\r\n\"resRatio\": 1\r\n}\r\n]\r\n},\r\n{\r\n\"indexId\": \"c5071b3ac2730bff\",\r\n\"indexName\": \"def_inventory_airport_faa\",\r\n\"indexStats\": [\r\n{\r\n\"avgItemSize\": 32,\r\n\"avgPageSize\": 9394,\r\n\"numItems\": 1968,\r\n\"numPages\": 7,\r\n\"resRatio\": 1\r\n}\r\n]\r\n},\r\n{\r\n\"indexId\": \"e260327a9933350e\",\r\n\"indexName\": \"def_inventory_airport_city\",\r\n\"indexStats\": [\r\n{\r\n\"avgItemSize\": 39,\r\n\"avgPageSize\": 11410,\r\n\"numItems\": 1968,\r\n\"numPages\": 7,\r\n\"resRatio\": 1\r\n}\r\n]\r\n}\r\n],\r\n\"keyspace\": \"airport\",\r\n\"namespace\": \"default\",\r\n\"scope\": \"inventory\"\r\n}\r\n}<\/pre>\n<p>\uac01 \ud56d\ubaa9\uc5d0\ub294 \ud0a4 \uacf5\uac04\uc5d0 \ub300\ud55c \uae30\ubcf8 \uc815\ubcf4, \ud0a4 \uacf5\uac04\uc758 \ubc30\uc5f4 <em>\ubc30\ud3ec \ud0a4<\/em> \ud788\uc2a4\ud1a0\uadf8\ub7a8\uacfc \uc778\ub371\uc2a4 \uc815\ubcf4 \ubc30\uc5f4\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\ucc2c\uac00\uc9c0\ub85c \uc2dc\uc2a4\ud15c:\uc0ac\uc804_\uce90\uc2dc\ub97c \ucffc\ub9ac\ud560 \ub54c\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\uc785\ub2c8\ub2e4:<\/p>\n<pre class=\"\">SELECT * FROM system:dictionary_cache\r\nWHERE `bucket` = \"travel-sample\" AND `scope` = \"inventory\"\r\nAND `keyspace` = \"airport\";<\/pre>\n<p>\uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <em>\uc2dc\uc2a4\ud15c:\uc0ac\uc804<\/em> \ucffc\ub9ac\uc5d0\uc11c \ub2e4\ub978 \ucffc\ub9ac \ub178\ub4dc\uc758 \ud56d\ubaa9\uc744 \ud45c\uc2dc\ud558\ub294 \ucd94\uac00 \ub178\ub4dc \ud544\ub4dc\ub97c \uc81c\uc678\ud569\ub2c8\ub2e4.<\/p>\n<h5>\ucd5c\uc801\ud654_\ucd94\uc815\uac12\uc73c\ub85c \ucd9c\ub825 \uc124\uba85\ud558\uae30<\/h5>\n<p>\uc801\uc808\ud55c \uc635\ud2f0\ub9c8\uc774\uc800 \ud1b5\uacc4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uacbd\uc6b0 EXPLAIN \ucd9c\ub825\uc5d0 \uac01 \uc5f0\uc0b0\uc790\uc5d0 \ub300\ud55c \uc0c8\ub85c\uc6b4 optimizer_estimates \uc139\uc158\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\ub294 \uc774 \uc5f0\uc0b0\uc790 \ubc0f \ubaa8\ub4e0 \ud558\uc704 \uc5f0\uc0b0\uc790\uc758 \ube44\uc6a9 \uc815\ubcf4\uc5d0 \ub300\ud55c \ucd5c\uc801\ud654 \ub3c4\uad6c\uc758 \ucd94\uc815\uce58\uac00 \ubc18\uc601\ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<pre class=\"\">EXPLAIN SELECT * FROM airport WHERE city = \"San Francisco\";<\/pre>\n<p>\ub2e4\uc74c \ucd9c\ub825\uc740 IndexScan3 \uc5f0\uc0b0\uc790\uc5d0 \ub300\ud55c \ucd9c\ub825\uc785\ub2c8\ub2e4:<\/p>\n<pre class=\"\">{\r\n\"#operator\": \"IndexScan3\",\r\n\"index\": \"airpot_city_country\",\r\n\u2026\u2026\r\n\"optimizer_estimates\": {\r\n\"cardinality\": 1.1764705882352944,\r\n\"cost\": 12.212415941159103,\r\n\"fr_cost\": 12.180553549985238,\r\n\"size\": 12\r\n},\r\n\"spans\": [\r\n\u2026\u2026\r\n],\r\n\u2026\u2026\r\n},<\/pre>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 <em>optimizer_estimates<\/em> \uc139\uc158\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ucffc\ub9ac \uacc4\ud68d \ud504\ub85c\uc138\uc2a4\uc758 \uc774 \ub2e8\uacc4\uc5d0\uc11c CBO\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/p>\n<h4>\uc694\uc57d<\/h4>\n<p>\ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c(CBO)\uc758 \ucd94\uac00\ub294 \ub9ce\uc740 \uae30\ub2a5 \uc911 \ud558\ub098\uc5d0 \ubd88\uacfc\ud558\uc9c0\ub9cc, \ud601\uc2e0\uc801\uc778 \uc0c8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ub2a5\uc744 Couchbase 7.0\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c\uc5d0 \ud45c\uc2dc\ub41c \uc5c5\ub370\uc774\ud2b8\/\ubd84\uc11d \ucffc\ub9ac\ub294 CBO\uac00 \ud6a8\uc728\uc801\uc73c\ub85c \uc791\ub3d9\ud558\ub294 \ub370 \ud544\uc694\ud55c \ud1b5\uacc4\ub97c \uc218\uc9d1\ud558\ub294 \ub370 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc815\ud655\ud55c \ucd5c\uc801\ud654 \ub3c4\uad6c \ud1b5\uacc4\ub97c \uc218\uc9d1\ud558\uba74 EXPLAIN \ucd9c\ub825\uc5d0 CBO\uac00 \ucffc\ub9ac \uacc4\ud68d\uc744 \uc120\ud0dd\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc608\uc0c1\uce58\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc774\ub294 \ud5a5\ud6c4 \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc774\uace0 \uc608\uce21 \uac00\ub2a5\ud55c \ucffc\ub9ac \uc0dd\uc131\uc744 \uc548\ub0b4\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">CBO\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/cost-based-optimizer.html\"><span style=\"font-weight: 400\">Couchbase \ubb38\uc11c<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc790\uc138\ud788 \uc54c\uc544\ubcf4\uae30 <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/introduction\/whats-new.html\"><span style=\"font-weight: 400\">Couchbase 7 \ub9b4\ub9ac\uc2a4 \ubc0f \uc0c8\ub85c\uc6b4 \uae30\ub2a5<\/span><\/a><\/li>\n<li style=\"font-weight: 400\">JSON\uc6a9 SQL\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694: <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/query.html\">SQL++ \ucffc\ub9ac \uc5b8\uc5b4<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Couchbase Server 7.0 (Enterprise Edition) introduced a Cost-Based Optimizer (CBO). Previous versions of Couchbase Server used a Rule-Based Optimizer (RBO). Couchbase Server has naturally evolved from RBO to CBO like most major relational database systems. The CBO uses cost estimates [&hellip;]<\/p>","protected":false},"author":3021,"featured_media":12716,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[2294,1816,1812],"tags":[8562,8907,1261],"ppma_author":[9065],"class_list":["post-12715","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-couchbase-server","category-n1ql-query","tag-cost-based-optimization","tag-couchbase-server-7-0","tag-json"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0 - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"In this blog post you will learn how to analyzeStatistics for Cost-Based Optimization in Couchbase Server 7.0\" \/>\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\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0\" \/>\n<meta property=\"og:description\" content=\"In this blog post you will learn how to analyzeStatistics for Cost-Based Optimization in Couchbase Server 7.0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-25T21:41:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T02:26:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1829\" \/>\n\t<meta property=\"og:image:height\" content=\"2560\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bingjie Miao, Principal Software Engineer Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bingjie Miao, Principal Software Engineer Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/\"},\"author\":{\"name\":\"Bingjie Miao, Senior Software Engineer, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3a65595a167e56276aec1f708072c2e6\"},\"headline\":\"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0\",\"datePublished\":\"2022-01-25T21:41:03+00:00\",\"dateModified\":\"2025-06-14T02:26:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/\"},\"wordCount\":2146,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg\",\"keywords\":[\"Cost Based Optimization\",\"Couchbase Server 7.0\",\"JSON\"],\"articleSection\":[\"Couchbase Analytics\",\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/\",\"name\":\"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0 - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg\",\"datePublished\":\"2022-01-25T21:41:03+00:00\",\"dateModified\":\"2025-06-14T02:26:34+00:00\",\"description\":\"In this blog post you will learn how to analyzeStatistics for Cost-Based Optimization in Couchbase Server 7.0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg\",\"width\":1829,\"height\":2560,\"caption\":\"Guide to Vector Search\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0\"}]},{\"@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\/3a65595a167e56276aec1f708072c2e6\",\"name\":\"Bingjie Miao, Senior Software Engineer, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8834c93ec327fc373f7cf1896138b95b\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d0ea9ddc7d74a893baf9227b26296cccf1eed2fc94c0c94e7fb04485b7251025?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d0ea9ddc7d74a893baf9227b26296cccf1eed2fc94c0c94e7fb04485b7251025?s=96&d=mm&r=g\",\"caption\":\"Bingjie Miao, Senior Software Engineer, Couchbase\"},\"description\":\"Bingjie Miao is a principal software engineer at Couchbase. Bingjie has 20 years of experience in relational and NoSQL databases. His main area of expertise is query optimization and query execution.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/bingjie-miaocouchbase-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0 - The Couchbase Blog","description":"\uc774 \ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 \ubd84\uc11d \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubd05\ub2c8\ub2e4Couchbase Server 7.0\uc758 \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654\ub97c \uc704\ud55c \ud1b5\uacc4","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\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/","og_locale":"ko_KR","og_type":"article","og_title":"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0","og_description":"In this blog post you will learn how to analyzeStatistics for Cost-Based Optimization in Couchbase Server 7.0","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/","og_site_name":"The Couchbase Blog","article_published_time":"2022-01-25T21:41:03+00:00","article_modified_time":"2025-06-14T02:26:34+00:00","og_image":[{"width":1829,"height":2560,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg","type":"image\/jpeg"}],"author":"Bingjie Miao, Principal Software Engineer Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bingjie Miao, Principal Software Engineer Couchbase","Est. reading time":"11\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/"},"author":{"name":"Bingjie Miao, Senior Software Engineer, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3a65595a167e56276aec1f708072c2e6"},"headline":"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0","datePublished":"2022-01-25T21:41:03+00:00","dateModified":"2025-06-14T02:26:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/"},"wordCount":2146,"commentCount":2,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg","keywords":["Cost Based Optimization","Couchbase Server 7.0","JSON"],"articleSection":["Couchbase Analytics","Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/","url":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/","name":"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0 - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg","datePublished":"2022-01-25T21:41:03+00:00","dateModified":"2025-06-14T02:26:34+00:00","description":"\uc774 \ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 \ubd84\uc11d \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubd05\ub2c8\ub2e4Couchbase Server 7.0\uc758 \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654\ub97c \uc704\ud55c \ud1b5\uacc4","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/01\/alex-rodriguez-santibanez-AIvKJfwMcd8-unsplash-scaled.jpg","width":1829,"height":2560,"caption":"Guide to Vector Search"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/analyzing-statistics-for-cost-based-optimization-in-couchbase-7-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0"}]},{"@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\/3a65595a167e56276aec1f708072c2e6","name":"\ube59\uc9c0\uc5d0 \ubbf8\uc544\uc624, \uc218\uc11d \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8834c93ec327fc373f7cf1896138b95b","url":"https:\/\/secure.gravatar.com\/avatar\/d0ea9ddc7d74a893baf9227b26296cccf1eed2fc94c0c94e7fb04485b7251025?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d0ea9ddc7d74a893baf9227b26296cccf1eed2fc94c0c94e7fb04485b7251025?s=96&d=mm&r=g","caption":"Bingjie Miao, Senior Software Engineer, Couchbase"},"description":"\ube59\uc9c0\uc5d0 \ubbf8\uc544\uc624\ub294 Couchbase\uc758 \uc218\uc11d \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4\uc785\ub2c8\ub2e4. Bingjie\ub294 \uad00\uacc4\ud615 \ubc0f NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubd84\uc57c\uc5d0\uc11c 20\ub144\uc758 \uacbd\ub825\uc744 \ubcf4\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\uc758 \uc8fc\uc694 \uc804\ubb38 \ubd84\uc57c\ub294 \ucffc\ub9ac \ucd5c\uc801\ud654 \ubc0f \ucffc\ub9ac \uc2e4\ud589\uc785\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/bingjie-miaocouchbase-com\/"}]}},"authors":[{"term_id":9065,"user_id":3021,"is_guest":0,"slug":"bingjie-miaocouchbase-com","display_name":"Bingjie Miao, Principal Software Engineer Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/d0ea9ddc7d74a893baf9227b26296cccf1eed2fc94c0c94e7fb04485b7251025?s=96&d=mm&r=g","author_category":"","last_name":"Miao, Principal Software Engineer, Couchbase","first_name":"Bingjie","job_title":"","user_url":"","description":"\ube59\uc9c0\uc5d0 \ubbf8\uc544\uc624\ub294 Couchbase\uc758 \uc218\uc11d \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4\uc785\ub2c8\ub2e4. Bingjie\ub294 \uad00\uacc4\ud615 \ubc0f NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubd84\uc57c\uc5d0\uc11c 20\ub144\uc758 \uacbd\ub825\uc744 \ubcf4\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\uc758 \uc8fc\uc694 \uc804\ubb38 \ubd84\uc57c\ub294 \ucffc\ub9ac \ucd5c\uc801\ud654 \ubc0f \ucffc\ub9ac \uc2e4\ud589\uc785\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/12715","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\/3021"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=12715"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/12715\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/12716"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=12715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=12715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=12715"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=12715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}