结构描述是利用拓扑连接索引。
The structural descriptors utilized are the topological connectivity indexes.
文中提出了一种基于数据仓库和位图连接索引的查询方法。
This paper will optimize the processing of join query based on join index.
每个服务器维护其自己的连接索引，广播到所有服务器的传入连接和断开连接。
Each server Maintains Its Own connection Index, Broadcast incoming connections and disconnections to all servers.
直接建立维度表与事实表的位图连接索引会产生大量无用的索引项，影响查询效率。
Building bitmap join indexes of dimension tables and fact tables directly may bring a large number of useless index items that affect query efficiency.
空间数据的无序性，使得应用在其上的利用连接索引的算法需要进一步的改进，为此分析了其中关键的最佳页访问次序问题。
For the reason of the no order of space data, the algorithm based on join index have to improve for it. The key problem of optimal page-access sequence with a fixed Buffer has been analyzed.
您将找到的大部分结果都是哈希索引站点——有意地连接散列值和其相应关键字的站点。
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.
这意味着可以使用它们来索引频繁在谓词和连接中使用的所选择的元素和属性。
That means you can use them to index selected elements and attributes that are frequently used in predicates and joins.
如果连接列上不存在索引，那么优化器将选择动态哈希连接。
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.
下推连接键可用于索引下推或位向量下推。
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.
应用推荐