This is an automated email from the ASF dual-hosted git repository. zykkk pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push: new e1b777fdb2 Removed Statistics section from database analysis document (#1179) e1b777fdb2 is described below commit e1b777fdb261fda077b1996b7b14c0c376c89cf0 Author: zy-kkk <zhongy...@gmail.com> AuthorDate: Thu Oct 10 10:30:55 2024 +0800 Removed Statistics section from database analysis document (#1179) # Versions - [x] dev - [x] 3.0 - [x] 2.1 - [x] 2.0 # Languages - [x] Chinese - [x] English --- docs/lakehouse/database/clickhouse.md | 6 ------ docs/lakehouse/database/ibm-db2.md | 6 ------ docs/lakehouse/database/mysql.md | 6 ------ docs/lakehouse/database/oracle.md | 6 ------ docs/lakehouse/database/postgresql.md | 6 ------ docs/lakehouse/database/sap-hana.md | 6 ------ docs/lakehouse/database/sqlserver.md | 6 ------ .../current/lakehouse/database/clickhouse.md | 6 ------ .../current/lakehouse/database/ibm-db2.md | 6 ------ .../current/lakehouse/database/mysql.md | 6 ------ .../current/lakehouse/database/oracle.md | 6 ------ .../current/lakehouse/database/postgresql.md | 6 ------ .../current/lakehouse/database/sap-hana.md | 6 ------ .../current/lakehouse/database/sqlserver.md | 6 ------ .../version-2.0/lakehouse/database/clickhouse.md | 6 ------ .../version-2.0/lakehouse/database/mysql.md | 6 ------ .../version-2.0/lakehouse/database/oracle.md | 6 ------ .../version-2.0/lakehouse/database/postgresql.md | 6 ------ .../version-2.0/lakehouse/database/sap-hana.md | 6 ------ .../version-2.0/lakehouse/database/sqlserver.md | 6 ------ .../version-2.1/lakehouse/database/clickhouse.md | 6 ------ .../version-2.1/lakehouse/database/ibm-db2.md | 6 ------ .../version-2.1/lakehouse/database/mysql.md | 6 ------ .../version-2.1/lakehouse/database/oracle.md | 6 ------ .../version-2.1/lakehouse/database/postgresql.md | 6 ------ .../version-2.1/lakehouse/database/sap-hana.md | 6 ------ .../version-2.1/lakehouse/database/sqlserver.md | 6 ------ .../version-3.0/lakehouse/database/clickhouse.md | 6 ------ .../version-3.0/lakehouse/database/ibm-db2.md | 6 ------ .../version-3.0/lakehouse/database/mysql.md | 6 ------ .../version-3.0/lakehouse/database/oracle.md | 6 ------ .../version-3.0/lakehouse/database/postgresql.md | 6 ------ .../version-3.0/lakehouse/database/sap-hana.md | 6 ------ .../version-3.0/lakehouse/database/sqlserver.md | 6 ------ versioned_docs/version-2.0/lakehouse/database/clickhouse.md | 6 ------ versioned_docs/version-2.0/lakehouse/database/mysql.md | 6 ------ versioned_docs/version-2.0/lakehouse/database/oracle.md | 6 ------ versioned_docs/version-2.0/lakehouse/database/postgresql.md | 6 ------ versioned_docs/version-2.0/lakehouse/database/sap-hana.md | 6 ------ versioned_docs/version-2.0/lakehouse/database/sqlserver.md | 6 ------ versioned_docs/version-2.1/lakehouse/database/clickhouse.md | 6 ------ versioned_docs/version-2.1/lakehouse/database/ibm-db2.md | 6 ------ versioned_docs/version-2.1/lakehouse/database/mysql.md | 6 ------ versioned_docs/version-2.1/lakehouse/database/oracle.md | 6 ------ versioned_docs/version-2.1/lakehouse/database/postgresql.md | 6 ------ versioned_docs/version-2.1/lakehouse/database/sap-hana.md | 6 ------ versioned_docs/version-2.1/lakehouse/database/sqlserver.md | 6 ------ versioned_docs/version-3.0/lakehouse/database/clickhouse.md | 6 ------ versioned_docs/version-3.0/lakehouse/database/ibm-db2.md | 6 ------ versioned_docs/version-3.0/lakehouse/database/mysql.md | 6 ------ versioned_docs/version-3.0/lakehouse/database/oracle.md | 6 ------ versioned_docs/version-3.0/lakehouse/database/postgresql.md | 6 ------ versioned_docs/version-3.0/lakehouse/database/sap-hana.md | 6 ------ versioned_docs/version-3.0/lakehouse/database/sqlserver.md | 6 ------ 54 files changed, 324 deletions(-) diff --git a/docs/lakehouse/database/clickhouse.md b/docs/lakehouse/database/clickhouse.md index dbed41474d..bc4b92ebcd 100644 --- a/docs/lakehouse/database/clickhouse.md +++ b/docs/lakehouse/database/clickhouse.md @@ -102,12 +102,6 @@ When mapping ClickHouse, a Database in Doris corresponds to a Database in ClickH ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/docs/lakehouse/database/ibm-db2.md b/docs/lakehouse/database/ibm-db2.md index 103fb0bdd2..d8aefe33c1 100644 --- a/docs/lakehouse/database/ibm-db2.md +++ b/docs/lakehouse/database/ibm-db2.md @@ -95,12 +95,6 @@ When mapping IBM Db2, Doris' Database corresponds to a Schema under the specifie ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/docs/lakehouse/database/mysql.md b/docs/lakehouse/database/mysql.md index df42aae0fc..faae5241a1 100644 --- a/docs/lakehouse/database/mysql.md +++ b/docs/lakehouse/database/mysql.md @@ -134,12 +134,6 @@ When reading MySQL's TIMESTAMP type, add parameters to the JDBC URL: `connection ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/docs/lakehouse/database/oracle.md b/docs/lakehouse/database/oracle.md index 8d0bba2a26..120e30df79 100644 --- a/docs/lakehouse/database/oracle.md +++ b/docs/lakehouse/database/oracle.md @@ -90,12 +90,6 @@ When mapping Oracle, a Database in Doris corresponds to a User in Oracle. The Ta ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/docs/lakehouse/database/postgresql.md b/docs/lakehouse/database/postgresql.md index d16fe9c046..8b3882dd6a 100644 --- a/docs/lakehouse/database/postgresql.md +++ b/docs/lakehouse/database/postgresql.md @@ -124,12 +124,6 @@ In order to ensure time zone consistency, it is recommended to set the JVM time ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/docs/lakehouse/database/sap-hana.md b/docs/lakehouse/database/sap-hana.md index bd8b051822..1b5b3268b8 100644 --- a/docs/lakehouse/database/sap-hana.md +++ b/docs/lakehouse/database/sap-hana.md @@ -91,12 +91,6 @@ When mapping SAP HANA, Doris' Database corresponds to a Schema under the specifi ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/docs/lakehouse/database/sqlserver.md b/docs/lakehouse/database/sqlserver.md index 3727cc8b94..ac009d1227 100644 --- a/docs/lakehouse/database/sqlserver.md +++ b/docs/lakehouse/database/sqlserver.md @@ -100,12 +100,6 @@ When mapping SQLServer, a Database in Doris corresponds to a Schema under the sp ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/clickhouse.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/clickhouse.md index 6322288abd..edf7badad6 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/clickhouse.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/clickhouse.md @@ -101,12 +101,6 @@ CREATE CATALOG clickhouse PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/ibm-db2.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/ibm-db2.md index 0ee574bfe5..edb37edd1f 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/ibm-db2.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/ibm-db2.md @@ -95,12 +95,6 @@ CREATE CATALOG db2 PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/mysql.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/mysql.md index 0ea9986818..143ffe6bb2 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/mysql.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/mysql.md @@ -133,12 +133,6 @@ CREATE CATALOG mysql PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/oracle.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/oracle.md index 5b57b349fd..cf6f1cac3a 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/oracle.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/oracle.md @@ -89,12 +89,6 @@ CREATE CATALOG oracle PROPERTIES ( ## 查询优化 -### 统计信息 - -Apache Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Apache Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/postgresql.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/postgresql.md index f69325ca0c..7de2d61d7e 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/postgresql.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/postgresql.md @@ -123,12 +123,6 @@ CREATE CATALOG postgresql PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/sap-hana.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/sap-hana.md index 2e149a1718..de9eff0a4c 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/sap-hana.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/sap-hana.md @@ -91,12 +91,6 @@ CREATE CATALOG saphana PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/sqlserver.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/sqlserver.md index 3c5429965d..49ced4c195 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/sqlserver.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/sqlserver.md @@ -100,12 +100,6 @@ JDBC 驱动程序以及连接器自动使用传输层安全性 (TLS) 加密和 ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/clickhouse.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/clickhouse.md index 3318c2108f..a1eb771dc8 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/clickhouse.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/clickhouse.md @@ -101,12 +101,6 @@ CREATE CATALOG clickhouse PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/mysql.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/mysql.md index 351ff8a7c0..d9f91c8d32 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/mysql.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/mysql.md @@ -133,12 +133,6 @@ CREATE CATALOG mysql PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/oracle.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/oracle.md index 911faf13e0..46c4147794 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/oracle.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/oracle.md @@ -89,12 +89,6 @@ CREATE CATALOG oracle PROPERTIES ( ## 查询优化 -### 统计信息 - -Apache Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Apache Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/postgresql.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/postgresql.md index f69325ca0c..7de2d61d7e 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/postgresql.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/postgresql.md @@ -123,12 +123,6 @@ CREATE CATALOG postgresql PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/sap-hana.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/sap-hana.md index ee17675b05..35e6ed1c0b 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/sap-hana.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/sap-hana.md @@ -91,12 +91,6 @@ CREATE CATALOG saphana PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/sqlserver.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/sqlserver.md index 3c5429965d..49ced4c195 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/sqlserver.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/sqlserver.md @@ -100,12 +100,6 @@ JDBC 驱动程序以及连接器自动使用传输层安全性 (TLS) 加密和 ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/clickhouse.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/clickhouse.md index 6322288abd..edf7badad6 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/clickhouse.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/clickhouse.md @@ -101,12 +101,6 @@ CREATE CATALOG clickhouse PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/ibm-db2.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/ibm-db2.md index 0ee574bfe5..edb37edd1f 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/ibm-db2.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/ibm-db2.md @@ -95,12 +95,6 @@ CREATE CATALOG db2 PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/mysql.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/mysql.md index 0ea9986818..143ffe6bb2 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/mysql.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/mysql.md @@ -133,12 +133,6 @@ CREATE CATALOG mysql PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/oracle.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/oracle.md index 5b57b349fd..cf6f1cac3a 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/oracle.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/oracle.md @@ -89,12 +89,6 @@ CREATE CATALOG oracle PROPERTIES ( ## 查询优化 -### 统计信息 - -Apache Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Apache Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/postgresql.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/postgresql.md index f69325ca0c..7de2d61d7e 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/postgresql.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/postgresql.md @@ -123,12 +123,6 @@ CREATE CATALOG postgresql PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/sap-hana.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/sap-hana.md index 4101ed5ec2..3ee997f2e7 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/sap-hana.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/sap-hana.md @@ -91,12 +91,6 @@ CREATE CATALOG saphana PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/sqlserver.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/sqlserver.md index 3c5429965d..49ced4c195 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/sqlserver.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/sqlserver.md @@ -100,12 +100,6 @@ JDBC 驱动程序以及连接器自动使用传输层安全性 (TLS) 加密和 ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/clickhouse.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/clickhouse.md index 6322288abd..edf7badad6 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/clickhouse.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/clickhouse.md @@ -101,12 +101,6 @@ CREATE CATALOG clickhouse PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/ibm-db2.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/ibm-db2.md index 0ee574bfe5..edb37edd1f 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/ibm-db2.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/ibm-db2.md @@ -95,12 +95,6 @@ CREATE CATALOG db2 PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/mysql.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/mysql.md index b8581a8801..e4a9f47230 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/mysql.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/mysql.md @@ -133,12 +133,6 @@ CREATE CATALOG mysql PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/oracle.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/oracle.md index 5b57b349fd..cf6f1cac3a 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/oracle.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/oracle.md @@ -89,12 +89,6 @@ CREATE CATALOG oracle PROPERTIES ( ## 查询优化 -### 统计信息 - -Apache Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 1. 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Apache Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/postgresql.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/postgresql.md index f69325ca0c..7de2d61d7e 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/postgresql.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/postgresql.md @@ -123,12 +123,6 @@ CREATE CATALOG postgresql PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/sap-hana.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/sap-hana.md index 2e149a1718..de9eff0a4c 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/sap-hana.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/sap-hana.md @@ -91,12 +91,6 @@ CREATE CATALOG saphana PROPERTIES ( ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/sqlserver.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/sqlserver.md index 3c5429965d..49ced4c195 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/sqlserver.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/database/sqlserver.md @@ -100,12 +100,6 @@ JDBC 驱动程序以及连接器自动使用传输层安全性 (TLS) 加密和 ## 查询优化 -### 统计信息 - -Doris 会在 Catalog 中维护表的统计信息,以便在执行查询时能够更好地优化查询计划。 - -可以查看 [外表统计信息](../external-statistics) 了解如何收集统计信息。 - ### 谓词下推 当执行类似于 `where dt = '2022-01-01'` 这样的查询时,Doris 能够将这些过滤条件下推到外部数据源,从而直接在数据源层面排除不符合条件的数据,减少了不必要的数据获取和传输。这大大提高了查询性能,同时也降低了对外部数据源的负载。 diff --git a/versioned_docs/version-2.0/lakehouse/database/clickhouse.md b/versioned_docs/version-2.0/lakehouse/database/clickhouse.md index 8a08d5d15f..f73dfeff2a 100644 --- a/versioned_docs/version-2.0/lakehouse/database/clickhouse.md +++ b/versioned_docs/version-2.0/lakehouse/database/clickhouse.md @@ -102,12 +102,6 @@ When mapping ClickHouse, a Database in Doris corresponds to a Database in ClickH ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.0/lakehouse/database/mysql.md b/versioned_docs/version-2.0/lakehouse/database/mysql.md index f22af1903b..a0e73b01bc 100644 --- a/versioned_docs/version-2.0/lakehouse/database/mysql.md +++ b/versioned_docs/version-2.0/lakehouse/database/mysql.md @@ -134,12 +134,6 @@ When reading MySQL's TIMESTAMP type, add parameters to the JDBC URL: `connection ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.0/lakehouse/database/oracle.md b/versioned_docs/version-2.0/lakehouse/database/oracle.md index 68598151fe..a92eeb0ec9 100644 --- a/versioned_docs/version-2.0/lakehouse/database/oracle.md +++ b/versioned_docs/version-2.0/lakehouse/database/oracle.md @@ -90,12 +90,6 @@ When mapping Oracle, a Database in Doris corresponds to a User in Oracle. The Ta ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.0/lakehouse/database/postgresql.md b/versioned_docs/version-2.0/lakehouse/database/postgresql.md index d16fe9c046..8b3882dd6a 100644 --- a/versioned_docs/version-2.0/lakehouse/database/postgresql.md +++ b/versioned_docs/version-2.0/lakehouse/database/postgresql.md @@ -124,12 +124,6 @@ In order to ensure time zone consistency, it is recommended to set the JVM time ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.0/lakehouse/database/sap-hana.md b/versioned_docs/version-2.0/lakehouse/database/sap-hana.md index 22196139a1..db2f877689 100644 --- a/versioned_docs/version-2.0/lakehouse/database/sap-hana.md +++ b/versioned_docs/version-2.0/lakehouse/database/sap-hana.md @@ -91,12 +91,6 @@ When mapping SAP HANA, Doris' Database corresponds to a Schema under the specifi ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.0/lakehouse/database/sqlserver.md b/versioned_docs/version-2.0/lakehouse/database/sqlserver.md index 3727cc8b94..ac009d1227 100644 --- a/versioned_docs/version-2.0/lakehouse/database/sqlserver.md +++ b/versioned_docs/version-2.0/lakehouse/database/sqlserver.md @@ -100,12 +100,6 @@ When mapping SQLServer, a Database in Doris corresponds to a Schema under the sp ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.1/lakehouse/database/clickhouse.md b/versioned_docs/version-2.1/lakehouse/database/clickhouse.md index dbed41474d..bc4b92ebcd 100644 --- a/versioned_docs/version-2.1/lakehouse/database/clickhouse.md +++ b/versioned_docs/version-2.1/lakehouse/database/clickhouse.md @@ -102,12 +102,6 @@ When mapping ClickHouse, a Database in Doris corresponds to a Database in ClickH ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.1/lakehouse/database/ibm-db2.md b/versioned_docs/version-2.1/lakehouse/database/ibm-db2.md index 103fb0bdd2..d8aefe33c1 100644 --- a/versioned_docs/version-2.1/lakehouse/database/ibm-db2.md +++ b/versioned_docs/version-2.1/lakehouse/database/ibm-db2.md @@ -95,12 +95,6 @@ When mapping IBM Db2, Doris' Database corresponds to a Schema under the specifie ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.1/lakehouse/database/mysql.md b/versioned_docs/version-2.1/lakehouse/database/mysql.md index df42aae0fc..faae5241a1 100644 --- a/versioned_docs/version-2.1/lakehouse/database/mysql.md +++ b/versioned_docs/version-2.1/lakehouse/database/mysql.md @@ -134,12 +134,6 @@ When reading MySQL's TIMESTAMP type, add parameters to the JDBC URL: `connection ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.1/lakehouse/database/oracle.md b/versioned_docs/version-2.1/lakehouse/database/oracle.md index 1209c03e8a..0c0651ed6e 100644 --- a/versioned_docs/version-2.1/lakehouse/database/oracle.md +++ b/versioned_docs/version-2.1/lakehouse/database/oracle.md @@ -90,12 +90,6 @@ When mapping Oracle, a Database in Doris corresponds to a User in Oracle. The Ta ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.1/lakehouse/database/postgresql.md b/versioned_docs/version-2.1/lakehouse/database/postgresql.md index d16fe9c046..8b3882dd6a 100644 --- a/versioned_docs/version-2.1/lakehouse/database/postgresql.md +++ b/versioned_docs/version-2.1/lakehouse/database/postgresql.md @@ -124,12 +124,6 @@ In order to ensure time zone consistency, it is recommended to set the JVM time ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.1/lakehouse/database/sap-hana.md b/versioned_docs/version-2.1/lakehouse/database/sap-hana.md index 22196139a1..db2f877689 100644 --- a/versioned_docs/version-2.1/lakehouse/database/sap-hana.md +++ b/versioned_docs/version-2.1/lakehouse/database/sap-hana.md @@ -91,12 +91,6 @@ When mapping SAP HANA, Doris' Database corresponds to a Schema under the specifi ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-2.1/lakehouse/database/sqlserver.md b/versioned_docs/version-2.1/lakehouse/database/sqlserver.md index 3727cc8b94..ac009d1227 100644 --- a/versioned_docs/version-2.1/lakehouse/database/sqlserver.md +++ b/versioned_docs/version-2.1/lakehouse/database/sqlserver.md @@ -100,12 +100,6 @@ When mapping SQLServer, a Database in Doris corresponds to a Schema under the sp ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-3.0/lakehouse/database/clickhouse.md b/versioned_docs/version-3.0/lakehouse/database/clickhouse.md index dbed41474d..bc4b92ebcd 100644 --- a/versioned_docs/version-3.0/lakehouse/database/clickhouse.md +++ b/versioned_docs/version-3.0/lakehouse/database/clickhouse.md @@ -102,12 +102,6 @@ When mapping ClickHouse, a Database in Doris corresponds to a Database in ClickH ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-3.0/lakehouse/database/ibm-db2.md b/versioned_docs/version-3.0/lakehouse/database/ibm-db2.md index 103fb0bdd2..d8aefe33c1 100644 --- a/versioned_docs/version-3.0/lakehouse/database/ibm-db2.md +++ b/versioned_docs/version-3.0/lakehouse/database/ibm-db2.md @@ -95,12 +95,6 @@ When mapping IBM Db2, Doris' Database corresponds to a Schema under the specifie ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-3.0/lakehouse/database/mysql.md b/versioned_docs/version-3.0/lakehouse/database/mysql.md index df42aae0fc..faae5241a1 100644 --- a/versioned_docs/version-3.0/lakehouse/database/mysql.md +++ b/versioned_docs/version-3.0/lakehouse/database/mysql.md @@ -134,12 +134,6 @@ When reading MySQL's TIMESTAMP type, add parameters to the JDBC URL: `connection ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-3.0/lakehouse/database/oracle.md b/versioned_docs/version-3.0/lakehouse/database/oracle.md index 612574ce33..e9d053fe2d 100644 --- a/versioned_docs/version-3.0/lakehouse/database/oracle.md +++ b/versioned_docs/version-3.0/lakehouse/database/oracle.md @@ -90,12 +90,6 @@ When mapping Oracle, a Database in Doris corresponds to a User in Oracle. The Ta ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown 1. When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing unnecessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-3.0/lakehouse/database/postgresql.md b/versioned_docs/version-3.0/lakehouse/database/postgresql.md index d16fe9c046..8b3882dd6a 100644 --- a/versioned_docs/version-3.0/lakehouse/database/postgresql.md +++ b/versioned_docs/version-3.0/lakehouse/database/postgresql.md @@ -124,12 +124,6 @@ In order to ensure time zone consistency, it is recommended to set the JVM time ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-3.0/lakehouse/database/sap-hana.md b/versioned_docs/version-3.0/lakehouse/database/sap-hana.md index bd8b051822..1b5b3268b8 100644 --- a/versioned_docs/version-3.0/lakehouse/database/sap-hana.md +++ b/versioned_docs/version-3.0/lakehouse/database/sap-hana.md @@ -91,12 +91,6 @@ When mapping SAP HANA, Doris' Database corresponds to a Schema under the specifi ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. diff --git a/versioned_docs/version-3.0/lakehouse/database/sqlserver.md b/versioned_docs/version-3.0/lakehouse/database/sqlserver.md index 3727cc8b94..ac009d1227 100644 --- a/versioned_docs/version-3.0/lakehouse/database/sqlserver.md +++ b/versioned_docs/version-3.0/lakehouse/database/sqlserver.md @@ -100,12 +100,6 @@ When mapping SQLServer, a Database in Doris corresponds to a Schema under the sp ## Query optimization -### Statistics - -Doris maintains table statistics in the Catalog so that it can better optimize query plans when executing queries. - -See [external-statistics](../external-statistics) to learn how to collect statistics. - ### Predicate pushdown When executing a query like `where dt = '2022-01-01'`, Doris can push these filtering conditions down to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing inaccuracies. Necessary data acquisition and transmission. This greatly improves query performance while also reducing the load on external data sources. --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org