Automatic cleanup of pseudo-empty index pages
In Version 11, DB2® automatically cleans up pseudo-deleted index entries and pseudo-empty index pages. This enhancement can reduce the size of some indexes, which can improve SQL performance and reduce the need to run the REORG INDEX utility.
When rows are deleted, index entries are not ... weiterlesen