仅当查询中有非索引连接列或过滤列时，才使用UPDATESTATISTICSMEDIUMDISTRIBUTIONS。
Use UPDATE STATISTICS MEDIUM DISTRIBUTIONS ONLY if queries have non-indexed join columns or filter columns.
您将找到的大部分结果都是哈希索引站点——有意地连接散列值和其相应关键字的站点。
Most of the results you'll find are hash indexing sites — sites intentionally built to connect hash values and their corresponding keys.
您需要使用本地谓词和连接谓词设计索引，以支持高效访问。
You need to design indexes to support efficient access with local predicates and join predicates.
如果连接列上有一个索引，那么其成本会相当低；否则，数据库服务器就必须对所有表(外部和内部表)执行表扫描。
If there is an index on the join column, the costs will be significantly less; otherwise the database server must perform table scans for all tables, both outer and inner tables.
另外，DB 2无法在排序合并合并连接中使用随机顺序的索引列。
Also, DB2 cannot use random order index columns as part of a sort merge join.
因为该连接是在索引上执行的，所以其成本要低得多，而数据访问则快得多。
Since the join is performed on indexes, the costs are much lower and the speed of accessing data much faster.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
This is a lot faster than a nested loop join of two table scans without any index usage.
这意味着可以使用它们来索引频繁在谓词和连接中使用的所选择的元素和属性。
That means you can use them to index selected elements and attributes that are frequently used in predicates and joins.
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
You can define guidelines that influence only a few attributes of an execution plan, such as index specification for a certain table in the query or join order for a pair of tables.
如果连接列上不存在索引，那么优化器将选择动态哈希连接。
The optimizer will choose dynamic hash join if none of the joined columns has index.
因此，我们在这些连接列上添加了索引，从下列查询执行计划中我们可以看到，查询成本减少了很多。
So we added indexes on those joining columns and from the following query execution plan, we can see the query cost is greatly reduced.
在数据库服务器使用所有表筛选器之后，从外部表检索出的行数将很少，而内部表具有一个可用于执行连接的索引。
The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.
连接的组织资源越多，社会协作索引的次数就越高，产生的“社会软件”的质量就越高。
More connected the resources of an organization are, higher is the social collaboration index and higher is the quality of the "social software" generated.
该查询检索了所需的作者信息，但是没有将索引用于连接处理。
This query retrieves the desired author information, but it would not use either of the indexes for the join processing.
因此，DB 2可以使用DOUBLE索引用于快速连接处理。
Therefore, DB2 can use a DOUBLE index for faster join processing.
让推荐的实例运行，且仅用一个连接防止同时执行多个索引任务。
Having the recommended one running instance, and only one connection will prevent multiple indexing tasks from executing at the same time.
可用于索引的高亲和性连接的数量必须等于在托管索引更新服务的服务器上可用的CPU数量。
The total number of high-affinity connections that are available for indexing must be equal to the number of CPUs that are available on the servers that host the index update service.
CHGLFM将把与连接逻辑文件有关的所有二级索引移入或移出ssd。
CHGLFM will move all the secondary indexes associated with a join logical file on or off of SSDs.
优化器然后使用复合索引将临时表连接到事实表，来快速定位在维度表中满足条件的行。
The optimizer will then join that temp table to the fact table using the compound index to quickly locate the rows that satisfy the criteria on the dimension tables.
总成本取决于连接列上是否有索引。
The overall cost depends on whether there is an index on the join columns.
当连接执行时，合并选中的索引，此时维度表中的任何列都可使用。
When a join is executed that incorporates an index that is selective, any column in the dimension table can be used.
可以为DDS创建的连接逻辑文件创建多个索引。
Multiple indexes may be created for a DDS-created join logical file.
对于cust_order_header表，现有的索引表不支持表上的本地和连接谓词，如下所示。
For table CUST_ORDER_HEADER, both of the existing indexes do not support the local and join predicates on the table, as shown below.
下推连接键可用于索引下推或位向量下推。
The pushed-down join keys can be used in an index pushdown or a bit-vector push-down.
为了可以对一个表或索引收集统计信息，必须能够连接到包含该表和索引的数据库，并具有下列授权级别之一
To be able to collect statistics against a table or index, one must be able to connect to the database that contains the tables and indexes and have one of the following authorization levels
下列代码显示了连接Solr服务、向索引中添加两个文档和运行先前使用的零部件号查询的PHP应用程序。
The code below shows a PHP application that connects a Solr service, adds two documents to the index, and runs the part number query used previously.
如果查询中有属于多列索引的连接列或过滤列，则使用UPDATESTATISTICSHIGH。
Use UPDATE STATISTICS HIGH if queries have a multi-column indexed defined on join columns or filter columns.
使用适于XML连接谓词的索引。
如果将xml索引定义为double，则用xs： double转换连接谓词。
If the XML index is defined as double, you cast the join predicate with xs: double.
严格来说，DB 2 9.7不一定要使用fn：string来为连接谓词启用varchar索引。
Strictly speaking, DB2 9.7 does not necessarily require the use of fn: string anymore to enable VARCHAR indexes for join predicates.
应用推荐