Collect

Re-creation (Drop and Recreate)

In order to fine tune performance of an index, the index must be dropped and recreated.

To recreate an index:

  1. Click Targets in Navigation pane.
  2. Click Sources for Target.
  3. Click Tables for Source. 
  4. Click Indices for Table.
  5. Select Indices to rebuild.
  6. Click Build Indices icon on Page toolbar to schedule the rebuild process for all index in Target Source Table index; a confirmation message displays.

NOTE: Only registered indices and keys are rebuilt. Indices are built in the background and may take several minutes.