When the index name is not specified, optimizer picks the cheapest single XML index access plan.
如果未指定索引名，优化器将选用成本最低的XML 索引访问计划。
For example, whether ORDER BY or GROUP BY clauses are needed in the query, or if they can be resolved via index access.
例如，查询中需要ORDERBY或GROUPBY语句，或者它们能通过指数访问解决。
Generally, using this index value is not required, and there is no index access to tables of all dependency properties.
通常并不需要使用这个索引值，而且不会存取所有相依性属性的任何表索引。
An index only scan is an index access that is not followed by a table access because the index itself contains all the requested data.
仅扫描索引是未包含表访问的索引访问，因为索引本身包含了所有被请求的数据。
Now that the view injects the filter predicate at the SQL level, DB2 can take advantage of the usual database techniques, that is index access.
现在，该视图在sql级注入过滤谓词，DB 2可以利用通常的数据库技术，即索引访问。
Using this information you can confirm that columns were correctly (or not) used for index access and also to determine where a condition was filtered.
用这个信息你能确认那些列是否正确的使用了索引访问且判断条件在哪过滤的。
There is much less index access and no index AND'ing so that the overall performance can be one or two order of magnitude better - depending on predicate selectivity.
只有相当少的索引访问且没有索引AND'ing，这样整体性能将提高一个或两个数量级 ——取决于谓词选择。
Make sure that the alias and not the base table name is specified in the table attribute in the optimization guideline. For example, to request an XML index access for the following query.
确保优化准则的table属性中没有指定别名和基本表名。
If you use a single page size for relational and XML data, or for data and indexes, a 32kb page size may be beneficial for XML data but somewhat detrimental for relational data and index access.
如果为关系数据和XML数据，或者为数据和索引使用单一的页宽，那么32kb的页宽对于XML数据而言可能有利，但是不利于关系数据和索引的访问。
With this feature, the query optimizer can immediately consider the index when determining an access plan.
有了这个特性，查询优化器可以在决定访问计划时立即考虑索引。
In this scenario, after analysis, it was determined that it will be optimum to use the index I11 to access the table TAB1, but the default behaviour of the optimizer did not, even after tuning.
在这个场景中，经过分析，可以确定使用索引i 11来访问表tab 1是最优的，但是优化器的默认行为不会这么做，即使在调优之后也仍然不会这样做。
The index used to access items just states how far past the first item in the collection, or sequence, you need to go to get what you want.
用于访问数据项的索引只声明集合中越过第一个数据项有多远，或者称为序列，您需要去获得所需的内容。
You can define an index specification for this remote object, to make the federated server aware of the index and facilitate the access of this remote object.
您可以为这个远程对象定义一个索引规范，以使得联邦服务器知道索引，并且便于对这个远程对象的访问。
In Part 5, I discuss code completion and content assist, including how they work and how they access the PDOM index.
在第5部分中，我将探讨代码完成及内容协助，包括二者如何工作以及如何访问PDOM索引。
In the previous section you learned about one type of access method, index scan (IXSCAN), and one type of join method, nested loop join (NLJOIN).
在之前的部分您已经了解了一种类型的访问方法，即索引扫描(IXSCAN)，和一种类型的联接方法，即嵌套循环联接(NLJOIN)。
This guideline specifies that a single XML index scan be used to access the given table.
该准则指定一个单一的xml索引扫描，将用于访问给定的表。
An appropriate access path means that an index is available and used so that the index drives the access to the data.
恰当的访问路径意味着一个索引可用并且已使用，所以该索引能够方便地对该数据进行访问。
The example guideline in Listing 16 specifies that some XML index be used to access the table SECURITY.
清单16中的示例准则指定必须使用一些XML索引来访问表SECURITY。
You may also need to design indexes to avoid data sort and to provide index only access.
您也许还要设计索引以避免数据排序并提供只带索引的访问。
There is an attribute RUNSTATS TIMESTAMP on the table or index node of the access plan graph that indicates the last time when the statistics were collected.
在访问计划图的表或索引节点上会有一个RUNSTATSTIMESTAMP属性，它表示收集统计数据的时间。
Here a maximum number of two applications can concurrently access 'INDEX 1', and a maximum number of three applications can concurrently access 'INDEX 2'.
按照这段代码，最多有两个应用程序可以同时访问‘INDEX1’，最多有三个应用程序可以同时访问‘INDEX2’。
Access plan for query accessing a hash index.
访问hash索引的查询的访问计划。
Since the data is spatial, you need to specify the R-Tree access method for this index.
由于涉及到空间数据，您需要为这个索引指定r - Tree访问方法。
A change that introduces some sort of index that allows access to random elements of the large retransmission queue is critical to address the find-first attacks against the TCP stack.
这个改变引入一些索引，允许对大的重传队列中的元素进行随机访问，这个改变对于解决TCP协议栈的find - first攻击问题很重要。
A functional index can specify different access methods that include B-Tree, R-Tree, and user-defined access methods.
函数索引可以指定各种不同的访问方法，包括B -Tree、r - Tree和用户定义的访问方法。
Run the index Data service under a user who has exclusive access to both the service process and the index files.
同时在能够独自访问服务流程和索引文件的用户下运行IndexDataService。
The access element further specifies that some XML index must be used to access the table CUSTACC.
ACCESS元素进一步指定必须使用某些xml索引来访问表custacc。
The IXAND access request element directs the optimizer to use index anding to access a table.
IXAND访问请求元素要求优化器使用indexanding访问表。
Since DB2 will only use the index the "traditional" way for index-only access, the rows will be returned just like our index data, in groups of identical LASTNAMEs in random order.
因为DB 2仅将以“传统”方式使用索引，以实现仅限索引的访问，各行将像我们的索引数据一样，在同样的LASTNAME小组以随机形式返回。
Typically, a non-matching index scan is chosen by the optimizer when the underlying index provides benefits such as index-only access, avoids sort, or some similar benefit.
通常情况下，在基础索引提供好处(如唯一索引访问、避免排序或一些类似的好处)时，可通过优化器选择非匹配索引扫描。
应用推荐