每个相匹配的命中结果都以排列好的次序返回,第一个结果具有最高的相关性,并按照它们的得分存储。
Each matching hit is returned in ranked order with the first result having the highest relevancy, stored as the score.
因为NPSI是一个单序列列表,很容易看到DB 2如何来回切换,从表到索引、索引到表,然后以ZIPCODE次序返回行,而不需要排序。
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.
当应用程序发出磁盘请求的速率快于磁盘返回数据的速率时,操作系统会让磁盘请求排队,还可能调整请求的次序以降低寻道时间。
The operating system queues disk requests when the applications issue them faster than the disks can return the data, optionally reordering them to minimize seeking.
如果DB 2以非传统方法(LIST PREFETCH方法)使用索引,这些行可能不能以索引次序返回,而是以表中的次序返回。
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.
那就是说,如果表最近被使用 REORG 重组,这些行可能以表CLUSTER次序返回,(中间维护或 “日志应用” 不会对完美的次序有影响)。
That is, the rows would come back in table CLUSTER order if the table were freshly REORGed (with no intervening maintenance or "log apply" impact on its perfect order).
然后,DB2可以以 “传统”方法(索引、表、索引、表,等等)使用这个 “4列” 索引以期望的次序(与索引相同或相反的顺序)返回所需行。
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).
select语句返回在“name”元素中有任何次序的单词“creamer”和“pattern”的所有产品的name元素。
The SELECT statement returns all name elements of the products with the term "creamer" and the term "pattern" in any sequence in the respective "name" element.
在此示例中,按字母表次序返回workdept列和由逗号分隔的姓氏列表。
In the example, the workdept column, and a list of last names separated by commas would be returned in alphabetical order.
在此示例中,按字母表次序返回workdept列和由逗号分隔的姓氏列表。
In the example, the workdept column, and a list of last names separated by commas would be returned in alphabetical order.
应用推荐