Indexes

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, some cloud databases like Snowflake do not support 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.