Indexes may exist on any table defined in WhereScape RED.
By default, WhereScape RED will auto-generate several indexes during the drag-and-drop process to create new table objects and when building procedures.
The Enable Automatic Creation of Indexes option in the Connection Properties window enables you to turn ON/OFF the automatic creation of metadata for indexes when creating objects. Neither the RED metadata nor the physical index is created, if this setting is not enabled.
The generated indexes can be altered or deleted. New indexes can be created as required.
The maintenance of the indexes is performed as part of the normal scheduler processing.
In the left pane, right-click a table to:
- Display indexes
- Add indexes