You can manage space for sort operations more efficiently by designating one or more
temporary tablespaces exclusively for sorts. Doing so effectively eliminates
serialization of space management operations involved in the allocation and
deallocation of sort space. A single SQL operation can use more than one temporary
tablespace for sorting. For example, you can create indexes on very large tables, and
the sort operation during index creation can be distributed across multiple tablespaces.
All operations that use sorts, including joins, index builds, ordering, computing
aggregates (GROUP BY), and collecting optimizer statistics, benefit from temporary
tablespaces. The performance gains are significant with Real Application Clusters.
可以创建多个临时表空间来排序 ， 比如 ， 在一个大表上创建索引时 ， 排序操作所要求的表空间可以
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-976743/，如需转载，请注明出处，否则将追究法律责任。