How to add indexes to CARTO datasets
PostgreSQL indexes help users to speed up data retrieval in costly operations such as filtering, joining or grouping by some column name and/or expersion. In order to add one to your table, you will need to use the following syntax:
CREATE INDEX idx_column on table_name (column)
You can learn more about
CREATE INDEX operations in PostgreSQL documentation.