This is an automated email from the ASF dual-hosted git repository. kassiez 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 6ca205c4865 Update transparent-rewriting-with-async-mv.md (#1357) 6ca205c4865 is described below commit 6ca205c48650beeb657e3c2a416ba553b13088cc Author: xzj7019 <xiongzhongj...@selectdb.com> AuthorDate: Fri Nov 15 16:25:30 2024 +0800 Update transparent-rewriting-with-async-mv.md (#1357) # Versions - [ ] dev - [ ] 3.0 - [x] 2.1 - [ ] 2.0 # Languages - [ ] Chinese - [ ] English --- .../tuning/tuning-plan/transparent-rewriting-with-async-mv.md | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/tuning-plan/transparent-rewriting-with-async-mv.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/tuning-plan/transparent-rewriting-with-async-mv.md index e86692960c7..1b22788932b 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/tuning-plan/transparent-rewriting-with-async-mv.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/tuning-plan/transparent-rewriting-with-async-mv.md @@ -34,9 +34,10 @@ under the License. ### 1 创建基础表与数据插入 -首先,在 TPC-H 数据库中创建 `orders` 和 `lineitem` 两张表,并插入相应的数据。 +首先,创建tpch数据库并在其中创建 `orders` 和 `lineitem` 两张表,并插入相应的数据。 ```sql +CREATE DATABASE IF NOT EXISTS tpch; USE tpch; -- 创建 orders 表 @@ -221,4 +222,4 @@ DROP MATERIALIZED VIEW mv1; 6. 适用场景:物化视图适用于数据变化频率较低、查询频率较高的场景。对于经常变化的数据,实时计算可能更为合适。 -合理利用物化视图,可以显著改善数据库的查询性能,特别是在复杂查询和大数据量的情况下。同时,也需要综合考虑存储、维护等因素,以实现性能和成本的平衡。 \ No newline at end of file +合理利用物化视图,可以显著改善数据库的查询性能,特别是在复杂查询和大数据量的情况下。同时,也需要综合考虑存储、维护等因素,以实现性能和成本的平衡。 --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org