Also, DB2 cannot use random order index columns as part of a sort merge join.
另外,DB 2无法在排序合并合并连接中使用随机顺序的索引列。
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.
本文定义了完全二元二级指数样条,证明了相应插值问题解的存在及唯一性。
What happens when the order of the index column is random?
当索引列的顺序是随机的时候,将会发生什么呢?
But what happens when the order of the index column is random?
但是如果索引列的顺序是随机的,将会发生什么呢?
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可以根据预期顺序,也就是索引顺序,向程序返回符合条件的行。
Create your indexes in the order in which you want those index column predicates applied.
按照您想应用索引列谓词的顺序创建您的索引。
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英寸的索引卡去撰写和排序小说的场景。
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行是一致的。
Why would anyone want to keep index data in random order?
为什么有人希望将索引数据随机排列?
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方法)使用索引,这些行可能不能以索引次序返回,而是以表中的次序返回。
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链接,列出他们的所有采购订单。
The impact of a data-partitioned secondary index (DPSI) structure on ORDER BY sort avoidance.
一个分区数据二级索引(data - partitioned secondary index,DPSI)结构对ORDERBY排序规避的影响。
The impact of using the "random" index option on ORDER BY sort avoidance.
使用“random”索引选项对ORDERBY排序规避的影响。
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顺序排列。
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列” 索引以期望的次序(与索引相同或相反的顺序)返回所需行。
Besides creating your index in a different order, what can you do?
除了以不同的顺序创建索引外,还能做什么?
Besides creating your index in a different order, what can you do?
除了以不同的顺序创建索引外,还能做什么?
应用推荐