Progress
Database Administration
Guide and Reference


PROUTIL IDXCOMPACT Qualifier

Performs index compaction online. This is recommended when the PROUTIL IDXANALYS utility indicates that space utilization of an index is reduced to 60% or less. Index compaction increases space utilization of the index block to the compacting percentage specified by n.

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -C idxcompact
 [owner-name.]table-name.index-name [n]

db-name

Specifies the source database name.

owner-name

Specifies the owner of the table containing the data you want to dump. You must specify an owner name unless the table’s name is unique within the database, or the table is owned by “PUB.” By default, Progress 4GL tables are owned by PUB.

table-name

Specifies the source table containing the source index to be compacted.

index-name

Specifies the source index to be compacted.

n

Specifies the degree of index compaction. You can specify an integer >=50 and <=100. The default value is 80. If you do not specify n, 80 is used.

NOTES


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