Online Documentation for SQL Manager for PostgreSQL

Indexes


Indexes are objects used to find rows with specific column values quickly. If a table has an index for the columns in question, PostgreSQL can quickly determine the position to seek to in the middle of the data file without having to look at all the data.

 

Table indexes are managed within the Indices tab of Table Editor.

 

Creating Indexes

  • open the table in Table Editor;
  • proceed to the Indexes tab there;
  • right-click the tab area and select the New Index context menu item, or press the Ins key;
  • define the index properties using the Index Editor dialog.

 

Editing Indexes

  • open the table in Table Editor;
  • proceed to the Indexes tab there;
  • right-click the index and select the Edit Index context menu item, or simply double-click the index;
  • edit the index properties using the Index Editor dialog.

 

Dropping Indexes

  • open the table in Table Editor;
  • proceed to the Indexes tab there;
  • right-click the index and select the Drop Index context menu item;
  • confirm dropping in the dialog window.