Alternatively, you can have a table striped across multiple drives to allow faster scanning than with the same table stored on a drive.
另外,您还可以选择将一个表拆开,放到多个驱动器上,这样比将同一个表存储在一个驱动器上扫描起来快。
2
Having a table on one physical drive and other tables on separate drives can improve throughputs and operational efficiency.
把一个表放在一个物理驱动器上而把其他的表放在单独的驱动器上可以提高吞吐量和操作效率。
3
Therefore, when deciding which join method to choose, the optimizer balances the sort cost and the performance benefit for the inner table scan to drive the decision.