Skip to main content
Previous sectionNext section

DDLDefineBitmapExtent

Determines whether a table created by a DDL statement defines a bitmap extent index.

Synopsis

[SQL]    DDLDefineBitmapExtent=n

Description

The value n may be 1 or 0:

  • When 1 (true), a table created by a DDL CREATE TABLE statement defines a bitmap extent index. The index improves the performance of COUNT(*), a function that returns the number of rows in the table.

  • When 0 (false), the table does not define a bitmap extent index.

Examples

DDLDefineBitmapExtent=1

Range of Values

0 or 1. The default is 1.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Do classes created by a DDL CREATE TABLE statement define a bitmap extent index for the class? setting, choose Yes (true) or No (false).