Index advisor and optimizer enhancements.
Index顾问程序和优化器增强。
Run the index advisor and create new indexes or adjust existing ones.
运行索引advisor工具，并创建新索引或调整现有索引。
Index advisor: recommendations for indexes that may help improve performance.
索引advisor工具：能提升性能的索引的建议。
The spatial extender provides an index advisor that helps you to tune your spatial index.
spatial extender提供了一个index advisor，以帮助您调优空间索引。
It allows you to apply various constraints to the index advisor and see how those constraints modify the recommendations.
它能让您将各种限制应用到索引advisor工具，并看看这些限制条件如何修改建议。
You should note that the recommendations given by the Index Advisor are a starting point for your index optimization efforts.
您应该注意到，Index Advisor 提供的建议可以作为索引优化的出发点。
The DB2 spatial Extender comes with an index Advisor that you can use to optimize indexes defined on columns that contain spatial data.
DB 2Spatial Extender附带了一个Index Advisor，可以用它来优化包含空间数据的列上定义的索引。
Accurate and complete statistics will help drive good access path advice, and of course the index advisor should not be executed without good statistics.
准确而全面的统计数据能帮助生成良好的访问路径建议，当然，索引advisor工具执行时要有准确的统计数据。
The index Advisor will analyze the query and let you know if the use of indexes on the columns used in the query may help improve the performance of the query.
Index Advisor会分析查询，指出在查询中使用的列上使用索引是否可能提高查询的性能。
In the fourth chapter, we introduce a prototyped index advisor for OSCAR database engine with some advising results for database schemas and workloads from generally used database benchmarks.
第四章介绍了我们在神舟oscar关系数据库系统中实现了的索引推荐器的原型系统，同时使用标准的数据库评测基准对系统进行了测试。
As already mentioned when discussing use of the Design Advisor, you have to be careful when interpreting index usage information.
在讨论Design Advisor时已经提到，在解释索引使用信息时必须格外小心。
We will use the DB2 Design Advisor and ask DB2 for an appropriate new index on the ORG or STAFF table to improve the performance of this query.
我们将使用DB 2Design Advisor，让DB 2在ORG或staff表上创建适当的新索引，从而改进这个查询的性能。
The biggest reason to keep an index is if you know it is used by a transaction or query that you have not included in the workload used by the Design Advisor.
保留一个索引的最大理由是，您知道某个事务或查询使用了这个索引，但是您并没有将该事务或查询包括在 Design Advisor 所使用的工作负载中。
This is how the Design Advisor presents the recommendation "you'll get better performance if you switch the order of columns in the index."
Design Advisor为此提供的建议是“you' l lgetbetterperformanceif youswitchtheorderof columnsin the index . ”。
This is how the Design Advisor presents the recommendation "you'll get better performance if you switch the order of columns in the index."
Design Advisor为此提供的建议是“you' l lgetbetterperformanceif youswitchtheorderof columnsin the index . ”。
应用推荐