Indexes are always associated with a table. To define a new index, the menu option associated with the table that is to have the index must be used.
Following is an example of the context menu displayed when you right-click an index.

WhereScape RED supports the use of keyboard shortcuts—the underlined letter of a menu option. For example, pressing P opens the Properties window of the selected table, pressing C creates the index, etc. Ensure that the Windows > Control Panel > Ease of Access setting associated with keyboard shortcuts is enabled, to display keyboard shortcuts in RED. Refer to the relevant MS Windows documentation for details.

If a procedure has been locked as a result of the WhereScape RED utility being killed or failing or a database failure then it can be unlocked via the Properties screen associated with the procedure.

Menu Options

Description

Properties

Select this option to display the Properties screen, which contains the entire definition of the index, including the columns in use and the index type, etc. The way that the scheduler handles the index is also defined in the Properties. An index can be set so that it is dropped by the scheduler before a table update and then rebuilt by the scheduler, once the update has been completed. It can also be defined as rebuilding on certain days.

Create Index

Select this option to create an index in the database.

It may take some time for large indexes, and in such cases, it is better to schedule the creation of the index. Refer to Scheduler for details. This menu option is intended for use when working with prototype data volumes.


Drop Index

Select this option to drop the index in the database.

Delete Metadata and Drop Index

Select this option to remove metadata definition of the index and drop it from the database. No recovery is possible once this option is executed.A version of the object's metadata is normally auto-created (depending on the settings in Tools > Options > Metadata Versioning).

Create via Scheduler

Select this option to submit a creation of the index to the scheduler.

Projects

Select this option to:

Multiple objects can be selected by double-clicking the Object Group icon in the left pane and then Ctrl + clicking multiple objects in the Drop Target (middle) pane.


Build

Select this option to build a Scheduler job or an application based on the Index table(s) selected from the middle pane. Refer to Building Scheduler Jobs from Object Groups and Building Applications from Object Groups for details. This option is available from the context menu of Index tables listed in the middle pane.


  • No labels