Index Post String and Index Qualifier

The Index Post String and Index Qualifier property can be used to customize the CREATE INDEX statement. Indexes can be created when the Intermediate Table Type is set to Permanent Tables, Temporary Tables, and Views (most platforms do not support indexes on views). These two settings can be used to specify the type of index to be created and the storage parameters as provided by the specific database platform. If the Index Post String and Index Qualifier are set to a certain string, then for all the CREATE INDEX statements, the Index Post String and Index Qualifier are applied.

The create index syntax pattern is as follows:

• All platforms except Teradata:

  create <<Index Qualifier>> index i_[Table Name] on [Table Name] ([Column List]) <<Index Post String>>

• Teradata:

  create <<Index Qualifier>> index i_[Table Name] ([Column List]) on [Table Name] <<Index Post String>>

Example

Index Post String

The Index Post String setting allows you to add a custom string to the end of the CREATE INDEX statement.

Index Post String = /* in tablespace1 */

create index IDX_TEMP1(STORE_ID, STORE_DESC) /* in

"tablespace1*/ 

Levels at Which You Can Set This

Database instance, report, and template