Skip to main content
Indexes

How to create indexes on tables

SqlDBM Support avatar
Written by SqlDBM Support
Updated this week

An index helps to speed up SELECT queries and WHERE clauses, but it slows down data input, with the UPDATE and the INSERT statements. Indexes can be created or dropped with no effect on the data.

Note that not all databases and project types support the creation of indexes.

Create an index

To create a table index, select the desired table and go to the "Indexes and Keys" section of the table properties on the right panel.

Press the "+" icon to create an index. On the next screen, specify the index name and properties, selecting the columns that will form the index.

Toggle the index creation on and off by selecting the "Generate" option.

To review existing indexes

Select the desired table and go to the "Indexes and Keys" section of the table properties on the right panel.

Click on the index name to review its properties.


See also

Did this answer your question?