Progress
Database Administration
Guide and Reference


Compacting Indexes

When the DBANALYS utility indicates that space utilization of an index is reduced to 60% or less, use the PROUTIL IDXCOMPACT utility to perform index compaction online. Performing index compaction increases space utilization of the index block to the compacting percentage specified. For example:

proutil db-name -C idxcompact [ owner-name.]table-name.index-name [ n ] 

NOTE: For the complete syntax description, see Database Administration Utilities."

Performing index compaction reduces the number of blocks in the B-tree and possibly the number of B-tree levels, which improves query performance.

The index compacting utility operates in phases:

The _UserStatus virtual system table displays the utility’s progress.

NOTE: Because index compacting is performed online other users can use the index simultaneously for read or write operation with no restrictions. Index compacting only locks 1 to 3 index blocks at a time, for a short time. This allows full concurrency.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095