Kikyou1997 commented on code in PR #19323:
URL: https://github.com/apache/doris/pull/19323#discussion_r1186654708


##########
docs/zh-CN/docs/query-acceleration/statistics.md:
##########
@@ -0,0 +1,888 @@
+---
+{
+"title": "统计信息",
+"language": "zh-CN"
+}
+---
+
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements.  See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership.  The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License.  You may obtain a copy of the License at
+
+  http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied.  See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+# 统计信息
+
+## 统计信息简介
+
+在 SQL 
数据库中,查询优化器的质量对系统性能有重要影响。优化器需要依据统计信息来估算查询代价,尤其在等值查询场景中,精确估算基数是非常重要的,基数估算可以帮助优化器选择最优的查询计划,从而提高查询性能。
+
+在执行一个查询时,未经过充分优化的执行计划和经过优化的执行计划可能会导致执行时间上的巨大差异,这个差距可以高达数倍。因此,对于 SQL 
查询优化器来说,收集和分析统计信息是非常重要的,只有通过这些统计信息,优化器才能够准确地评估不同执行计划的成本,并选择最佳的执行计划。
+
+Doris 查询优化器使用统计信息来确定查询最有效的执行计划。Doris 维护的统计信息包括表级别的统计信息和列级别的统计信息。
+
+表统计信息:
+
+| 信息                | 描述                       |
+| :------------------ | :------------------------- |
+| `row_count`         | 表的行数                   |
+| `data_size`         | 表的⼤⼩(单位 byte)      |

Review Comment:
   What is this field used for



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to