Skip to main content
Previous sectionNext section

DDLUseExtentSet

Allow hashed names for globals that store index data of tables created by a DDL statement.

Synopsis

[SQL]    DDLUseExtentSet=n

n is either 1 or 0. The default value is 1.

Description

When DDLUseExtentSet is enabled (n = 1), a table created by a DDL CREATE TABLE statement stores its index data in globals that use hashed names. The hashed names typically allow for better performance when running queries against the table, but are less comprehensible to the user. When this parameter is not enabled, the index data is stored in globals named after the class.

Changing This Parameter

To set the desired value for DDLUseExtentSet from the Terminal, use the SetDDLUseExtentSet() method of the %SYSTEM.SQL class. See the class reference for details.

You can also change DDLUseExtentSet with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).