When the optimizer can choose a star join plan.
优化器何时可以选择星型连接计划。
The order of indexes is chosen by the optimizer.
索引的顺序由优化器选择。
By default, the optimizer considers this type of scan.
默认情况下,优化器考虑这种类型的扫描。
The choice of the access method is left to the optimizer.
选择访问方法的任务交给优化器来完成。
The following explains why the optimizer would add a SORT node.
以下解释了为什么优化器将添加SORT节点。
Another way to influence the optimizer is to use query directives.
影响优化器的另一种方式就是使用查询命令。
Multiple index scans in the optimizer are another big win for OLTP.
优化器中的多索引扫描是OLTP的另一大赢点。
The sort heap size is used by the optimizer in determining access paths.
优化器用排序堆大小来确定存取路径。
A query access plan similar to the following is chosen by the optimizer.
优化器会选择类似如下所示的查询访问计划。
For example, the optimizer must determine whether indexes should be used.
例如,优化器必须确定是否应使用索引。
A value of -1 means that the optimizer determines the degree of asynchrony.
若该选项值为- 1,则意味着优化器自行决定异步程度。
The estimated costs are cost units that the optimizer uses to compare query plans.
估算成本是优化器用来比较查询计划的成本单元。
The important information used by the optimizer for a tablespace is the following.
下面是优化器为表空间所使用的重要信息。
Therefore the optimizer is aware of the different frequencies of the available models.
因此,优化器清楚各种已有型号出现的不同频率。
As you can see, the optimizer creates a virtual table to process the IN-list sub-query.
如您所见,优化器创建了一个虚拟表来处理in列表子查询。
The value ANY allows the optimizer to determine the number of ATQs for a given query plan.
值ANY允许优化器决定一个给定查询计划的 ATQ的数量。
The lower this value is the more likely the optimizer will choose to scan the grid index.
这个值越低,优化器就越有可能选择扫描网格索引。
Note: Here is a query for which the optimizer cannot consider using the functional index.
注意:优化器不会对下面这个查询使用函数索引。
The inconsistent statistics may also mislead the optimizer into choosing a bad access path.
不一致的统计数据还会误导优化器选择糟糕的访问路径。
This can happen when the optimizer does not have the necessary information at planning time.
如果优化器在计划时没有必要的信息就会造成这种情况。
You can use the following command to tell the optimizer to not use any optimization profile.
可以使用以下命令告诉优化器不要使用任何优化配置文件。
Goal directives that force the optimizer to use the designated rules to return query results.
目标指示,强制优化器使用指定的规则来返回查询结果。
Keep in mind that this catalog data is what the optimizer USES to make access path decisions.
请记住,优化器使用编目数据决定访问路径。
For example, what if the two local predicates are not as selective as estimated by the optimizer?
例如,如果这两个本地谓词选择性没有优化器评估的强,怎么办?
In other words, the optimizer overestimated the selectivity of the local predicates on the table.
换句话说,优化器过高估计了本地谓词对表格的选择性。
Analyze the query access plan to visualize the choices the optimizer makes in accessing the data.
分析查询访问计划,从而可以切实看到优化器对访问数据作出的选择。
As a consequence, the optimizer usually makes sub-optimal decisions, leading to poor performance.
因此,优化器常常作出非最优决策,从而导致低劣的性能。
Instead, the optimizer gathers up-to-date statistics on every database table referenced in a query.
相反,优化器将对查询中引用的每个数据库表收集最新的统计数据。
At each operator in the access plan, the optimizer estimates the cardinality output from the operator.
对于访问计划的每个操作符,优化器将估计该操作符的基数输出。
Keyword 'ANY' : This setting indicates that MQTs will be considered by the optimizer to process queries.
关键字'ANY ':该设置表明MQT将被优化器考虑来处理查询。
应用推荐