它的目的是为文档存储和排序索引提供一个强壮的接口。
It's aim is to provide a robust interface for document storage and sorted indexes.
对于每个可排序的列，LotusNotes构建了一个特定于语言的排序索引。
For each of these sortable columns, Lotus Notes builds a language-specific sort index.
使用合适的索引使排序堆的使用降到最低。
Use appropriate indexes to minimize the use of the sort heap.
接下来，确保索引中这些列有适当的顺序(按照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.
爱好便笺。弗拉基米尔·纳博科夫经常用5- 8英寸的索引卡去撰写和排序小说的场景。
Addicted to Notecards: Vladimir Nabokov used 5 - by 8-inch index CARDS to compose and order the scenes in his novels.
视图中的列上的每个排序箭头都会增加视图索引，同时还会增加刷新视图的时间。
Each sorting arrow on a column in a view increases the view index and the time it takes to refresh the view.
第三卷中的一个算法——关于排序和查找的算法——影响到第一个商业结合的索引文件系统的实施。
One of the algorithms in his third volume — on sorting and searching algorithms — inspired the first commercial implementation of an associatively indexed file system.
可以帮助避免排序的索引。
还请记住，AIX上大约有最大为250MB的私有虚拟内存用于LOAD中的索引键排序(这是内存瓶颈)。
Also keep in mind that on AIX, there is approximately a Max of 250mb of private virtual memory for index key sorting in LOAD (this is a memory bottleneck).
您只需要认识到，我们一直警告关于跨分区处理DPSI的负面效应，包括规避排序所需的多个索引。
You just need to realize that we have been warned about the negatives of DPSIs in cross-partition processing, including the multiple index probes needed for sort avoidance.
这些语句可受益于减少排序数目的附加调优，例如添加索引。
Such statements may benefit from additional tuning to reduce the number of sorts, such as adding an index.
临时数据；通过对表进行排序、更改和创建索引而生成的数据。
Temporary data; data generated by sorting and altering tables and building indexes.
要生成章节索引，需要创建一个HTML文件，其中包含给定的所有的排序列表。
To generate the section index, we create an HTML file with an ordered list of all of the s in a given.
如果该子句中所有的列都是以用单个索引要求的顺序出现的，那么数据库服务器就使用索引来按顺序读取行，因而避免了排序。
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.
事实上，使用一个索引来避免排序的一个关键方法是提高SQL性能，使其比应用FETCH实际获取的行更多。
In fact, the use of an index for sort avoidance is a key way to improve the performance of SQL that qualifies far more rows than will actually ever be FETCHed.
这将指示DB 2将索引键传递给内存中的排序程序，而不是再次将这些键写到DASD上的排序工作文件中，然后从中读取这些键。
This instructs DB2 to pass the index keys to the sort program in memory, rather than having the keys written to and read once again from sort work files on DASD.
FETCH(3)的结果集是根据ID字段排序的，并且使用T1的索引I1的合并联接而得到最终的结果集。
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.
现在，如果最适合DB2用于避免数据排序的索引不是有序列表，而是随机的，会发生什么？
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?
如果没有索引满足所取的行的要求顺序，或者优化器断定排序的代价低于索引扫描，那么就需要进行排序。
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.
在多数情况下，本地索引不保留跨分区的顺序属性，如果计划采用本地索引，还需要进行额外的排序操作。
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.
通常情况下，在基础索引提供好处(如唯一索引访问、避免排序或一些类似的好处)时，可通过优化器选择非匹配索引扫描。
Typically, a non-matching index scan is chosen by the optimizer when the underlying index provides benefits such as index-only access, avoids sort, or some similar benefit.
装入和创建索引的操作通常使用私有排序进行索引键的排序，无论INTRA_PARALLEL参数的值如何。
The load and create index operations always use private sorts for index key sorting, regardless of the value of the INTRA_PARALLEL parameter.
还可将类别转换成排序列，后者提供了相同的查找功能但可使视图更快地进行索引。
Also, categories can be turned into sorted columns, which provide the same functionality for lookups but allow the view to index more quickly.
不允许使用大对象作为索引键，因为一般情况下不能够对大对象进行比较和排序。
Using large objects as index keys is disallowed because they cannot, in general, be compared and sequenced.
需要排序结果时，可以直接从索引中读取。
When a sorted result is needed, it can be read directly from the index.
如果DB 2没有一个适当次序的索引可以避免排序，或者当DB 2以LIST PREFETCH方法使用任何索引时，那么一个ORDERBY必定会引起数据排序。
When DB2 does not have an index in the appropriate order for sort avoidance or when DB2 USES any index the LIST PREFETCH way, then an order BY will most certainly cause a data sort.
这里的重点是您可以选择在不丢失索引功能的前提下将索引定义为DPSI 来规避排序，包括DYNAMICSCROLL光标所需的规避排序。
The important point here is that you can choose to define indexes as DPSIs without losing that index's aptitude for sort avoidance, including the sort avoidance required for DYNAMIC SCROLL cursors.
这是索引文件里面最核心的一个文件，它存储了所有的索引项的值以及相关信息，并且以索引项来排序。
This core index file stores all of the terms and related information in the index, sorted by term.
因此，它可以以传统方法使用我们索引的Partition1来避免在ZIPCODE上进行排序。
Therefore, it can use Partition 1 of our index the traditional way to avoid a sort on ZIPCODE.
应用推荐