Find the top join node in a query plan.
查找一个查询计划中的顶级连接节点。
This query plan shows a full table scan.
该查询计划显示了一个全表扫描。
Below is an example of how a query plan would look like for the query.
通过下面的例子可以看到查询的查询计划是什么样子？
Constructing an appropriate cost model has important effect on selecting a query plan.
构造一个合适的代价模型对查询计划的选择有着十分重要的影响。
Figure 2 shows a possible plan for this query.
图2显示了这个查询的一个可能的计划。
Use EXPLAIN command to see the explain plan of a query.
使用EXPLAIN命令查看查询的解释计划。
Query Explain Use EXPLAIN command to see the explain plan of a query.
查询解释使用EXPLAIN命令查看查询的解释计划。
Access plan for query accessing an inverted text index.
访问反向文本索引的查询的访问计划。
Access plan for query without inverted text index.
未使用反向文本索引的查询的访问计划。
The original query and its execution plan.
原始查询及其执行计划。
Access plan for query without hash index.
不使用hash索引的查询的访问计划。
A query access plan similar to the following is chosen by the optimizer.
优化器会选择类似如下所示的查询访问计划。
Generate the access plan again for the query. It should look similar to this.
再次生成查询的访问计划。
Generate the access plan again for the query. It should look similar to this.
再次生成查询的访问计划。
应用推荐