紧凑和修复 [英] compact and repair

问题描述

有没有人确切知道在压缩和维修期间对数据表执行了哪些操作？

它们是否在物理上进行了重组？ 是否重建了索引？

这是否无条件地为每个表或某些已被标记的表完成？

解决方案

请参阅： http://support.microsoft.com/kb/209769/en-us和

http://stackoverflow.com/questions/2786681/what-do-repair-and-compact-operations-do-to-an-mdb-will-they-stop-an-applicati

Does anyone know exactly what actions are performed on the data tables during a compact and repair ?

Are they reorganized physically ?  Are the indexes rebuilt ?

Is this done unconditionally for every table or just certain tables that have been flagged somehow ?

解决方案

See: http://support.microsoft.com/kb/209769/en-us and http://stackoverflow.com/questions/2786681/what-do-repair-and-compact-operations-do-to-an-mdb-will-they-stop-an-applicati

这篇关于紧凑和修复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！