Skip to main content


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


[SQL]    DDLUseExtentSet=n

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


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 SetOption(“DDLUseExtentSet”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change DDLUseExtentSet with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

FeedbackOpens in a new tab