Progress
Database Administration
Guide and Reference


PROUTIL IDXMOVE Qualifier

Moves an index from one application data area to another while the database remains online. You might be able to improve performance by moving indexes that are heavily used to an application data area on a faster disk.

The PROUTIL IDXMOVE utility operates in two phases:

NOTE: The _UserStatus virtual system table displays the utility’s progress. For more information see Maintaining Database Structure."

SYNTAX

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

db-name

Specifies the name of the database containing the table.

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 index to be moved.

index-name

Specifies the name of an index to move.

area-name

Specifies the area name of the target application data area into which the index is to be moved. Area names that contain spaces must be quoted. For example, “Area Name.”

NOTES


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