Online Documentation for SQL Manager for PostgreSQL

Managing indexes


The Indices tab is provided for managing indices for the Materialized views only. Double-click an index to open Index Editor for editing the index.

 

Right-click the area to display the context menu allowing you to Create new, Edit, Rename, Drop, Reindex the selected index, or Reindex all indices. Using the menu you can also export the list of the table indices to any of the supported formats.

 

Indices management tools are also available through the Navigation bar and toolbar of View Editor.

 

If necessary, you can also use the Index Description area below to supply a description for each index.

 

View Editor - Managing indices

 

NOTE: This tab is only available for materialized views.