Primary Index Type

Primary Index Type is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Primary Index Type property determines the pattern for creating primary keys and indexes. In the VLDB Properties Editor, select an option to view example SQL statements used by various databases for the selected option. The examples also display whether the option is applicable for a given database type. If you select an option that is not applicable for the database type that you use, then the other option is used automatically. While this ensures that the primary index type is correct for your database, you should select an option that is listed as applicable for the database that you use.

Some databases such as DB2 UDB support both primary index type options. Use the example SQL statements and your third-party database documentation to determine the best option for your environment.

Levels at Which You Can Set This

Database instance, report, and template