If your intention is a real "between" predicate, then the execution plan on the right is much better, because a single range scan with a start-top predicate delivers the matching row IDs only.

如果您的目的是要实现真正的“between”谓词，则右侧的执行计划会更好一些，因为带有启动谓词的单个范围扫描仅传递匹配的行id。

youdao

However, the product has changed dramatically, from a single thickness of 6.8 mm to a range from sub-millimeter to 25 mm.

然而，玻璃制品在厚度上发生了巨大变化：从单一的6.8毫米变为亚毫米级至25毫米区间的任意厚度。

youdao

But you do want to be able to have a single handler display a potentially wide range of tables for either a single page or a range of pages.

但是您可能希望能够通过单个处理程序来显示单个页面或一系列页面的潜在范围的广泛表。

youdao

No single space project in this period will be more impressive to mankind or more important for the long range exploration of space.

VOA: special.2009.07.08

(ASKING) "In fact,the absorption enhancement that we see is in the range of 20 to 50 times the single-pass absorbance."

VOA: standard.2010.02.19

For fiscal 2013, the company expects revenue in stores open at least one year to fall in the low- to mid-single digit range.

WSJ: Barnes & Noble posts 3Q loss as Nook demand slows

The company now sees LCD volumes form its wholly owned business to be flat sequentially, rather than up in the mid-to-upper single digits range.

FORBES: Corning Turns Cautious On Q3 LCD TV Outlook

For 2012, the company expects post-paid ARPU to grow 2%, with profits increasing in the mid single digit range or better on a percentage basis.

FORBES: AT&T Slips On Q4 Results; Slight EPS Miss; 7.6 Million iPhones