索引顺序基于排序顺序。
然后，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.
接下来，确保索引中这些列有适当的顺序(按照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.
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
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.
我们选择的索引位于(COLA,COLB,COLC)上，因此那些谓词—上面的示例中的前三行—将以那个顺序应用。
Our chosen index is on (COLA, COLB, COLC), so those predicates-the first three lines in the preceding example-will be applied in that order.
函数索引对列中的数据进行转换并按照顺序保存转换后的值。
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.
如图8的IXSCAN描述符所示，通过优化器利用的索引的领先列是PRODUCT _ NUMBER，其不为合并扫描联接提供所需的顺序。
As shown in the IXSCAN descriptor in Figure 8, the leading column of the index exploited by optimizer is PRODUCT_NUMBER, which does not provide the order required for merge scan join.
在多数情况下，本地索引不保留跨分区的顺序属性，如果计划采用本地索引，还需要进行额外的排序操作。
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.
顺序很重要，如果你的谓语以不同的顺序指定这些属性或在它们前罗列了其他属性，数据库就不会选择该复合索引。
The order is important because if your predicate specifies these properties in a different order or lists some other property before them, the composite index will not be selected by the database.
我们的索引是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.
它包括所使用的索引、从数据库表中检索字段的次数，以及执行查询的步骤的顺序。
It includes the indexes that are used, The Times at which fields are retrieved from the database tables, and the order of steps in which the query is executed.
如果DB 2以传统方式使用索引，数据将以EMPNO顺序返回。
And, if DB2 USES the index the traditional way, the data will come back in EMPNO order.
INDEX元素可以选择性地指定两个或更多索引，它们将按照指定的顺序应用到“IXAND”计划中，并且优化器不会向IXAND添加更多的索引。
The index elements can optionally specify two or more indexes that will be used in the 'IXAND' plan in the specified order and no additional indexes will be added by the optimizer to the IXAND.
一个索引的群集程度；即，表中行的物理顺序与索引的符合程度。
The degree of clustering of an index; that is, the extent to which the physical sequence of rows in a table follows an index.
应用推荐