You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2024/02/21 06:03:19 UTC
(doris) 04/19: [fix](docs) add joinHint.md to sidebars (#31155)
This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 7c1bb4cb22dae17c6d73ef568a5220a3630c6b4f
Author: yagagagaga <zh...@gmail.com>
AuthorDate: Tue Feb 20 19:37:11 2024 +0800
[fix](docs) add joinHint.md to sidebars (#31155)
---
docs/en/docs/query-acceleration/hint/joinHint.md | 2 ++
docs/sidebars.json | 7 +++++++
docs/zh-CN/docs/query-acceleration/hint/joinHint.md | 3 +++
3 files changed, 12 insertions(+)
diff --git a/docs/en/docs/query-acceleration/hint/joinHint.md b/docs/en/docs/query-acceleration/hint/joinHint.md
index af120425cc8..adce5d9ddca 100644
--- a/docs/en/docs/query-acceleration/hint/joinHint.md
+++ b/docs/en/docs/query-acceleration/hint/joinHint.md
@@ -1,5 +1,7 @@
# join hint using document
+<version since="2.0.4"></version>
+
In the database, "Hint" is an instruction that instructs the query optimizer to execute a plan. By embedding hints in SQL statements, you can influence the optimizer's decision to select the desired execution path. Here is a background example using Hint:
Suppose you have a table that contains a large amount of data, and you know that in some specific circumstances, the join order of the tables in a query may affect query performance. Leading Hint allows you to specify the order of table joins that you want the optimizer to follow.
diff --git a/docs/sidebars.json b/docs/sidebars.json
index f02c6782d0d..9a16dab7590 100644
--- a/docs/sidebars.json
+++ b/docs/sidebars.json
@@ -216,6 +216,13 @@
"query-acceleration/async-materialized-view/async-materialized-view",
"query-acceleration/async-materialized-view/query-async-materialized-view"
]
+ },
+ {
+ "type": "category",
+ "label": "Hint",
+ "items": [
+ "query-acceleration/hint/joinHint"
+ ]
}
]
},
diff --git a/docs/zh-CN/docs/query-acceleration/hint/joinHint.md b/docs/zh-CN/docs/query-acceleration/hint/joinHint.md
index 269eb9a7ee6..926104f5939 100644
--- a/docs/zh-CN/docs/query-acceleration/hint/joinHint.md
+++ b/docs/zh-CN/docs/query-acceleration/hint/joinHint.md
@@ -1,4 +1,7 @@
# join hint 使用文档
+
+<version since="2.0.4"></version>
+
# 背景
在数据库中，"Hint" 是一种用于指导查询优化器执行计划的指令。通过在SQL语句中嵌入Hint，可以影响优化器的决策，以选中期望的执行路径。以下是一个使用Hint的背景示例：
假设有一个包含大量数据的表，而你知道在某些特定情况下，在一个查询中，表的连接顺序可能会影响查询性能。Leading Hint允许你指定希望优化器遵循的表连接的顺序。
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org