Strategy ONE

Secondary Index Type

The Secondary Index Type VLDB property allows you to define what type of index is created for temporary table column indexing. This VLDB property has the following options:

  • Create Composite Index for Temporary Table Column Indexing (default): This option creates composite indexes for temporary table column indexing. This is a good option to support most database and indexing strategies.
  • Create Individual Indexes for Temporary Table Column Indexing: This option creates individual indexes for temporary table column indexing. This can improve performance for some environments, including Sybase IQ. The order in which the index is created can also help to improve performance in these types of environments, and can be configured with the Secondary Index Order VLDB property (see Secondary Index Type).

Levels at Which You Can Set This

Database instance, report, and template