For index scans, the index must be a type-2 index.
对于索引扫描，索引必须是type - 2索引。
This view supports parallel partitioned index scans.
此视图支持并行分区索引扫描。
Multiple index scans in the optimizer are another big win for OLTP.
优化器中的多索引扫描是OLTP的另一大赢点。
With the newly created indexes, all tables are accessed with index scans.
有了新建的索引，所有表都可以用索引扫描访问。
Number of unrestricted full scans. These can either be base table or full index scans.
扫描聚集索引，可以扫描全部内容，也可以只扫描一个范围。
This makes DB2 queries use table scans instead of index scans and degrades database performance.
这使得DB 2查询使用表扫描代替索引扫描，并降低了数据库的性能。
A: With global index scans, the index look-up determines whether a reference to a partition exists.
A：索引查找利用全局索引扫描，来确定对分区的引用是否存在。
Contiguity of physical data or keys is important to the speed of table scans or key-index scans.
物理数据或键的连续性对于表扫描或键-索引扫描的速度十分重要。
Instead DB2 needs to compute the intersection two index scans, which is often significantly more costly.
或者DB 2必须计算两个索引扫描的交集，通常这样做的开销将相当高。
Global indexes preserve the order property from index scans, and this gives them an edge over local indexes.
全局索引保留来自索引扫描的顺序属性，这是相对于本地索引的一个优势。
However, with local index scans, a partition needs to be locked first to do the index look-up and find a match.
然而，对于本地索引扫描，需要锁定的分区首先要做索引搜索并发现匹配。
The option can be used in non matching index scans in a screening fashion and as part of index-only access.
该选项以筛选的方式用于非匹配索引扫描，且是仅索引访问的一部分。
The two local predicates cannot benefit from matching or screening index scans from any of the existing indexes.
两个本地谓词无法从匹配或筛选现有的索引扫描中获益。
The MON_GET_INDEX table function and db2pd utility provide the same index metrics (number of index scans and index only scans).
MON_GET_INDEX表函数和db2pd实用程序提供相同的索引度量指标（扫描索引和仅扫描索引的数量）。
These index scans also help online transaction processing (OLTP) databases and are described in much more detail in the main article.
这些索引扫描也可以帮助联机事务处理(olp)数据库，更多细节在主文章中有说明。
Index scans are usually the most efficient way to access data, especially when the table is large but the number of qualified rows is small.
一般来说，索引扫描是访问数据的最有效的方法，尤其是表很大但符合条件的行很少的时候。
For multiple index push-downs, multi-index scan is used to combine RIDs from different index scans, then skip-scan on the fact table is performed.
对于多索引下推，多索引扫描用于组合来自不同索引扫描的RID，然后就可以执行对事实表的跳跃式扫描了。
If the value is set to 0, then the optimizer chooses index scans over table scans if appropriate indexes exist, without even considering the estimated costs.
如果将其值设置为0，那么当存在合适的索引时，优化器就选择索引扫描而非表扫描，甚至不考虑估算成本。
This locking was done for both index scans and table access whether or not the row of data was committed or whether it would have been excluded based on the statement's predicates.
不管数据行是否被提交，以及根据语句的谓词它是否被排除，对于索引扫描和表访问都执行这样的锁定操作。
Furthermore, deleted rows are skipped unconditionally on table scan access while deleted keys are not skipped for type-2 index scans unless the registry variable DB2_SKIPDELETED is also set.
而且，虽然在type - 2索引扫描中，被删除的行不会被跳过，但是除非同时设置了注册表变量db2_skipdeleted，否则在表扫描访问中，被删除的行将被无条件跳过。
This is a lot faster than a nested loop join of two table scans without any index usage.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
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.
如果连接列上有一个索引，那么其成本会相当低；否则，数据库服务器就必须对所有表(外部和内部表)执行表扫描。
Tuning can include adding extra indexes to yield a more efficient access plan, which makes tables volatile to encourage index usage and avoid table scans if possible.
调优包括添加额外索引来生成一个更高效的访问计划，让表格变幻无常，进而鼓励索引的使用，如果可能的话也可以避免表扫描。
Perform index analysis to make sure that the right indexes exist to help avoid unnecessary table scans.
执行索引分析，确保索引正确，从而能避免不必要的表扫描。
Like the existing relational index scan operator for relational indexes (IXSCAN), the XISCAN operator performs lookups or scans on XML indexes.
类似于现有的用于关系索引的关系索引扫描操作符(IXSCAN)，XISCAN操作符在xml索引上执行查找或扫描。
But, you can perform range scans on the remaining columns in the index key.
但是，您可以在索引键的其余列上执行范围扫面。
In addition to the scans column, the TCB index Stats section of the db2pd utility results has a IxOnlyScns column that shows the number of index only scans.
除了scans列之外，db 2 pd实用程序的TCBIndexStats部分还有一个ixonlyscns列，它显示仅扫描索引的数量。
Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index.
索引搜索的数目。索引搜索用于启动范围扫描和单个索引记录提取以及在索引中改变位置。
Index searches are used to start range scans, single index record fetches, and to reposition within an index.
索引搜索用于启动范围扫描和单个索引记录提取以及在索引中改变位置。
Number of probe scans. A probe scan is used to directly look up rows in an index or base table.
探测扫描的数目。探测扫描用于直接在索引或基表中查找行。
应用推荐