索引顺序基于排序顺序。
然后，DB 2可以根据预期顺序，也就是索引顺序，向程序返回符合条件的行。
DB2 can then return qualified rows to the program in the desired order, the order of the index.
你的聚集索引顺序表中的数据存储，所以你每个表只能有一个聚集索引。
Your clustered index is the order the data is stored in the table, so you can only have one clustered index per table.
它可能是一个没有数据库管理系统的索引顺序存取法文件，不管在要地电脑还是远程叫脑中。
It may be an ISAM (Indexed Sequential Access Method) file with no DBMS, either on the local or a remote computer.
选择与要连接的索引顺序访问方法 （ISAM）或数据库的类型相对应的驱动程序，然后单击“完成”。
Select the driver corresponding to the type of indexed sequential access method (ISAM) or database you want to connect to, and then click Finish .
有意思的是，并没有人指出FriendFeed的解决方案与古老的ISAM技术(IndexedSequential Access Method，索引顺序存取法)之间的相似性。
It is interesting that no one pointed out the similarity between FriendFeed's solution and the "ancient" technology of ISAM - Indexed Sequential Access Method.
当索引列的顺序是随机的时候，将会发生什么呢？
但是如果索引列的顺序是随机的，将会发生什么呢？
But what happens when the order of the index column is random?
接下来，确保索引中这些列有适当的顺序(按照ORDERby子句)，这样可以避免排序。
Next, ensure that the index has these columns in the proper sequence (according to the ORDER BY clause), so that a sort can be avoided.
另外，DB 2无法在排序合并合并连接中使用随机顺序的索引列。
Also, DB2 cannot use random order index columns as part of a sort merge join.
按照您想应用索引列谓词的顺序创建您的索引。
Create your indexes in the order in which you want those index column predicates applied.
除了以不同的顺序创建索引外，还能做什么？
Besides creating your index in a different order, what can you do?
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
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.
在外键加强过程中，服务器使用顺序扫描，而不是外键索引。
During the foreign key enforcement, the server USES the sequential scan, instead of foreign key index.
如果该子句中所有的列都是以用单个索引要求的顺序出现的，那么数据库服务器就使用索引来按顺序读取行，因而避免了排序。
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.
注意行和列的次序与元素在每个集合中的顺序是相同的，索引变量名在第12、13和14行是一致的。
Note that the row and column order is the same as the element order in each set, and the index variable names are consistent between lines 12, 13, and 14.
函数索引对列中的数据进行转换并按照顺序保存转换后的值。
A functional index transforms the data in a column and stores the derived values in sorted order.
全局索引保留来自索引扫描的顺序属性，这是相对于本地索引的一个优势。
Global indexes preserve the order property from index scans, and this gives them an edge over local indexes.
分配空余空间的主要目的是使数据行的物理顺序与群集索引一致，以减少频繁重组数据的需要。
The main purpose of allocating free space is to keep the data rows in the same physical sequence as the clustering index, thus reducing the need to frequently reorganize the data.
如果您想那三个谓词完全按照它们的编码顺序应用，则必须删除并在(COLA,COLC,COLB)上重建索引(或者创建一个新索引)。
If you want those three predicates applied in the exact order in which you code them, you must drop and re-create the index (or create a new index) on (COLA, COLC, COLB).
索引是用来定位数据页的顺序指针或键的集合。
Indexes are collections of sequentially ordered Pointers or keys used for locating data pages.
在多数情况下，本地索引不保留跨分区的顺序属性，如果计划采用本地索引，还需要进行额外的排序操作。
In most cases, local indexes do not preserve the order property across partitions and that requires an extra sort if the plan is using local indexes.
如果没有索引满足所取的行的要求顺序，或者优化器断定排序的代价低于索引扫描，那么就需要进行排序。
Sorting is required when no index satisfies the requested ordering of fetched rows, or the optimizer determines that a sort is less expensive than an index scan.
索引的顺序由优化器选择。
在其最一般的形式中，UNNEST可采用几个阵列作为参数，且其可生成其他列以便反映子索引实施的顺序。
In its most general form, UNNEST can take several arrays as arguments, and it can produce an additional column to reflect the order imposed by the sub-indexes.
我们的索引是DEPTNO顺序的，而在该顺序中，相等（但无序）的LASTNAME值分为一个小组。
Our index is in DEPTNO order, and within that order, in groups of identical (but unordered) values of LASTNAME.
索引按照某种顺序保存列值。
这意味着对表的顺序扫描比索引读取更快，我们无法遵循指示器标准。
This means that a sequential scan of the table will be faster than an indexed read, and we cannot play with the filter criteria.
简单的DCP可能存储在不止一个移动介质上(比如，复合式硬盘？)。这个索引文件用于识别整个DCP里的文件顺序。
A single DCP may be stored in more than one medium (e.g., multiple hard disks). This file is used to identify the volume order in the series.
如果DB 2以传统方式使用索引，数据将以EMPNO顺序返回。
And, if DB2 USES the index the traditional way, the data will come back in EMPNO order.
应用推荐