Secondary Index Order

The Secondary Index Order VLDB property allows you to define whether an index is created before or after inserting data into a table. This VLDB property has the following options:

• Create index after inserting into table (default): This option creates the index after inserting data into a table, which is a good option to support most database and indexing strategies.
• Create index before inserting into table: This option creates the index before inserting data into a table, which can improve performance for some environments, including Sybase IQ. The type of index created can also help to improve performance in these types of environments, and can be configured with the Secondary Index Type VLDB property (see Secondary Index Order).

Levels at Which You Can Set This

Database instance, report, and template