Issue 1: The impact of DPSI structure on sorts.
问题1：dpsi结构对排序的影响。
The impact of a data-partitioned secondary index (DPSI) structure on ORDER BY sort avoidance.
一个分区数据二级索引(data - partitioned secondary index,DPSI)结构对ORDERBY排序规避的影响。
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上。
For a DPSI where qualified rows are in more than one partition, every probe skips between partitions.
对于一个DPSI，其中符合条件的行在多个分区中，每个探针在分区之间跳来跳去。
Just in case you think that I am very pro-DPSI, I feel that it is important to stress some of their negatives.
以防您觉得我非常赞成DPSI，强调他们的一些负面效应是很重要的。
We are not so pleased with the DPSI if we must probe multiple index trees to find rows across multiple partitions.
我们不是很乐意使用DPSI，但是我们必须跨多个分区探测多个索引树来寻找行。
The less-than-ideal scenario of using a DPSI to access multiple partitions can be very painful from a SQL performance perspective.
使用一个DSPI来访问多个分区不太理想的话，从SQL性能的角度来说可能非常棘手。
The less-than-ideal scenario of using a DPSI to access multiple partitions can be very painful from a SQL performance perspective.
使用一个DSPI来访问多个分区不太理想的话，从SQL性能的角度来说可能非常棘手。
应用推荐