SQL Implementation › Separate View and Index Creation

Separate View and Index Creation

Beginning with Release 5.2 you can specify not to generate an index and also retain *IMMED maintenance capability for the access path on the IBM i. Prior to Release 5.2, if you specified *IMMED maintenance for an SQL access path, SQL DDL to create an index was unconditionally generated into the source member of the access path following the DDL for the view.

In the current implementation of SQL you can:

• Suppress the generation of an index by specifying *NONE or blank for the index name on the Edit Access Path Auxiliaries panel.
• Rename an index.
• Generate an index without a view.

A discussion of these capabilities follows.