Intermediate Table Index

The Intermediate Table Index property is used to control the primary and secondary indexes generated for platforms that support them. This property is for permanent tables and temporary tables, where applicable. In the VLDB Properties Editor, select an option to view example SQL statements used by various databases for the selected option:

• Don't create an index (default)
• Create partitioning key (typically applicable to MPP systems)
• Create portioning key and secondary index on intermediate table
• Create only secondary index on intermediate table

Levels at Which You Can Set This

Database instance, report, and template