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.
仅扫描索引是未包含表访问的索引访问，因为索引本身包含了所有被请求的数据。
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.
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
As you see in Table 3, a string predicate can only be evaluated with an XML index of type VARCHAR, while a numeric predicate can only be evaluated with an index of type DOUBLE.
正如您在表3中所看到的，字符串谓词只能由varchar类型的xml索引进行计算，而数值谓词只能由double类型的索引进行计算。
There is no FETCH or table node shown in the access path graph because it is an index-only scan.
因为其是一个唯一索引扫描，所以在访问路径图中不显示FETCH或表节点。
An XISCAN plan if only a single index is defined on the table and it is of type XML.
一个XISCAN计划，前提是只对表定义了一个单一的索引并且其类型为XML。
Suppose you have an index on the column customer_type in the customer table, and there are only five possible customer_type codes.
假设customer表中的customer _ type列上有一个索引，那么只会有5种可能的customer _ type代码。
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实用程序提供相同的索引度量指标（扫描索引和仅扫描索引的数量）。
Note that only the table data pages and not the index pages are sampled.
请注意，只对表数据页进行抽样，而不是索引页。
Index push-downs require only a single-column index on the fact table, although they can use a multi-column index if the required foreign-key column is the first key in the index.
索引下推只需要事实表的单列索引，虽然在所需的外键列是索引的第一个键的情况下可以使用多列索引。
To illustrate this, compare it to the predicate that is applied to the index scan numbered 5 in the plan, which is on the one and only column of the index on the child table.
为了展示这一点，将它与计划中第5号索引扫描上使用的谓词相比较，它针对子表中惟一的索引列。
Your clustered index is the order the data is stored in the table, so you can only have one clustered index per table.
你的聚集索引顺序表中的数据存储，所以你每个表只能有一个聚集索引。
Only one clustered index can exist per table.
对于每个表，只允许存在一个聚集索引。
DAO not only has the capability of accessing database, but also can operate and define the database, for example, setting up database, table, field and index.
DAO不仅具有对数据库访问的能力，而且能对数据库进行操作和定义，如创建数据库、创建表、创建域和创建索引。
A table can contain only one clustered index.
一个表只能包含一个聚集索引。
A clustered index determines the order in which records are physically stored (which is why you can only have one per table).
聚集索引确定的顺序记录物理存储(这就是为什么你每个表只能有一个)。
A clustered index determines the order in which records are physically stored (which is why you can only have one per table).
聚集索引确定的顺序记录物理存储(这就是为什么你每个表只能有一个)。
应用推荐