Figure 1 shows an example of two indexes: one a DPSI and the other an NPSI on the column ZIPCODE.
图1显示了两个索引的一个示例：一个是DPSI，另一个是NPSI，在列z IPCODE上。
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次序返回行，而不需要排序。
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次序返回行，而不需要排序。
应用推荐