{"id":7695,"date":"2021-08-16T15:23:07","date_gmt":"2021-08-16T07:23:07","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=7695"},"modified":"2021-08-16T15:46:26","modified_gmt":"2021-08-16T07:46:26","slug":"gbase-8a%e7%9a%84global-hash%e7%b4%a2%e5%bc%95%e6%9f%a5%e8%af%a2%e6%80%a7%e8%83%bd%e6%8f%90%e5%8d%87%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/7695","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u7684Global hash\u7d22\u5f15\u67e5\u8be2\u6027\u80fd\u63d0\u5347\u6d4b\u8bd5"},"content":{"rendered":"<p>\u672c\u6587\u4ecb\u7ecdGBase 8a\u7684\u4e3a\u7cbe\u786e\u67e5\u8be2\u63d0\u4f9b\u7684Global hash\u7d22\u5f15\u67e5\u8be2\u6027\u80fd\u63d0\u5347\u6d4b\u8bd5\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Directory Navigation<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2aea81e2c83\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2aea81e2c83\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E6%B5%8B%E8%AF%95%E7%BB%93%E6%9E%9C\" >\u6d4b\u8bd5\u7ed3\u679c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E7%8E%AF%E5%A2%83\" >\u73af\u5883<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E7%A1%AC%E4%BB%B6\" >\u786c\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E7%89%88%E6%9C%AC\" >\u7248\u672c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E6%95%B0%E6%8D%AE\" >\u6570\u636e<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E6%B5%8B%E8%AF%95%E8%BF%87%E7%A8%8B\" >\u6d4b\u8bd5\u8fc7\u7a0b<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E6%97%A0%E7%B4%A2%E5%BC%95%E6%9F%A5%E8%AF%A2id\" >\u65e0\u7d22\u5f15\u67e5\u8be2id<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E6%9C%89%E7%B4%A2%E5%BC%95%E6%9F%A5%E8%AF%A2id\" >\u6709\u7d22\u5f15\u67e5\u8be2id<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E6%97%A0%E7%B4%A2%E5%BC%95name%E5%88%97%E6%B5%8B%E8%AF%95\" >\u65e0\u7d22\u5f15name\u5217\u6d4b\u8bd5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E6%9C%89%E7%B4%A2%E5%BC%95name%E5%88%97%E6%B5%8B%E8%AF%95\" >\u6709\u7d22\u5f15name\u5217\u6d4b\u8bd5<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.gbase8.cn\/en\/7695\/#%E6%80%BB%E7%BB%93\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E7%BB%93%E6%9E%9C\"><\/span>\u6d4b\u8bd5\u7ed3\u679c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>global hash\u7d22\u5f15\uff0c\u53ef\u4ee5\u63d0\u5347\u7b80\u5355\u7cbe\u786e\u67e5\u8be2\u7684\u6027\u80fd10-100\u500d\u3002 \u5176\u4e2d\u91cd\u590d\u5ea6\u8d8a\u4f4e\uff0c\u6027\u80fd\u63d0\u5347\u6548\u679c\u8d8a\u597d\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%8E%AF%E5%A2%83\"><\/span>\u73af\u5883<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A1%AC%E4%BB%B6\"><\/span>\u786c\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u7b14\u8bb0\u672c\u7684\u865a\u62df\u673a\uff0c 4C, 4G. redhat 7<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%89%88%E6%9C%AC\"><\/span>\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>9.5.2, \u8be5\u529f\u80fd\u6ca1\u6709\u505a\u8fc7\u6539\u52a8\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%95%B0%E6%8D%AE\"><\/span>\u6570\u636e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>2\u5b57\u6bb5\u8868\uff0c1.2\u4ebf\u884c\uff0c\u5176\u4e2did\u670932K\u4e2a\u4e0d\u540c\u503c\uff0cname \u67091\u4ebf\u4e2a\u4e0d\u901a\u503c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; desc tt1;\n+-------+--------------+------+-----+---------+-------+\n| Field | Type         | Null | Key | Default | Extra |\n+-------+--------------+------+-----+---------+-------+\n| id    | int(11)      | YES  |     | NULL    |       |\n| name  | varchar(100) | YES  |     | NULL    |       |\n+-------+--------------+------+-----+---------+-------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select count(*), count(distinct id),count(distinct name) from tt1;\n+-----------+--------------------+----------------------+\n| count(*)  | count(distinct id) | count(distinct name) |\n+-----------+--------------------+----------------------+\n| 127135509 |              32768 |             10000002 |\n+-----------+--------------------+----------------------+\n1 row in set (Elapsed: 00:06:52.89)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E8%BF%87%E7%A8%8B\"><\/span>\u6d4b\u8bd5\u8fc7\u7a0b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%97%A0%E7%B4%A2%E5%BC%95%E6%9F%A5%E8%AF%A2id\"><\/span>\u65e0\u7d22\u5f15\u67e5\u8be2id<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u7ed3\u679c\u96c63700\u884c\uff0c\u57fa\u672c\u57280.4-0.5\u79d2\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select count(*) from tt1 where id=10;\n+----------+\n| count(*) |\n+----------+\n|     3717 |\n+----------+\n1 row in set (Elapsed: 00:00:00.88)\n\ngbase&gt; select count(*) from tt1 where id=10;\n+----------+\n| count(*) |\n+----------+\n|     3717 |\n+----------+\n1 row in set (Elapsed: 00:00:00.46)\n\ngbase&gt; select count(*) from tt1 where id=10;\n+----------+\n| count(*) |\n+----------+\n|     3717 |\n+----------+\n1 row in set (Elapsed: 00:00:00.47)<\/code><\/pre>\n\n\n\n<p>\u4ecetrc\u65e5\u5fd7\u770b\uff0c\u9996\u6b21\u52a0\u8f7d\u4e86\u51e0\u767e\u4e2aDC,\u7136\u540e\u626b\u63cf\uff0c\u8017\u65f60.4\u79d2\u3002 \u540e\u7eed\u662f\u70ed\u6570\u636e\uff0c\u65f6\u95f40.4\u79d2\u82b1\u8d39\u7eaf\u626b\u63cf\u4e0a\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT  COUNT(1) FROM `testdb`.`tt1_n1`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`id` = 10)\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Tables:\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n1),         63567786 rows,   970 DC\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.id BET. 10 AND 10       (0)\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\n2021-08-16 08:51:02.062 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.id BET. 10 AND 10\n2021-08-16 08:51:02.628 &#91;M: 139M,   0B,D:   0B] &#91;DC:     2,   508] ( 1)cnd(0)   scanned 15859712 rows,  found 469 rows (time used: 0.565s)\n2021-08-16 08:51:02.832 &#91;M: 229M,   0B,D:   0B] &#91;DC:     0,   859] ( 2)cnd(0)   scanned 15925248 rows,  found 461 rows (time used: 0.769s)\n2021-08-16 08:51:02.873 &#91;M: 247M,   0B,D:   0B] &#91;DC:     0,   947] ( 0)cnd(0)   scanned 15925248 rows,  found 460 rows (time used: 0.811s)\n2021-08-16 08:51:02.897 &#91;M: 254M,   0B,D:   0B] &#91;DC:     0,   970] ( 3)cnd(0)   scanned 15857578 rows,  found 477 rows (time used: 0.835s)\n2021-08-16 08:51:02.900 &#91;M: 254M,   0B,D:   0B] &#91;DC:     0,   970] cnd(0) Done. scanned 63567786 rows,  found 1867 rows (time used: 0.838s)\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] T0:          total 970 DC,   found 828 DC after scan(with 0 FULL DC).\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] END Scan. (time used: 0.839s)\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] Condition Weight (join):\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] BEGIN Join\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] END Join(time used: 0.000s)\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] BEGIN Scan(after join)\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] END Scan(after join)(time used: 0.000s)\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] CalculatePageSize: TmpCacheSize = 32000000, no obj = 63567786, attr count = 1, record size = 8, page size = 4194304\n2021-08-16 08:51:02.901 &#91;M: 255M,  32B,D:   0B] &#91;DC:     0,   970] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     0,   970] BEGIN Serial Aggregation(1867 rows)\n2021-08-16 08:51:02.901 &#91;M: 255M,  32B,D:   0B] &#91;DC:     0,   970] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:02.901 &#91;M: 255M,  64B,D:   0B] &#91;DC:     0,   970] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:02.901 &#91;M: 255M,  32B,D:   0B] &#91;DC:     0,   970] BEGIN Aggregation(1867 rows)\n2021-08-16 08:51:02.901 &#91;M: 255M,  64B,D:   0B] &#91;DC:     0,   970] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:02.901 &#91;M: 255M,  64B,D:   0B] &#91;DC:     0,   970] TempTable::MultiDimensionalGroupByScan(): aggregate 1867 rows)\n2021-08-16 08:51:02.901 &#91;M: 255M,  64B,D:   0B] &#91;DC:     0,   970] CalculatePageSize: TmpCacheSize = 32000000, no obj = 1, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:02.901 &#91;M: 255M,  64B,D:   0B] &#91;DC:     0,   970] CalculatePageSize: TmpCacheSize = 32000000, no obj = 1, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:02.901 &#91;M: 255M,  32B,D:   0B] &#91;DC:     0,   970] END Serial Aggregation. (time used: 0.000s)\n2021-08-16 08:51:02.901 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] Send 1 rows already\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] CalculatePageSize: TmpCacheSize = 32000000, no obj = 65536, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] ResultSender: send 0 rows.\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] output result done.\n\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] SUMMARY\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] elapsed time:                00:00:00.840\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] data loaded from storage:     123M,  2.169s,         970 DC.\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] data decompressed:            134M,  0.028s.\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] temp space IO stats:\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:02.902 &#91;M: 255M,   0B,D:   0B] &#91;DC:     1,   970] ======================================================\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     1,   970] before opt:select count(1) AS \"COUNT(1)\" from \"testdb\".\"tt1_n1\" \"vcname000001.testdb.tt1\" where (\"testdb\".\"vcname000001.testdb.tt1\".\"id\" = 10)\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     1,   970] after  opt:select count(1) AS \"COUNT(1)\" from \"testdb\".\"tt1_n1\" \"vcname000001.testdb.tt1\" where (\"testdb\".\"vcname000001.testdb.tt1\".\"id\" = 10)\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\nSELECT  COUNT(1) FROM `testdb`.`tt1_n1`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`id` = 10)\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] Tables:\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n1),         63567786 rows,   970 DC\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.id BET. 10 AND 10       (0)\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\n2021-08-16 08:51:07.970 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.id BET. 10 AND 10\n2021-08-16 08:51:08.201 &#91;M: 261M,   0B,D:   0B] &#91;DC:   612,     0] ( 0)cnd(0)   scanned 15925248 rows,  found 460 rows (time used: 0.230s)\n2021-08-16 08:51:08.390 &#91;M: 261M,   0B,D:   0B] &#91;DC:   951,     0] ( 2)cnd(0)   scanned 15925248 rows,  found 461 rows (time used: 0.409s)\n2021-08-16 08:51:08.393 &#91;M: 261M,   0B,D:   0B] &#91;DC:   953,     0] ( 1)cnd(0)   scanned 15859712 rows,  found 469 rows (time used: 0.422s)\n2021-08-16 08:51:08.408 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] ( 3)cnd(0)   scanned 15857578 rows,  found 477 rows (time used: 0.428s)\n2021-08-16 08:51:08.411 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] cnd(0) Done. scanned 63567786 rows,  found 1867 rows (time used: 0.440s)\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] T0:          total 970 DC,   found 828 DC after scan(with 0 FULL DC).\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] END Scan. (time used: 0.441s)\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] Condition Weight (join):\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] BEGIN Join\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] END Join(time used: 0.000s)\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] BEGIN Scan(after join)\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] END Scan(after join)(time used: 0.000s)\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] CalculatePageSize: TmpCacheSize = 32000000, no obj = 63567786, attr count = 1, record size = 8, page size = 4194304\n2021-08-16 08:51:08.412 &#91;M: 261M,  32B,D:   0B] &#91;DC:   970,     0] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] BEGIN Serial Aggregation(1867 rows)\n2021-08-16 08:51:08.412 &#91;M: 261M,  32B,D:   0B] &#91;DC:   970,     0] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:08.412 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:08.412 &#91;M: 261M,  32B,D:   0B] &#91;DC:   970,     0] BEGIN Aggregation(1867 rows)\n2021-08-16 08:51:08.412 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:08.412 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] TempTable::MultiDimensionalGroupByScan(): aggregate 1867 rows)\n2021-08-16 08:51:08.412 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] CalculatePageSize: TmpCacheSize = 32000000, no obj = 1, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:08.412 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] CalculatePageSize: TmpCacheSize = 32000000, no obj = 1, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:08.412 &#91;M: 262M,  32B,D:   0B] &#91;DC:   970,     0] END Serial Aggregation. (time used: 0.000s)\n2021-08-16 08:51:08.412 &#91;M: 262M,   0B,D:   0B] &#91;DC:   971,     0] Send 1 rows already\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] CalculatePageSize: TmpCacheSize = 32000000, no obj = 65536, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] ResultSender: send 0 rows.\n2021-08-16 08:51:08.412 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] output result done.\n\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] SUMMARY\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] elapsed time:                00:00:00.443\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] data loaded from storage:       0B,  0s,     0 DC.\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] data decompressed:              0B,  0s.\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] temp space IO stats:\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:08.413 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] ======================================================\n2021-08-16 08:51:10.611 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] before opt:select count(1) AS \"COUNT(1)\" from \"testdb\".\"tt1_n1\" \"vcname000001.testdb.tt1\" where (\"testdb\".\"vcname000001.testdb.tt1\".\"id\" = 10)\n2021-08-16 08:51:10.611 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] after  opt:select count(1) AS \"COUNT(1)\" from \"testdb\".\"tt1_n1\" \"vcname000001.testdb.tt1\" where (\"testdb\".\"vcname000001.testdb.tt1\".\"id\" = 10)\n2021-08-16 08:51:10.611 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\nSELECT  COUNT(1) FROM `testdb`.`tt1_n1`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`id` = 10)\n2021-08-16 08:51:10.611 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] Tables:\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n1),         63567786 rows,   970 DC\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.id BET. 10 AND 10       (0)\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\n2021-08-16 08:51:10.612 &#91;M: 261M,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.id BET. 10 AND 10\n2021-08-16 08:51:10.857 &#91;M: 261M,   0B,D:   0B] &#91;DC:   595,     0] ( 2)cnd(0)   scanned 15925248 rows,  found 461 rows (time used: 0.245s)\n2021-08-16 08:51:10.966 &#91;M: 261M,   0B,D:   0B] &#91;DC:   833,     0] ( 0)cnd(0)   scanned 15925248 rows,  found 460 rows (time used: 0.345s)\n2021-08-16 08:51:11.025 &#91;M: 261M,   0B,D:   0B] &#91;DC:   933,     0] ( 1)cnd(0)   scanned 15859712 rows,  found 469 rows (time used: 0.403s)\n2021-08-16 08:51:11.055 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] ( 3)cnd(0)   scanned 15857578 rows,  found 477 rows (time used: 0.433s)\n2021-08-16 08:51:11.059 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] cnd(0) Done. scanned 63567786 rows,  found 1867 rows (time used: 0.447s)\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] T0:          total 970 DC,   found 828 DC after scan(with 0 FULL DC).\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] END Scan. (time used: 0.451s)\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] Condition Weight (join):\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] BEGIN Join\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] END Join(time used: 0.000s)\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] BEGIN Scan(after join)\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] END Scan(after join)(time used: 0.000s)\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] CalculatePageSize: TmpCacheSize = 32000000, no obj = 63567786, attr count = 1, record size = 8, page size = 4194304\n2021-08-16 08:51:11.063 &#91;M: 261M,  32B,D:   0B] &#91;DC:   970,     0] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:11.063 &#91;M: 261M,   0B,D:   0B] &#91;DC:   970,     0] BEGIN Serial Aggregation(1867 rows)\n2021-08-16 08:51:11.064 &#91;M: 261M,  32B,D:   0B] &#91;DC:   970,     0] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:11.064 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:11.064 &#91;M: 261M,  32B,D:   0B] &#91;DC:   970,     0] BEGIN Aggregation(1867 rows)\n2021-08-16 08:51:11.064 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] GTBuff: total_size:33554432 has_dist:0 rows_limit:1 width:8\n2021-08-16 08:51:11.064 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] TempTable::MultiDimensionalGroupByScan(): aggregate 1867 rows)\n2021-08-16 08:51:11.064 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] CalculatePageSize: TmpCacheSize = 32000000, no obj = 1, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:11.064 &#91;M: 261M,  64B,D:   0B] &#91;DC:   970,     0] CalculatePageSize: TmpCacheSize = 32000000, no obj = 1, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:11.064 &#91;M: 262M,  32B,D:   0B] &#91;DC:   970,     0] END Serial Aggregation. (time used: 0.000s)\n2021-08-16 08:51:11.064 &#91;M: 262M,   0B,D:   0B] &#91;DC:   971,     0] Send 1 rows already\n2021-08-16 08:51:11.064 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] CalculatePageSize: TmpCacheSize = 32000000, no obj = 65536, attr count = 1, record size = 8, page size = 65536\n2021-08-16 08:51:11.064 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] ResultSender: send 0 rows.\n2021-08-16 08:51:11.064 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] output result done.\n\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] SUMMARY\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] elapsed time:                00:00:00.453\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] data loaded from storage:       0B,  0s,     0 DC.\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] data decompressed:              0B,  0s.\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] temp space IO stats:\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 08:51:11.065 &#91;M: 261M,   0B,D:   0B] &#91;DC:   971,     0] ======================================================<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%89%E7%B4%A2%E5%BC%95%E6%9F%A5%E8%AF%A2id\"><\/span>\u6709\u7d22\u5f15\u67e5\u8be2id<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5e26\u7d22\u5f15\u67e5\u8be2\uff0c\u57fa\u672c\u57280.02\u79d2\u3002\u6bd4\u65e0\u7d22\u5f15\u7684\u5feb\u4e8610\u500d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select count(*) from tt1 where id=10;\n+----------+\n| count(*) |\n+----------+\n|     3717 |\n+----------+\n1 row in set (Elapsed: 00:00:00.02)\n\ngbase&gt; select count(*) from tt1 where id=1000;\n+----------+\n| count(*) |\n+----------+\n|     4402 |\n+----------+\n1 row in set (Elapsed: 00:00:00.02)\n<\/code><\/pre>\n\n\n\n<p>\u67e5\u770btrc\uff0c \u53ef\u4ee5\u770b\u5230\u91c7\u7528\u4e86global hash\u7d22\u5f15\u626b\u63cf\uff0c\u800c\u4e0d\u662fdc\u626b\u63cf<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2021-08-16 14:58:11.969 &#91;M:   3M,   0B,D:   0B] &#91;DC:     0,     0] Global hash index is used:<\/code><\/pre>\n\n\n\n<p>\u5b8c\u6574trc<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2021-08-16 14:54:35.423 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\nSELECT  COUNT(1) FROM `testdb`.`tt1_n1`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`id` = 10)\n2021-08-16 14:54:35.423 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Tables:\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n1),         63567786 rows,   970 DC\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.id BET. 10 AND 10       (0)\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\n2021-08-16 14:54:35.424 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.id BET. 10 AND 10\n2021-08-16 14:54:35.433 &#91;M:   0B,  64B,D:   0B] &#91;DC:     0,     0] Global hash index is used:\n2021-08-16 14:54:35.433 &#91;M: 516K,  64B,D:   0B] &#91;DC:     0,     0] cnd(0)       scanned 1867 rows,      found 1867 rows (time used: 0.000s)\n2021-08-16 14:54:35.433 &#91;M: 516K,  32B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 828 DC after scan(with 0 FULL DC).\n2021-08-16 14:54:35.433 &#91;M: 516K,  32B,D:   0B] &#91;DC:     0,     0] END Scan. (time used: 0.010s)\n2021-08-16 14:54:35.434 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (join):\n2021-08-16 14:54:35.434 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Join\n2021-08-16 14:54:35.434 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Join(time used: 0.000s)\n2021-08-16 14:54:35.434 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan(after join)\n2021-08-16 14:54:35.434 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Scan(after join)(time used: 0.000s)\n2021-08-16 14:54:35.434 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Serial Aggregation(1867 rows)\n2021-08-16 14:54:35.434 &#91;M:   0B,  32B,D:   0B] &#91;DC:     0,     0] BEGIN Aggregation(1867 rows)\n2021-08-16 14:54:35.434 &#91;M:   0B,  64B,D:   0B] &#91;DC:     0,     0] TempTable::MultiDimensionalGroupByScan(): aggregate 1867 rows)\n2021-08-16 14:54:35.435 &#91;M: 516K,  32B,D:   0B] &#91;DC:     0,     0] END Serial Aggregation. (time used: 0.001s)\n2021-08-16 14:54:35.435 &#91;M: 516K,   0B,D:   0B] &#91;DC:     1,     0] Send 1 rows already\n2021-08-16 14:54:35.435 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] ResultSender: send 0 rows.\n2021-08-16 14:54:35.435 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] output result done.\n\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] SUMMARY\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] elapsed time:                00:00:00.013\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] data loaded from storage:       0B,  0s,     0 DC.\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] data decompressed:              0B,  0s.\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] temp space IO stats:\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:54:35.436 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] ======================================================\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\nSELECT  COUNT(1) FROM `testdb`.`tt1_n1`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`id` = 1000)\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Tables:\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n1),         63567786 rows,   970 DC\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.id BET. 1000 AND 1000   (0)\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\n2021-08-16 14:55:26.397 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.id BET. 1000 AND 1000\n2021-08-16 14:55:26.404 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Global hash index is used:\n2021-08-16 14:55:26.404 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0)       scanned 2180 rows,      found 2180 rows (time used: 0.000s)\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 882 DC after scan(with 0 FULL DC).\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Scan. (time used: 0.007s)\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (join):\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Join\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Join(time used: 0.000s)\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan(after join)\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Scan(after join)(time used: 0.000s)\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Serial Aggregation(2180 rows)\n2021-08-16 14:55:26.405 &#91;M:   0B,  32B,D:   0B] &#91;DC:     0,     0] BEGIN Aggregation(2180 rows)\n2021-08-16 14:55:26.405 &#91;M:   0B,  64B,D:   0B] &#91;DC:     0,     0] TempTable::MultiDimensionalGroupByScan(): aggregate 2180 rows)\n2021-08-16 14:55:26.405 &#91;M: 516K,  32B,D:   0B] &#91;DC:     0,     0] END Serial Aggregation. (time used: 0.000s)\n2021-08-16 14:55:26.405 &#91;M: 516K,   0B,D:   0B] &#91;DC:     1,     0] Send 1 rows already\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] ResultSender: send 0 rows.\n2021-08-16 14:55:26.405 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] output result done.\n\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] SUMMARY\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] elapsed time:                00:00:00.009\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] data loaded from storage:       0B,  0s,     0 DC.\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] data decompressed:              0B,  0s.\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] temp space IO stats:\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\n2021-08-16 14:55:26.406 &#91;M:   0B,   0B,D:   0B] &#91;DC:     1,     0] ======================================================\n<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%97%A0%E7%B4%A2%E5%BC%95name%E5%88%97%E6%B5%8B%E8%AF%95\"><\/span>\u65e0\u7d22\u5f15name\u5217\u6d4b\u8bd5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u7ed3\u679c\u96c615\u884c\uff0c\u57fa\u672c\u57286\u79d2\u4ee5\u4e0a\u3002\u91cd\u590d\u6267\u884c\uff0c\u56e0\u4e3a\u5185\u5b58\u4e0d\u8db3\uff0c\u8fd8\u662f\u8981\u4ece\u78c1\u76d8\u8bfb\u53d6\u6570\u636e\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\r\ngbase> select count(*) from tt1 where name='7ce4c628-3c8b-495f-b44c-ed4fefc97f59';\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|       15 |\r\n+----------+\r\n1 row in set (Elapsed: 00:00:10.65)\r\n\r\ngbase> select count(*) from tt1 where name='7ce4c628-3c8b-495f-b44c-ed4fefc97f59';\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|       15 |\r\n+----------+\r\n1 row in set (Elapsed: 00:00:06.59)\n\ngbase> select count(*) from tt1 where name='83812e39-5336-4b3f-b376-50dd485de980';\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|       15 |\r\n+----------+\r\n1 row in set (Elapsed: 00:00:06.89)\r\n\r\ngbase> select count(*) from tt1 where name='83812e39-5336-4b3f-b376-50dd485de980';\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|       15 |\r\n+----------+\r\n1 row in set (Elapsed: 00:00:06.47)<\/code><\/pre>\n\n\n\n<p>trc\u65e5\u5fd7<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2021-08-16 15:38:40.299 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\r\nSELECT  COUNT(1) FROM `testdb`.`tt1_n2`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`name` = '7ce4c628-3c8b-495f-b44c-ed4fefc97f59')\r\n2021-08-16 15:38:40.299 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\r\n2021-08-16 15:38:40.299 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Tables:\r\n2021-08-16 15:38:40.299 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n2),         63567723 rows,   970 DC\r\n2021-08-16 15:38:40.299 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\r\n2021-08-16 15:38:40.299 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.name BET. '7ce4c628-3c8b-495f-b44c-ed4fefc97f59' AND '7ce4c628-3c8b-495f-b44c-ed4fefc97f59'      (0)\r\n2021-08-16 15:38:40.299 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\r\n2021-08-16 15:38:40.301 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\r\n2021-08-16 15:38:40.301 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.001s)\r\n2021-08-16 15:38:40.301 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\r\n2021-08-16 15:38:40.301 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.name BET. '7ce4c628-3c8b-495f-b44c-ed4fefc97f59' AND '7ce4c628-3c8b-495f-b44c-ed4fefc97f59'\r\n2021-08-16 15:38:50.372 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     2,   937] ( 2)cnd(0)   scanned 15925248 rows,  found 1 rows (time used: 10.072s)\r\n2021-08-16 15:38:50.621 &#91;M:2.61G,   0B,D:   0B] &#91;DC:     2,   958] ( 0)cnd(0)   scanned 15925248 rows,  found 1 rows (time used: 10.320s)\r\n2021-08-16 15:38:50.735 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,   964] ( 3)cnd(0)   scanned 15857515 rows,  found 0 rows (time used: 10.435s)\r\n2021-08-16 15:38:50.842 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] ( 1)cnd(0)   scanned 15859712 rows,  found 2 rows (time used: 10.541s)\r\n2021-08-16 15:38:50.842 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] cnd(0) Done. scanned 63567723 rows,  found 4 rows (time used: 10.542s)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] T0:          total 970 DC,   found 4 DC after scan(with 0 FULL DC).\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] END Scan. (time used: 10.542s)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] Condition Weight (join):\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] BEGIN Join\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] END Join(time used: 0.000s)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] BEGIN Scan(after join)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] END Scan(after join)(time used: 0.000s)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     0,   970] BEGIN Serial Aggregation(4 rows)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,  32B,D:   0B] &#91;DC:     0,   970] BEGIN Aggregation(4 rows)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,  64B,D:   0B] &#91;DC:     0,   970] TempTable::MultiDimensionalGroupByScan(): aggregate 4 rows)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,  32B,D:   0B] &#91;DC:     0,   970] END Serial Aggregation. (time used: 0.000s)\r\n2021-08-16 15:38:50.843 &#91;M:2.70G,   0B,D:   0B] &#91;DC:     1,   970] Send 1 rows already\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] ResultSender: send 0 rows.\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] output result done.\r\n\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] SUMMARY\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] elapsed time:                00:00:10.578\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] data loaded from storage:    2.02G,  28.915s,        970 DC.\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] data decompressed:           2.72G,  4.281s.\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] temp space IO stats:\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:38:50.877 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:38:50.878 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:38:50.878 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:38:50.878 &#91;M:2.71G,   0B,D:   0B] &#91;DC:     1,   970] ======================================================\r\n2021-08-16 15:38:55.867 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\r\nSELECT  COUNT(1) FROM `testdb`.`tt1_n2`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`name` = '7ce4c628-3c8b-495f-b44c-ed4fefc97f59')\r\n2021-08-16 15:38:55.867 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\r\n2021-08-16 15:38:55.868 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] Tables:\r\n2021-08-16 15:38:55.868 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n2),         63567723 rows,   970 DC\r\n2021-08-16 15:38:55.868 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\r\n2021-08-16 15:38:55.868 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.name BET. '7ce4c628-3c8b-495f-b44c-ed4fefc97f59' AND '7ce4c628-3c8b-495f-b44c-ed4fefc97f59'      (0)\r\n2021-08-16 15:38:55.868 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\r\n2021-08-16 15:38:55.869 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\r\n2021-08-16 15:38:55.869 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.001s)\r\n2021-08-16 15:38:55.869 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\r\n2021-08-16 15:38:55.869 &#91;M:2.72G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.name BET. '7ce4c628-3c8b-495f-b44c-ed4fefc97f59' AND '7ce4c628-3c8b-495f-b44c-ed4fefc97f59'\r\n2021-08-16 15:39:01.755 &#91;M:2.03G,   0B,D:   0B] &#91;DC:   255,   646] ( 2)cnd(0)   scanned 15925248 rows,  found 1 rows (time used: 5.885s)\r\n2021-08-16 15:39:02.170 &#91;M:2.33G,   0B,D:   0B] &#91;DC:   254,   696] ( 1)cnd(0)   scanned 15859712 rows,  found 2 rows (time used: 6.301s)\r\n2021-08-16 15:39:02.314 &#91;M:2.42G,   0B,D:   0B] &#91;DC:   254,   710] ( 0)cnd(0)   scanned 15925248 rows,  found 1 rows (time used: 6.445s)\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] ( 3)cnd(0)   scanned 15857515 rows,  found 0 rows (time used: 6.514s)\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] cnd(0) Done. scanned 63567723 rows,  found 4 rows (time used: 6.537s)\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] T0:          total 970 DC,   found 4 DC after scan(with 0 FULL DC).\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] END Scan. (time used: 6.537s)\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] Condition Weight (join):\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] BEGIN Join\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] END Join(time used: 0.000s)\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] BEGIN Scan(after join)\r\n2021-08-16 15:39:02.406 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] END Scan(after join)(time used: 0.000s)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   254,   716] BEGIN Serial Aggregation(4 rows)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,  32B,D:   0B] &#91;DC:   254,   716] BEGIN Aggregation(4 rows)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,  64B,D:   0B] &#91;DC:   254,   716] TempTable::MultiDimensionalGroupByScan(): aggregate 4 rows)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,  32B,D:   0B] &#91;DC:   254,   716] END Serial Aggregation. (time used: 0.000s)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] Send 1 rows already\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] ResultSender: send 0 rows.\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] output result done.\r\n\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] SUMMARY\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] elapsed time:                00:00:06.539\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] data loaded from storage:    1.49G,  3.12s,  716 DC.\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] data decompressed:           2.01G,  6.736s.\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] temp space IO stats:\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] ======================================================\n\n2021-08-16 15:39:02.407 &#91;M:2.47G,   0B,D:   0B] &#91;DC:   255,   716] ======================================================\r\n2021-08-16 15:39:45.569 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\r\nSELECT  COUNT(1) FROM `testdb`.`tt1_n2`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`name` = '83812e39-5336-4b3f-b376-50dd485de980')\r\n2021-08-16 15:39:45.569 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\r\n2021-08-16 15:39:45.569 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] Tables:\r\n2021-08-16 15:39:45.569 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n2),         63567723 rows,   970 DC\r\n2021-08-16 15:39:45.569 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\r\n2021-08-16 15:39:45.569 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.name BET. '83812e39-5336-4b3f-b376-50dd485de980' AND '83812e39-5336-4b3f-b376-50dd485de980'      (0)\r\n2021-08-16 15:39:45.569 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\r\n2021-08-16 15:39:45.571 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\r\n2021-08-16 15:39:45.571 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.001s)\r\n2021-08-16 15:39:45.571 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\r\n2021-08-16 15:39:45.571 &#91;M:2.48G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.name BET. '83812e39-5336-4b3f-b376-50dd485de980' AND '83812e39-5336-4b3f-b376-50dd485de980'\r\n^&#91;&#91;B2021-08-16 15:39:51.726 &#91;M:2.00G,   0B,D:   0B] &#91;DC:   254,   690] ( 3)cnd(0)       scanned 15857515 rows,  found 1 rows (time used: 6.146s)\r\n2021-08-16 15:39:51.887 &#91;M:2.12G,   0B,D:   0B] &#91;DC:   253,   710] ( 1)cnd(0)   scanned 15859712 rows,  found 2 rows (time used: 6.317s)\r\n2021-08-16 15:39:51.896 &#91;M:2.12G,   0B,D:   0B] &#91;DC:   252,   712] ( 2)cnd(0)   scanned 15925248 rows,  found 2 rows (time used: 6.315s)\r\n2021-08-16 15:39:51.989 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] ( 0)cnd(0)   scanned 15925248 rows,  found 1 rows (time used: 6.397s)\r\n2021-08-16 15:39:51.991 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] cnd(0) Done. scanned 63567723 rows,  found 6 rows (time used: 6.420s)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] T0:          total 970 DC,   found 6 DC after scan(with 0 FULL DC).\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] END Scan. (time used: 6.423s)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] Condition Weight (join):\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] BEGIN Join\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] END Join(time used: 0.000s)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] BEGIN Scan(after join)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] END Scan(after join)(time used: 0.000s)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   252,   718] BEGIN Serial Aggregation(6 rows)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,  32B,D:   0B] &#91;DC:   252,   718] BEGIN Aggregation(6 rows)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,  64B,D:   0B] &#91;DC:   252,   718] TempTable::MultiDimensionalGroupByScan(): aggregate 6 rows)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,  32B,D:   0B] &#91;DC:   252,   718] END Serial Aggregation. (time used: 0.000s)\r\n2021-08-16 15:39:51.994 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] Send 1 rows already\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] ResultSender: send 0 rows.\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] output result done.\r\n\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] SUMMARY\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] elapsed time:                00:00:06.425\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] data loaded from storage:    1.50G,  2.549s,         718 DC.\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] data decompressed:           2.02G,  6.868s.\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] temp space IO stats:\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:39:51.995 &#91;M:2.18G,   0B,D:   0B] &#91;DC:   253,   718] ======================================================\r\n2021-08-16 15:39:56.093 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\r\nSELECT  COUNT(1) FROM `testdb`.`tt1_n2`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`name` = '83812e39-5336-4b3f-b376-50dd485de980')\r\n2021-08-16 15:39:56.093 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\r\n2021-08-16 15:39:56.093 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] Tables:\r\n2021-08-16 15:39:56.093 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n2),         63567723 rows,   970 DC\r\n2021-08-16 15:39:56.093 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\r\n2021-08-16 15:39:56.093 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.name BET. '83812e39-5336-4b3f-b376-50dd485de980' AND '83812e39-5336-4b3f-b376-50dd485de980'      (0)\r\n2021-08-16 15:39:56.094 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\r\n2021-08-16 15:39:56.095 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\r\n2021-08-16 15:39:56.095 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.001s)\r\n2021-08-16 15:39:56.095 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\r\n2021-08-16 15:39:56.095 &#91;M:2.33G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.name BET. '83812e39-5336-4b3f-b376-50dd485de980' AND '83812e39-5336-4b3f-b376-50dd485de980'\r\n2021-08-16 15:40:02.225 &#91;M:2.11G,   0B,D:   0B] &#91;DC:   252,   701] ( 2)cnd(0)   scanned 15925248 rows,  found 2 rows (time used: 6.107s)\r\n2021-08-16 15:40:02.351 &#91;M:2.19G,   0B,D:   0B] &#91;DC:   253,   712] ( 0)cnd(0)   scanned 15925248 rows,  found 1 rows (time used: 6.256s)\r\n2021-08-16 15:40:02.404 &#91;M:2.23G,   0B,D:   0B] &#91;DC:   252,   718] ( 1)cnd(0)   scanned 15859712 rows,  found 2 rows (time used: 6.309s)\r\n2021-08-16 15:40:02.410 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] ( 3)cnd(0)   scanned 15857515 rows,  found 1 rows (time used: 6.315s)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] cnd(0) Done. scanned 63567723 rows,  found 6 rows (time used: 6.316s)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] T0:          total 970 DC,   found 6 DC after scan(with 0 FULL DC).\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] END Scan. (time used: 6.316s)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] Condition Weight (join):\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] BEGIN Join\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] END Join(time used: 0.000s)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] BEGIN Scan(after join)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] END Scan(after join)(time used: 0.000s)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   252,   718] BEGIN Serial Aggregation(6 rows)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,  32B,D:   0B] &#91;DC:   252,   718] BEGIN Aggregation(6 rows)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,  64B,D:   0B] &#91;DC:   252,   718] TempTable::MultiDimensionalGroupByScan(): aggregate 6 rows)\r\n2021-08-16 15:40:02.411 &#91;M:2.22G,  32B,D:   0B] &#91;DC:   252,   718] END Serial Aggregation. (time used: 0.000s)\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] Send 1 rows already\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] ResultSender: send 0 rows.\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] output result done.\r\n\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] SUMMARY\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] elapsed time:                00:00:06.318\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] data loaded from storage:    1.50G,  2.679s,         718 DC.\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] data decompressed:           2.02G,  6.304s.\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] temp space IO stats:\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:40:02.412 &#91;M:2.22G,   0B,D:   0B] &#91;DC:   253,   718] ======================================================<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%89%E7%B4%A2%E5%BC%95name%E5%88%97%E6%B5%8B%E8%AF%95\"><\/span>\u6709\u7d22\u5f15name\u5217\u6d4b\u8bd5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6709\u7d22\u5f15\u6d4b\u8bd5\uff0c\u57fa\u672c\u57280.05\u79d2\uff0c\u6bd4\u65e0\u7d22\u5f15\u5feb\u4e86100\u500d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase> select count(*) from tt1 where name='7ce4c628-3c8b-495f-b44c-ed4fefc97f59';\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|       15 |\r\n+----------+\r\n1 row in set (Elapsed: 00:00:00.05)\n\ngbase> select count(*) from tt1 where name='83812e39-5336-4b3f-b376-50dd485de980';\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|       15 |\r\n+----------+\r\n1 row in set (Elapsed: 00:00:00.04)<\/code><\/pre>\n\n\n\n<p>trace\u65e5\u5fd7<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2021-08-16 15:36:26.571 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\r\nSELECT  COUNT(1) FROM `testdb`.`tt1_n2`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`name` = '7ce4c628-3c8b-495f-b44c-ed4fefc97f59')\r\n2021-08-16 15:36:26.571 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\r\n2021-08-16 15:36:26.571 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Tables:\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n2),         63567723 rows,   970 DC\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.name BET. '7ce4c628-3c8b-495f-b44c-ed4fefc97f59' AND '7ce4c628-3c8b-495f-b44c-ed4fefc97f59'      (0)\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.name BET. '7ce4c628-3c8b-495f-b44c-ed4fefc97f59' AND '7ce4c628-3c8b-495f-b44c-ed4fefc97f59'\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Global hash index is used:\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0)       scanned 4 rows,         found 4 rows (time used: 0.000s)\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 4 DC after scan(with 0 FULL DC).\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] END Scan. (time used: 0.031s)\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (join):\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Join\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] END Join(time used: 0.000s)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan(after join)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] END Scan(after join)(time used: 0.000s)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Serial Aggregation(4 rows)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,  32B,D:   0B] &#91;DC:     0,     0] BEGIN Aggregation(4 rows)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,  64B,D:   0B] &#91;DC:     0,     0] TempTable::MultiDimensionalGroupByScan(): aggregate 4 rows)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,  32B,D:   0B] &#91;DC:     0,     0] END Serial Aggregation. (time used: 0.000s)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] Send 1 rows already\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] ResultSender: send 0 rows.\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] output result done.\r\n\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] SUMMARY\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] elapsed time:                00:00:00.031\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] data loaded from storage:       0B,  0s,     0 DC.\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] data decompressed:              0B,  0s.\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] temp space IO stats:\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] ======================================================\n\n2021-08-16 15:36:26.571 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\r\nSELECT  COUNT(1) FROM `testdb`.`tt1_n2`  `vcname000001.testdb.tt1` WHERE (`vcname000001.testdb.tt1`.`name` = '7ce4c628-3c8b-495f-b44c-ed4fefc97f59')\r\n2021-08-16 15:36:26.571 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\r\n2021-08-16 15:36:26.571 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Tables:\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.tt1(testdb.tt1_n2),         63567723 rows,   970 DC\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      vcname000001.testdb.tt1.name BET. '7ce4c628-3c8b-495f-b44c-ed4fefc97f59' AND '7ce4c628-3c8b-495f-b44c-ed4fefc97f59'      (0)\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 970 DC to scan(with 0 FULL DC).\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\r\n2021-08-16 15:36:26.572 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) vcname000001.testdb.tt1.name BET. '7ce4c628-3c8b-495f-b44c-ed4fefc97f59' AND '7ce4c628-3c8b-495f-b44c-ed4fefc97f59'\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Global hash index is used:\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] cnd(0)       scanned 4 rows,         found 4 rows (time used: 0.000s)\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 970 DC,   found 4 DC after scan(with 0 FULL DC).\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] END Scan. (time used: 0.031s)\r\n2021-08-16 15:36:26.602 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (join):\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Join\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] END Join(time used: 0.000s)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan(after join)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] END Scan(after join)(time used: 0.000s)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Serial Aggregation(4 rows)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,  32B,D:   0B] &#91;DC:     0,     0] BEGIN Aggregation(4 rows)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,  64B,D:   0B] &#91;DC:     0,     0] TempTable::MultiDimensionalGroupByScan(): aggregate 4 rows)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,  32B,D:   0B] &#91;DC:     0,     0] END Serial Aggregation. (time used: 0.000s)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] Send 1 rows already\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] ResultSender: send 0 rows.\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] output result done.\r\n\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] SUMMARY\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] elapsed time:                00:00:00.031\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] data loaded from storage:       0B,  0s,     0 DC.\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] data decompressed:              0B,  0s.\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] temp space IO stats:\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 15:36:26.603 &#91;M:2.65G,   0B,D:   0B] &#91;DC:     1,     0] ======================================================<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%80%BB%E7%BB%93\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>global hash\u7d22\u5f15\uff0c\u53ea\u9002\u5408\u91cd\u590d\u503c\u5c11\u7684\u5217\uff0c\u6bd4\u5982\u7535\u8bdd\u53f7\u7801\uff0c\u8eab\u4efd\u8bc1\uff0cimsi, msisdn\u7b49\uff0c\u4e0d\u9002\u5408\u91cd\u590d\u5ea6\u9ad8\uff0c\u6bd4\u5982\u6c11\u65cf\uff0c\u57ce\u5e02\u7b49\u3002\u53e6\u5916\uff0c\u53ea\u9488\u5bf9\u7cbe\u786e\u7b49\u503c\u67e5\u8be2\uff0c\u5bf9\u8303\u56f4\u67e5\u8be2\u65e0\u6548\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u7684Global hash\u7d22\u5f15\u67e5\u8be2\u6027\u80fd\u63d0\u5347\u6d4b\u8bd5<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7695","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=7695"}],"version-history":[{"count":2,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7695\/revisions"}],"predecessor-version":[{"id":7698,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7695\/revisions\/7698"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=7695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=7695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=7695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}