Rebuild Indexes

Rebuild Indexes is a menu option located in Utilities>Tools>Rebuild Indexes. All the tables with the respective index will be marked after step 20 is completed. To start the rebuild, simply click on the rebuild button. A password is needed to start the index rebuild. The password is provided to clients as needed by Oracle (currently controlled by development).

Select the following information and select the Rebuild button to complete the utility.

Top Pane

Tablespace Name. Select the specific tablespace name along the top of the screen or select the All button to display all of the indexes.

Left Pane

Table Name. Select one, more, or all of the table names to display the indexes that are part of each individual table name. Only the index names of the highlighted table will be displayed.

Right Pane

Index Name. Name of the individual index that is part of the Table Name.

Tablespace Name. Displays the tablespace name that the specific index name belongs to.

Build Date. Displays the last date and time the index was built.

Bottom Pane

Displays all of the columns in the table name that will be rebuilt with the specific index name.

Buttons

Rebuild. Rebuilds the selected Table Names, and their indexes, marked in the left pane.

Details. Displays the index details about the highlighted Table Name in the left pane.