Information

Title	What is the best utility to use to reactivate an index?

URL Name	P16878

Article Number	000137871

Environment	Product: Progress Version: 8.x, 9.x Product: OpenEdge Version: 10.x, 11.x OS: All supported platforms

Question/Problem Description

What is the best utility to use to reactivate an INACTIVE index?
Is IDXFIX, IDXACTIVATE or IDXBUILD the best utility to reactivate an index?

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

The best way to reactivate an index from a performance standpoint is IDXBUILD.

The reason is that an index tree built by idxbuild is better compacted and balanced than a tree fixed using idxfix.

Compacted index trees also improve performance. If there are only a few records, then this wouldn't be too significant.

As of 10.1A release, a new option was added to proutil command which allows activating indexes online:

proutil -C idxactivate

Refer to Article What is IDXACTIVATE?

Workaround

Notes

Progress Articles:

How to reactivate a deactivated index when the database is offline?
How to deactivate indexes within a Progress database
What is the difference between idxfix idxcheck and idxbuild?

Keyword Phrase

Last Modified Date	11/20/2020 7:11 AM

What is the best utility to use to reactivate an index?

Information