An index is a DB2 object (a separate VSAM dataset) that is comprised of an ordered set of keys extracted from one or more columns of the corresponding table.
索引也是一种DB 2对象(一个单独的VSAM数据集)，它由一组排好序的键组成，这些键是从相应表中的一个列或多个列抽取出来的。
Because the NPSI is a single ordered list, it is easy to see how DB2 could just toggle back and forth, index to table, index to table, and return rows in ZIPCODE order without sorting.
因为NPSI是一个单序列列表，很容易看到DB 2如何来回切换，从表到索引、索引到表，然后以ZIPCODE次序返回行，而不需要排序。
When China’s demand for raw materials surged, sending the Baltic Dry Index soaring to 11, 793 in 2008, shippers ordered many more ships.
中国对原材料的需求急剧增加时，波罗的海干货指数（Baltic Dry Index）在2008年飙升至11793点。船务公司订购很多艘船。
With the index array of scores created, we use the standard sort command as described in section 4 of the perlfaq to create the @sorted array of ordered search results.
创建分数索引数组后，我们将按照perlfaq的第 4部分中的说明使用标准排序命令来创建排序后搜索结果的 @sorted 数组。
You can help speed up index maintenance by using a large buffer pool for the index tablespace, and, if possible, ordering the inserts so that the key values are ordered, not random.
如果为索引表空间使用较大的缓冲池，并且尽可能地将不同 insert排序，以便键值是排好序的，而不是随机的，就可以帮助加快索引维护。
Note also that a Row is ordered, so that you can pull out name/value pairs by index.
还要注意的是Row 是排序的，这样您就可以通过索引来取出名称／值的对。
If all the columns in the clause appear in the required sequence with a single index, the database server USES the index to read the rows in the ordered sequence, thus avoiding a sort.
如果该子句中所有的列都是以用单个索引要求的顺序出现的，那么数据库服务器就使用索引来按顺序读取行，因而避免了排序。
Definition of parameterized queries that can take parameters as an ordered list, referred to by index Numbers, or as named parameters referred to by name.
定义参数化的查询，这种查询可以以有序列表形式接收参数(按索引号引用参数)，也可以采用按名称引用的命名参数。
Now, what happens if the index that would have been ideal for DB2 to use to avoid a data sort is not an ordered list, but rather random?
现在，如果最适合DB2用于避免数据排序的索引不是有序列表，而是随机的，会发生什么？
To generate the section index, we create an HTML file with an ordered list of all of the s in a given.
要生成章节索引，需要创建一个HTML文件，其中包含给定的所有的排序列表。
The result set from FETCH (3) is ordered by the ID column and joined using a merge join with index I1 for T1 to get final result set.
FETCH(3)的结果集是根据ID字段排序的，并且使用T1的索引I1的合并联接而得到最终的结果集。
This naming convention also allows you, if looking at a list of indexes, to see the indexes ordered by table, then column, then index type.
索引一般与表或视图相关，所以使用表或者视图的名字来命名比较恰当，索引名等同于被索引字段名。
When China's demand for raw materials surged, sending the Baltic Dry Index soaring to 11,793 in 2008, shippers ordered many more ships.
中国对原材料的需求急剧增加时，波罗的海干货指数(Baltic Dry Index)在2008年飙升至11793点。船务公司订购很多艘船。
When China's demand for raw materials surged, sending the Baltic Dry Index soaring to 11,793 in 2008, shippers ordered many more ships.
中国对原材料的需求急剧增加时，波罗的海干货指数(Baltic Dry Index)在2008年飙升至11793点。船务公司订购很多艘船。
应用推荐