ITPub博客

首页 > 应用开发 > IT综合 > Temporary Tablespaces for Sort Operations (57)

Temporary Tablespaces for Sort Operations (57)

原创 IT综合 作者:tsinglee 时间:2007-10-15 16:54:04 0 删除 编辑

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.

临时表空间 :排序操作
可以创建多个临时表空间来排序 , 比如 , 在一个大表上创建索引时 , 排序操作所要求的表空间可以
分布在不同的临时表空间上

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-976743/,如需转载,请注明出处,否则将追究法律责任。

下一篇: Sort Segments (58)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892816