Creating indexes to improve runtime performance.
创建索引以改善运行时性能。
Isn't there software for automatically creating indexes?
有自动编制索引的软件吗？
Creating indexes for better performance with IBM TSOM historical queries.
通过创建索引提高IBMTSOM历史数据查询性能。
Indexes view a "Allows creating indexes for the columns defined in the columns view."
Indexes视图—允许创建Columns视图中定义的列的索引。
UPDATE STATISTICS should be run after initially loading the data and creating indexes.
初次装载数据和创建索引之后，应该运行UPDATESTATISTICS。
Consider creating indexes for attributes that are part of frequently executed searches.
对于频繁执行的搜索，可以考虑为其中的属性创建索引。
Each designer allows creating indexes, constraints, keys, and triggers (where applicable).
每种设计器允许创建索引、约束、键和触发器(如适用)。
A high value here can indicate excessive table scans that can be prevented by creating indexes on the predicate columns.
如果该值很大，表示可以通过对谓词列创建索引来避免多余的表扫描。
Creating indexes helps avoid unnecessary table scans and sorts, speeds up frequently executed queries, and ensures uniqueness.
索引的创建有助于避免对表进行不必要的扫描和排序，加速频繁执行的查询以及确保惟一性。
Since MQTs are local tables that cache the results of a query, the same considerations for creating an index on a local table apply to creating indexes on MQTs.
因为MQT是缓存查询结果的本地表，所以在本地表上创建索引的相同步骤也可应用于在 MQT 上创建索引。
Creating proper indexes improves the performance of the query.
创建恰当的索引将提高查询的性能。
Tasks include planning and administering the database, tuning for performance and capacity, creating and maintaining indexes and optimizing queries, monitoring, and managing backup and recovery.
任务包括计划并管理数据库、调优性能与容量、创建和维护索引并优化查询、监测、以及管理备份与恢复。
These types of tasks are related to creating and managing objects in the database, such as tables and indexes.
这些类型的任务与在数据库中创建并管理对象相关，比如表和索引。
For example, the predicates of the SQL statements in your important DB2 work (see discussion above) should be a primary guide in creating the best indexes.
例如，在创建最佳索引时，应该将重要DB 2工作(请参阅前面的讨论)中sql语句的谓词作为主要指南。
The in-depth discussion and examples that follow explore creating and using functional indexes and how to generate and examine query plans.
接下来将深入讨论如何创建和使用函数索引，以及如何生成和检验查询计划，并提供具体的示例。
In addition, you will learn how to create and use functional indexes and be given a list of things to consider before creating functional indexes.
此外，您还将了解如何创建和使用函数索引，以及在创建函数索引之前需要考虑的一些问题。
In my next column, I'll show you that there are plenty of things you can do to improve query response times without creating new indexes.
在下一个专栏中，我将向您展示，有很多方法无需创建新索引即可改善查询相应时间。
Row 2 shows the statistics after collecting the relevant statistics, and row 3 shows the results after creating the suggested indexes.
第2行显示收集相关数据后的统计数据，第3行显示创建建议索引后的结果。
XML tasks: creating and maintaining tables and views with XML data; creating and tuning XML indexes; querying and viewing XML documents; storing and managing XML schema documents.
XML任务：创建并维护具有XML数据的表和视图；创建并调优xML索引；查询并查看XML文档；存储并管理XML模式文档。
The list of recommendations includes: (1) keeping the two existing indexes on the CUSTOMER table and (2) creating 1 index and keeping 1 index for the DISTRICT table.
建议包括：(1)保留CUSTOMER表上已有的两个索引，并且(2)创建一个索引，保留用于DISTRICT 表的一个索引。
Furthermore, if indexes already exist for both columns (one for EMPNO and one for DEPTNO), DB2 can use them both to satisfy this query so creating another index might not be necessary.
而且，如果已经存在关于这两列的索引(一个关于EMPNO，一个关于DEPTNO)，DB 2可以使用它们来满足该查询，因此创建另一个索引也许是没有必要的。
After creating the three new indexes, you get the new access plan graph shown in Figure 13.
创建三个新索引之后，您图13中的新访问计划图。
This class is responsible for creating on-the-fly, volatile indexes, directly in RAM.
此类负责直接在RAM中创建动态、可变的索引。
Creating and reorganizing XML indexes online.
在线创建和重组xml索引。
Creating and dropping indexes without locking tables.
在不锁定表的情况下创建和删除索引。
Syntax for creating additional indexes on these tables.
在这些表上创建额外的索引的语法。
You should run reorg and runstats after creating new indexes, as shown below.
您在创建新索引之后运行reorg和runstats命令，如下所示。
This helps Design Advisor to better estimate how much database performance would be improved by creating new indexes.
这能够帮助Design Advisor更好地估计创建新的索引能够对数据库性能有多大的改进。
For example, the DB2 Fundamentals exam tests a candidate's knowledge of security; creating and working with tables, indexes, and views; using SQL; and isolation levels and locking.
例如，DB 2Fundamentals考试测试考生的安全知识，表、索引和视图的创建和使用，SQL使用，以及隔离级别和锁定。
Of course, if you already have a lot of indexes on the EMP table, you might want to examine the impact of creating yet another index on the table. Factors to consider include
当然，如果您已经有许多关于 EMP表的索引，您也许应该检查再创建另一个关于表的索引所带来的影响。
应用推荐