db2set DB2_TRUST_MDC_BLOCK_FULL_HINT=true
- the insert code to trust the FULL bits in the block indexes even though this is just a hint. So only the first pass of the block index will be done. The first pass will only visit blocks which do not have the FULL bit set. If the visited blocks are found to be full, the FULL bit will be set in the block index. The second pass of the block index, which visits blocks even if the FULL bit is set, and which clears the FULL bit when space is found, will not be done.
- This will speed up the insert.
- The side affect of this registry variable is that until an entire block is deleted, any space freed by deletes within those blocks will not be reused. |
alter table tablename locksize blockinsert
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞0
添加新评论0 条评论