1) If there is enough space to do so, use the same table space for both the original table and the reorganized copy of the table, instead of using a temporary table space. This saves the time that is needed to copy the reorganized table from the temporary table space.
2) Consider dropping unnecessary indexes before reorganizing a table so that fewer indexes need to be maintained during the reorg operation.
3) Ensure that the prefetch size of the table spaces on which the reorganized table resides is set properly.
4) Tune the sortheap and sheapthres database configuration parameters to control the space that is available for sorts. Because each processor will perform a private sort, the value of sheapthres should be at least sortheap x number-of-processors.
5) Adjust the number of page cleaners to ensure that dirty index pages in the buffer pool are cleaned as soon as possible.
Tips for improving offline reorganization performance
精选 转载文章标签 Tips for improving o 文章分类 数据库
下一篇:DB2高效分页算法
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
7 Tips for Improving MapReduce Performance
第七条看着挺靠谱的,待验证!
MapReduce performance