Indexes Wizard (PostgreSQL)

From DBArtisan
Jump to: navigation, search

Go Up to PostgreSQL Object Wizards

This wizard lets you build and submit a CREATE INDEX or CREATE UNIQUE INDEX statement, creating a new index on a table.

To create a new index using a wizard:

  1. Open a creation wizard for an index. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Indexes (PostgreSQL) - Properties

When creating or editing a domain, this tab/panel lets you work with the following settings:

Setting Availability and Description

Parent Type

Lets you specify whether the index is being defined for a table or view.

Table Schema and Table Name

Select the schema and name of the parent table.


Provide a name for the index being created.


If selected, CREATE UNIQUE INDEX DDL is generated, enforcing uniqueness. Otherwise simple CREATE INDEX DDL i generated.


If selected, s CONCURRENTLY parameter is added to the generated DDL, specifying that the index is built without taking any locks that would prevent concurrent inserts, updates, or deletes on the target table.


If selected, an ALTER TABLE... CLUSTER ON... statement is generated following the DDL to generate the index, specifying this index as the default for subsequent cluster operations.


Lets you optionally select the tablespace on which the index is to be created. If not specified, the default tablespace will be used.

Index Method

Lets you specify a USING option value of btree, hash, gist, gin, or spgist.

Fill Factor

Lets you add a FILLFACTER= option value, specifying the percentage that the index method will try to fill index pages.

Fast Update

Lets you add a FASTUPDATE= ON option, enabling fast update.


Available with an Index Method of gist. Determines whether the buffering build technique is set to ON, OFF, or AUTO.


Lets you provide a WHERE condition that will be used as a constraint expression for a partial index.

Indexes (PostgreSQL) - Columns

From the Column dropdown, select a column for the index and specify Sort, Collation, and Operator Class option. To add more columns, click the New button and then follow the steps in the last instruction. Use the Delete button to drop columns.