Kbase P97028: Does IDXBUILD have the ability to rebuild all the indexes for just one table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/11/2004 |
|
Status: Unverified
GOAL:
Does IDXBUILD have the ability to rebuild all the indexes for just one table?
FACT(s) (Environment):
OpenEdge 10.0B
FIX:
Prior to 10.0B, users wanting to rebuild all the indexes for only one table needed to know the names of the indexes prior to running IDXBUILD. OpenEdge 10.0B has added a menu choice to IDXBUILD to allow all indexes for one table to be rebuilt without entering them individually.
Below is the new IDXBUILD menu:
Index Rebuild Utility
=====================
Select one of the following:
All (a/A) - Rebuild all the indexes
Some (s/S) - Rebuild only some of the indexes
By Area (r/R) - Rebuild all the indexes in an area
By Schema(c/C) - Rebuild all the indexes owned by a schema
By Table (t/T) - Rebuild all the indexes in the table
Quit (q/Q) - Quit, do not rebuild
Enter your selection: