Query Tuner also provides index advice.
QueryTuner还提供索引建议。
Plus, it includes a built-in TV tuner and GPS.
另外,它还内置了一块电视视频卡和gps。
Integrated internal HDTV tuner for OTA broadcasts.
内部集成空中传送频道的高清电视调谐器。
For each table reference in the query, query Tuner adds the following annotations.
对于查询中的每个表引用,QueryTuner会添加以下注释。
You also can use Optim Query Tuner to analyze and tune the performance of your queries.
您也可以使用OptimQueryTuner来分析和优化查询性能。
You have also been shown ways to accelerate query tuning by using the Query Tuner advisors.
我们还演示了如何使用QueryTuner advisor 工具来加快查询调优。
It looks more like a small TV set than a computer and, in fact, comes with a built-in TV tuner.
它看上去更像一台小电视而非电脑,而它实际上也带有内置的电视调谐器。
This 54-inch plasma set is one inch slim with no visible inputs, tuner or tangle of cables.
这台54英寸的等离子电视只有一英寸厚,没有可视输入信号、电视调频器以及电缆线圈。
Figure 6 is the access path graph generated by query Tuner for the sample query in this article.
图6是QueryTuner为本文中大的查询样例生成的访问路径图。
You can select the costliest query, and you can launch Optim Query Tuner directly from that view.
您可以选择成本最低的查询,并可以从那个视图直接启动OptimQueryTuner。
Optim query Tuner can format the problem query, which provides a good starting point for analysis.
OptimQueryTuner可以格式化问题查询,这为以后的分析提供了一个良好开端。
Figure 1 is the access path graph generated by Optim query Tuner for the query shown in Listing 1.
图1是通过清单1所示的适用于查询的OptimQueryTuner生成的访问路径图。
Query Tuner provides a visualization of the processing that your data server uses to run a query.
在QueryTuner 中可以看到您的数据服务器运行查询的处理过程。
Reports generated by the workload tuner offer a wealth of detailed information about your objects.
工作负载调优器生成的报告提供了关于您的对象的丰富的细节信息。
An index scan is typically shown in Query Tuner as a group of four nodes in the access path graph.
在访问路径图中,一个索引扫描通常作为一组四个节点显示在QueryTuner上。
These TVs are normally 480p displays with an analog tuner (for the normal channels 2 through 83) built in.
通常具有480p的屏和一个内建的模拟调谐器。
Notice that there can be no mention of the screen or the tuner, because these are internal system elements.
请注意,这里并没有提到屏幕或者调节器,这是因为它们都是内部的系统元素。
The description of each operation includes a Query Tuner access path graph that explains its operational semantics.
每一个操作的描述都包括一个解释其操作语义的QueryTuner访问路径图。
It includes graphics APIs for drawing on the screen, a tuner API for finding and showing TV channels, and many other APIs.
这包括屏幕上显示的图形化api、查找和显示电视频道的解调器api,以及许多其他API。
You can save them for later execution, or run them directly from the Query Tuner client if you have the appropriate authority.
您可以将其保存以后执行,或者,如果您有适当权限,可以直接在QueryTuner客户端中运行。
A small Eee PC, hooked up to your sound system, will cost no more than a mid-price tuner. A lifetime of musical exploration beckons.
买一个花费不超过中等价位调谐器的小型EeePC,再连上你的音响系统,伴随一生的音乐之旅就向你招手了。
The SQL statement in Listing 2 creates the access path graph shown on the right side of the Optim Query Tuner screenshot in Figure 2.
清单2中的sql语句创建如图2上的OptimQueryTuner截图右侧所示的访问路径图。
Note, you can specify a threshold in the Query Tuner preferences to define how old statistics are before they are considered obsolete.
请注意,您可以在QueryTuner优先权中设置一个阈值,定义多旧的数据可认为过时。
Based on this idea, you should perform the following tasks to tune the query completely, which you can do from within query tuner.
根据这个思路,您应该执行以下步骤对查询进行完全的调优,这些都可以在QueryTuner中完成。
This section illustrates how the query Tuner query annotation and access path graph can help you analyze access paths and SQL performance.
本部分说明QueryTuner查询注释和访问路径图如何帮助您分析访问路径和SQL性能。
Table 1 describes the input, output, and function of several operation nodes that typically appear in an Optim Query Tuner access path graph.
表1描述通常出现在OptimQueryTuner访问路径图上的输入、输出和几个操作节点的功能。
Note that this article mainly focuses on the query tuning methodology and USES screen captures from Optim query Tuner to illustrate the points.
请注意,本文主要关注的是查询调优方法,并使用OptimQueryTuner的屏幕截图来演示要点。
For brevity, this article series USES the name Optim query Tuner to refer to the set of advisors and tools that provide Optim query tuning solutions.
为了简便起见,本文章系列使用OptimQueryTuner名称来指提供Optim查询调优解决方案的顾问和工具集。
For brevity, this article series USES the name Optim query Tuner to refer to the set of advisors and tools that Optim query tuning solutions provide.
简单起见,本文使用OptimQueryTuner名称来指代opt im查询调优解决方案提供的advisor和工具。
Another option is to use Query Tuner to capture statements from the statement cache and to view the statement runtime information, as shown in Figure 7.
另一个选择是使用QueryTuner从状态缓存获取状态,并查看状态运行时信息,如图7所示。
应用推荐