Consultor Eletrônico

Status: Unverified

GOAL:

How to rebuild the indexes for just one table.

GOAL:

Can an index rebuild be run for just one table?

FIX:

To rebuild the index for just one table, the user will need to know the index names for that particular table.
That information can be obtained through the data dictionary, either by running the quick index report or by displaying the indexes for that particular table.

Run the command: proutil <dbname> -C idxbuild

The following menu should appear:

Index Rebuild Utility
=====================

Select one of the following:
All - Rebuild all the indexes
Some - Rebuild only some of the indexes
Quit - Quit, do not rebuild

Enter your selection:

Select: SOME

*** The Following Message will appear:
Enter the name of table containing the index.

Enter ! to indicate input is complete. (9176)

Table name:

Enter the name of the table in question and then the user will be prompted to enter the index name.

Index name:

If the table has several indexes, the user will need to need to repeat the process of entering tablename and indexname for each index of the table.
When all indexes have been entered, the user should enter the exclamation mark (!) the next time they are prompted to enter a table name.

The following summary will appear:

The following indexes will be rebuilt:
Owner: PUB
Table: Benefits
Index: EmpNo

Is this correct? (y
)

Select Y (yes) to the prompt if the information is correct.
The user then will be prompted to verify disk space:

Do you have enough disk space for index sorting? (y
)
Select Y (yes) if there is sufficient space.

The index rebuild for the table in question will commence.