Indexes Wizard (PostgreSQL)

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:
   • Properties panel - Indexes (PostgreSQL) - Properties.
   • Columns panel - Indexes (PostgreSQL) - Columns.
   • Comment panel - for details, see Adding a Comment to an Object.
   • DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
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.
Name	Provide a name for the index being created.
Unique	If selected, CREATE UNIQUE INDEX DDL is generated, enforcing uniqueness. Otherwise simple CREATE INDEX DDL i generated.
Concurrently	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.
Clustered	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.
Tablespace	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.
Buffering	Available with an Index Method of gist. Determines whether the buffering build technique is set to ON, OFF, or AUTO.
IndexPredicate	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.