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:
- Open a creation wizard for an index. For details, see Opening an Object Wizard.
- 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.
- 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.