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