Creating and modifying indexes
PSQL enables to create and modify index on the physical model level.
Index creation is done using following steps:
- Right click on the table name in the table tree.
- Choose "Add index" from the popup menu.
- Enter the index name (eg. i1).
- Right click on the index name.
- Choose "Add column" from the popup menu.
- Choose the column name in the displayed dialog.
- Choose required column and press OK button.
- Continue in step 4 or finish.
Using that algorithm the user is allowed to create unlimited number of indexes.
To modify index you can use similar procedure. You are allowed to:
- Add columns (see above).
- Remove columns - right clisk on the column name in the index and
choose Remove column from the popup menu.
- Reorder columns - right click on the column name in the index and
choose Move up or Move down from the popup menu.
It is possible to remove index (mark removed respectivelly) - right click on the index name
and choose "Remove index" from the popup menu.
If index is modified or if columns involved are modified then index is automatically
recreated if alter table script is generated.