Indexes that will provide index-only access for the SQL statement.
为sql语句提供进索引访问的索引。
If feasible, add STATUS to the index to make the qualification index-only.
如果可行，在索引中增加STATUS，来使得有效性只适用索引。
Since both LASTNAME and DEPTNO are part of the index, we will get index-only access.
因为LASTNAME和DEPTNO都是索引的一部分，我们将获得仅限索引的访问。
Keep in mind that making every query an index-only access is not prudent or even possible.
请记住：使每个查询成为仅索引访问是不谨慎，甚至也是不可能的。
There is no FETCH or table node shown in the access path graph because it is an index-only scan.
因为其是一个唯一索引扫描，所以在访问路径图中不显示FETCH或表节点。
The option can be used in non matching index scans in a screening fashion and as part of index-only access.
该选项以筛选的方式用于非匹配索引扫描，且是仅索引访问的一部分。
You might add a column to an existing index to get index-only access for a portion of the query's processing.
可以在现有的索引中添加列，让查询处理的一部分只访问索引。
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.
通常情况下，在基础索引提供好处(如唯一索引访问、避免排序或一些类似的好处)时，可通过优化器选择非匹配索引扫描。
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小组以随机形式返回。
In the Global Hunger Index 2019, the country ranks 102nd out of 117. Data from the National Family Health Survey indicate that only 10 percent of infants of 6 to 23 months are adequately fed.
在2019年全球饥饿指数中，该国在117个国家中排名第102位。《全国家庭健康调查》的数据表明，6至23个月大的婴儿中仅有10%得到了充分的喂养。
Each index partition indexes rows only from the corresponding data partition.
每个索引分区仅从相应的数据分区取得索引行。
Parallel invocations of the stored procedure are only allowed if the index name parameters are different.
只有在索引名称参数不同的情况下，才允许并行调用这个存储过程。
You have a join logical file, but only want the index for the key on SSD, not the secondary indexes.
您有一个连接逻辑文件，但是只希望在SSD中保存键的索引，而不是二级索引。
The model file is passed as a parameter during index creation and is only read during index creation; later changes do not affect existing indexes.
在创建索引期间，模型文件作为参数传递，而且只在此期间被读取；以后的修改不影响现有的索引。
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.
仅扫描索引是未包含表访问的索引访问，因为索引本身包含了所有被请求的数据。
Incremental backup allows you to back up only index and data pages that have changed since a previous backup.
增量备份允许只备份自上一次备份以来发生变化的索引和数据页。
Since this local index build happens only on the newly attached partition and requires very limited logging, SET INTEGRITY is still significantly faster compared to global indexes.
因为只在新附加分区上构建这一本地索引，并需要非常有限的日志，所以与全局索引相比，SETINTEGRITY甚至明显变快了。
Transparency International recently ranked Yemen 146 out of 178 countries on their 2010 corruption perception index, ahead of only Iraq, Somalia, and Sudan in the region.
透明国际最新2010年清廉指数统计显示，也门在调查的178个国家中排名146，在所在地区仅领先伊拉克，索马里和苏丹。
If all the data that a SQL query asks for is contained in the index, DB2 might be able to satisfy the request using only the index.
如果SQL查询要寻找的所有数据都包含在索引中，那么DB2也许只使用索引就可以满足该请求。
While an index on a relational column contains all values from that column, an XML index contains only values of nodes that match both the XML pattern and the data type in the index definition.
关系列上的索引包含了此列的所有值，而xml索引仅包含那些同时匹配XML模式和索引定义中的数据类型的节点值。
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类型的索引进行计算。
You may also need to design indexes to avoid data sort and to provide index only access.
您也许还要设计索引以避免数据排序并提供只带索引的访问。
The broad Topix index was only up 5.6%, even as the Nikkei Stock Average of 225 companies finished 19% higher at 10546.44.
东证指数仅上涨5.6%，即便是日经225指数也仅上涨了19%，收报10546.44点。
Lucene can index only plain text documents, so we need a way to extract the plain text from a rich document format like those above and feed it into Lucene.
Lucene只能为纯文本文档建立索引，因此我们需要找到一种方法将纯文本从上面提到的那些富文档格式的文档中提取出来，然后将其提供给Lucene。
The standard Scheme document, including the index, is only 50 pages long.
包括索引的标准scheme文档也才只有50页。
Instead of indexing many small text fields, aggregate the text into a single "contents" field and index only that (you can still store the other fields).
如果你要索引很多小文本字段，如果没有特别需求，建议你将这些小文本字段合并为一个大的contents字段，然后只索引contents。
The IndexSearcher does the actual munging through the index, but it only understands Query objects.
IndexSearcher通过索引munging，但它只理解Query对象。
As index updates add and delete entries only one index update Task should be executed at a time.
因为索引更新添加和删除条目，所以一次只应执行一个IndexUpdateTask。
The index attribute is optional and may specify an index name only if the TYPE is specified as' XMLINDEX '.
index属性是可选的，并且仅当TYPE被指定为“XMLINDEX”时才会指定一个索引名。
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实用程序提供相同的索引度量指标（扫描索引和仅扫描索引的数量）。
应用推荐