IDXBUILD with the inactiveindexes Option rebuilds all indexes for the identified table

IDXBUILD using the inactiveindexes Option rebuilds ALL indexes for the table when used in combination with other restricted IDXBUILD options

IDXBUILD using the inactiveindexes Option rebuilds all indexes for the table.
IDXBUILD output to the screen shows all indexes for the named table are rebuilt when a subset of these were inactive indexes.
IDXBUILD does not isolate inactive indexes to build when the commandline specifically instructs inactiveindexes to build for a table or area
IDXBUILD does not accept a second restricted build option

This is expected behaviour, all IDXBUILD/IDXCHECK command line Options are exclusive:

Additional IDXCHECK/IDXBUILD command line Options were added as a new feature to compensate the only other command line option "all", without having to first navigate through the IDXBUILD table/index pages to run a restricted IDXBUILD

When restricted IDXBUILD commandline options are combined, the first qualifier specified on the command line is used and any other scope qualifiers are ignored.

• OpenEdge 10.0B added additional IDXCHECK/IDXBUILD command line Options: "table", "area", "schema"
• OpenEdge 10.1A, added further IDXCHECK/IDXBUILD command line Options: "activeindexes", "inactiveindexes"  

All 5 of these commandline Options are stand alone options.  None of these were designed to work in conjunction with each other. In other words, an index build cannot be run for all 'inactive indexes' AND all indexes in an area for example.

Other methods to reactivate an inactive index:
 
1. Use IDXACTIVATE, which has the advantage of being able to run online and does not require after-imaging to be disabled before building indexes.

• IDXACTIVATE can be used fully online, but will start from scratch each time to build all index keys and activate the index. It does not take into consideration if the keys were already built by any other tool
• The Primary index does not have to be active, as long as another active index is referenced with the "useindex" option. For further information refer to Article:  What is idxactivate?   

2.  Use either IDXBUILD or IDXFIX (offline) to activate indexes

•   How to reactivate a deactivated index when the database is offline?   

3. Activate indexes marked as inactive using a combination of Online and Offline methods:

• IDXFIX (Option 3) online for the inactive index(es). This will not activate the index, it will pre-build the key entries
• IDXBUILD (offline) will activate the index (much) faster with less downtime

It was determined that the Progress Product is functioning as designed.

An enhancement to the product can be requested through the Progress Community via an Ideas submission. Customer feedback is valuable and Idea submissions are monitored by our Product Management team. Enhancement requests are reviewed during the planning phase of each new product release and a list of the enhancements chosen for implementation can be found in the Release Notes documents that accompany each release. Once an Idea is submitted the Progress Software Community will have the opportunity to comment on and vote for the Idea. 
 
For detailed information on how to submit an Idea, please refer to Article: How to submit an enhancement request for a Progress product?
 

 

Progress Articles: 

 What is idxactivate?   
 How to reactivate a deactivated index when the database is offline?   
What is the best utility to use to reactivate an index?   
Error 16488 after adding active indexes online