In the first installment of this two-part column, I focused on the pros and cons of reducing query times by adding indexes to a DB2 database.
在这个两部分系列的第一期中，我重点介绍了通过将索引添加到DB 2数据库来减少查询次数的优势和缺点。
It queries your database, indexes each column in each row of the result, and ties each index entry to the row's primary key.
它将查询数据库，为结果的每行中的每列建立索引，并且将每个索引条目绑定到行的主键上。
Automatically adjust execution strategy to accomodate changes in underlying database schemas, such as the addition of new indexes.
自动调整执行策略，以便在基础数据库模式中应用更改，比如添加新的索引。
Database developer — Responsible for the actual databases in operation, including designing databases, schemas, tables, table relationships, and indexes as well as optimizing queries.
数据库开发人员——负责实际运行的数据库，包括设计数据库、模式、表、表关系、索引，以及对查询进行优化。
Changing the database in other ways, including adding, dropping, or modifying indexes or other constraints.
以其他方式修改数据库，包括添加、删除或修改索引或其他约束。
After enabling a database for text, you can create text indexes on columns storing textual data in various formats, such as XML.
在为数据库启用文本搜索操作之后，可以在以各种格式(比如xml)存储文本数据的列上创建文本索引。
Database engines are designed to build indexes of the records in tables based on the designated key fields.
设计数据库引擎是为了基于指定关键字段构建表中记录的索引。
Suppose a table in an OLTP database already has 6 or 7 indexes. Would I give a thumbs-up to adding another?
假设 OLTP数据库中的一个表已经拥有6 个或7 个索引，我还会赞成再添加一个吗？
In most cases the BPM product's datastore has not been defined in such a way that all the database indexes that might potentially be used have been defined.
在多数情况下，BPM产品的数据存储没有以以下方式定义：有可能使用的所有数据库索引都已经定义。
XML indexes can be created on a particular node of the XML documents stored in the database.
可以在数据库中XML文档的特定节点上创建 XML索引。
You can think of an SQL schema in DB2 as a way to group different database objects such as tables, views, indexes, and others.
可以把DB 2中的SQL模式看作不同数据库对象(比如表、视图、索引等)的分组方式。
It includes the indexes that are used, The Times at which fields are retrieved from the database tables, and the order of steps in which the query is executed.
它包括所使用的索引、从数据库表中检索字段的次数，以及执行查询的步骤的顺序。
We created these indexes because the FPMLADMIN.FPML43 table in the sample database is 4mb and contains nearly 900 rows.
我们创建了这些索引，因为样例数据库中的FPMLADMIN. FPML43表有4MB，包含近900行。
Every 15 minutes, the Domino server runs the update task to refresh all view indexes in a database.
每过15分钟，Domino服务器就会运行更新任务来刷新数据库中所有视图索引。
In particular, making schema changes or adding indexes to a database with more than 10-20 million rows completely locks the database for hours at a time.
尤其是有一两千万行数据的时候，每次修改模式、往数据库中添加索引都会数小时完全锁定数据库。
Using XQuery and XML indexes, this stored XML data can now be searched and retrieved intact into the application, in the same way that you would retrieve a large character object from the database.
通过使用XQuery和xml索引，现在可以在应用程序中按原样搜索和获取存储的XML数据，采用的方式与从数据库获取大字符对象相同。
The first example in this article describes the basic concepts of hash indexes and illustrates how a hash index can easily be integrated in your DB2 database.
本文中的第一个例子描述hash索引的基本概念，并演示如何将hash索引轻松地集成到DB 2数据库中。
When reorganizing XML indexes, database administrators can use the allow write ACCESS clause in the reorg indexes command to allow concurrent writes on the table.
在重组xml索引时，数据库管理员可以通过在REORGINDEXES命令中使用ALLOWWRITEaccess子句允许并发的写操作。
All database tables and indexes are kept in memory and never saved to disk.
所有数据库表和索引都放在内存中，而且永远不会保存到磁盘上。
These types of tasks are related to creating and managing objects in the database, such as tables and indexes.
这些类型的任务与在数据库中创建并管理对象相关，比如表和索引。
However, in the absence of data distributions, the database server calculates selectivity for filters of different types based on table indexes.
但是，如果没有数据分布，则数据库服务器根据表索引计算不同类型的过滤器的选择率。
Your database needs information, often in the form of indexes, to perform well.
数据库需要信息，这些信息经常以索引的格式才能有不错的性能。
Listing 7 shows how to use the db2pd utility to get this information for all indexes on all tables in a database.
清单7显示了如何使用db 2 pd实用程序为数据库中的所有表上的索引获取该信息。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
Design Advisor 非常适合为数据仓库优化数据库设计，因为除了关于索引的建议之外，它还可以提供关于MQT、MDC和DPF分区键的建议。
In many cases, a native XML database can evaluate an XQuery or XPath expression and resolve the query directly from the indexes, without ever having to retrieve a document.
在很多情况下，原生xml数据库都能够计算XQuery或XPath表达式并从索引直接处理查询，无需检索任何文档。
We also set up the spatial database in order to make geographic information coordinate with tax indexes.
构建空间数据库、建立空间信息与税务数据相结合的税务管理空间地图。
Displays a list of all of the names of columns in this database that have unique single-column indexes.
显示此数据库中具有唯一单列索引的所有列的名称列表。
Displays a list of all of the names of columns in this database that have unique single-column indexes.
显示此数据库中具有唯一单列索引的所有列的名称列表。
应用推荐