You may also need to design indexes to avoid data sort and to provide index only access.
您也许还要设计索引以避免数据排序并提供只带索引的访问。
For me now, i was in school, my life index only six : forget the time, honest, simple, practical.
我的生活指标只有六个:忘时、忘物、忘我、诚实、朴实、踏实。
The winners were Chase-Chemical and First Chicago-NBD, but even they outperformed the index only modestly.
获奖者大通化学和第一芝加哥的工作日,但即使他们的表现指数只有温和。
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实用程序提供相同的索引度量指标(扫描索引和仅扫描索引的数量)。
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.
仅扫描索引是未包含表访问的索引访问,因为索引本身包含了所有被请求的数据。
Traditional reliability index only reflects the availability of equipments or power networks in power systems, excluding its economic factors.
传统的电力系统可靠性指标反映了电力系统元件或网络的可用度,但是没有反映出其经济成分。
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。
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。
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列,它显示仅扫描索引的数量。
Other search engines index only a certain number of documents per server, so while early customers of free hosting services may be indexed, later customers may be ignored.
另一些只会索引某一台服务器上的一定数量的页面,所以后面注册的站点就不会被索引。
At present no-one search engine has been able to cover all WWW resources, moreover the majority of search engines can commonly index only about 5%-20% of the entire WWW resources.
目前没有一个搜索引擎能够覆盖所有的WWW资源,而且大部分搜索引擎的索引平均只能涉及到整个WWW资源5% - 20%左右。
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中保存键的索引,而不是二级索引。
Of the seven currencies that make up the Federal Reserve's major-currency index, only one (the Australian dollar) is within 10% of its fair value.
在构成美联储主要货币指数的七种货币中,只有一个(澳大利亚元)是在其10%的公平价值范围内的。
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.
在创建索引期间,模型文件作为参数传递,而且只在此期间被读取;以后的修改不影响现有的索引。
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也许只使用索引就可以满足该请求。
There is no FETCH or table node shown in the access path graph because it is an index-only scan.
因为其是一个唯一索引扫描,所以在访问路径图中不显示FETCH或表节点。
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.
通常情况下,在基础索引提供好处(如唯一索引访问、避免排序或一些类似的好处)时,可通过优化器选择非匹配索引扫描。
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类型的索引进行计算。
The option can be used in non matching index scans in a screening fashion and as part of index-only access.
该选项以筛选的方式用于非匹配索引扫描,且是仅索引访问的一部分。
Indexes that will provide index-only access for the SQL statement.
为sql语句提供进索引访问的索引。
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点。
The standard Scheme document, including the index, is only 50 pages long.
包括索引的标准scheme文档也才只有50页。
The IndexSearcher does the actual munging through the index, but it only understands Query objects.
IndexSearcher通过索引munging,但它只理解Query对象。
应用推荐