In this paper, We discuss the splines of the completely binary second order index. The existence and uniqueness of the relevant solution of the problem of interpolation is proved.
本文定义了完全二元二级指数样条，证明了相应插值问题解的存在及唯一性。
Global indexes preserve the order property from index scans, and this gives them an edge over local indexes.
全局索引保留来自索引扫描的顺序属性，这是相对于本地索引的一个优势。
DB2 can then return qualified rows to the program in the desired order, the order of the index.
然后，DB 2可以根据预期顺序，也就是索引顺序，向程序返回符合条件的行。
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.
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
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).
如果您想那三个谓词完全按照它们的编码顺序应用，则必须删除并在(COLA,COLC,COLB)上重建索引(或者创建一个新索引)。
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.
接下来，确保索引中这些列有适当的顺序(按照ORDERby子句)，这样可以避免排序。
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.
顺序很重要，如果你的谓语以不同的顺序指定这些属性或在它们前罗列了其他属性，数据库就不会选择该复合索引。
Our index is in DEPTNO order, and within that order, in groups of identical (but unordered) values of LASTNAME.
我们的索引是DEPTNO顺序的，而在该顺序中，相等（但无序）的LASTNAME值分为一个小组。
A functional index transforms the data in a column and stores the derived values in sorted order.
函数索引对列中的数据进行转换并按照顺序保存转换后的值。
Addicted to Notecards: Vladimir Nabokov used 5 - by 8-inch index CARDS to compose and order the scenes in his novels.
爱好便笺。弗拉基米尔·纳博科夫经常用5- 8英寸的索引卡去撰写和排序小说的场景。
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.
如图8的IXSCAN描述符所示，通过优化器利用的索引的领先列是PRODUCT _ NUMBER，其不为合并扫描联接提供所需的顺序。
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.
注意行和列的次序与元素在每个集合中的顺序是相同的，索引变量名在第12、13和14行是一致的。
For example, whether ORDER BY or GROUP BY clauses are needed in the query, or if they can be resolved via index access.
例如，查询中需要ORDERBY或GROUPBY语句，或者它们能通过指数访问解决。
If DB2 were to use the index the nontraditional, LIST PREFETCH way, the rows would not come back in the order of the index, but rather in the order of the table.
如果DB 2以非传统方法(LIST PREFETCH方法)使用索引，这些行可能不能以索引次序返回，而是以表中的次序返回。
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次序返回行，而不需要排序。
You would need to drop the index and create it again in order to implement changes.
要想进行更改，必须删除索引，然后重新创建它。
Customers can list all their purchases by clicking on the Order history link in the index.
客户可以单击索引中的Orderhistory链接，列出他们的所有采购订单。
Before DB2 9, we needed to add an ORDER BY only if we had more than one index that could be chosen to do the grouping.
在DB 29之前，我们仅需要在拥有多于1个可选择进行分组的索引时，才添加orderBY。
But not always, because the order of the columns in the index can make a big difference depending on the query. For example, consider this query.
但也不一定，因为索引中列的顺序也许会根据查询而有很大差异。
The index rows will not be in LASTNAME order within DEPTNO A01.
在DEPTNO A01中，索引行将不以LASTNAME顺序排列。
The potential of using DYNAMIC SCROLL cursors as a new way of forcing DB2 to avoid a sort for an ORDER BY (or any other sort syntax where an index can be used to avoid the sort).
使用DYNAMICSCROLL光标作为一个强迫DB 2避免ORDERBY(或者任何其他索引可用于避免排序的语法)排序的新方法的可能性。
In order to address the issue, Aaron Erickson has created a product called Index for Objects or i4o.
为了解决这个问题，AaronErickson创建了一个名为IndexforObjects或者i4o的产品。
Note that it would be too boring to write seven inequalities as a sum of five decision variables that are not necessarily in order, because in some constraints, the index may overlap the index 7.
注意编写7个不等式作为5个不必有序的决策变量的和太过繁琐了，因为在某些约束中，索引可能会覆盖索引值7。
then DB2 could use the four-column index the "traditional" way (index, table, index, table, etc.) to return the rows in the desired order (the same order as or the reverse order of the index).
然后，DB2可以以 “传统”方法（索引、表、索引、表，等等）使用这个 “4列” 索引以期望的次序（与索引相同或相反的顺序）返回所需行。
We can match on one column, and if we use the index the traditional way, the data will come back in DEPTNO order.
我们可以在一列上进行匹配，如果我们以传统方式使用索引，数据将按DEPTNO顺序返回。
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小组以随机形式返回。
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小组以随机形式返回。
应用推荐