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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
