How can I index a column in the retool DB?

agam · November 3, 2023, 2:16pm

Goal: Speed up my queries by indexing heavily read and filtered columns.

Where can I dictate what to index?

ScottR · November 3, 2023, 2:20pm

Hi @agam
See this post to connect an IDE to your Retool DB then you should be able to create index on a table

Anthony_Chen · November 3, 2023, 6:14pm

Hi @agam,
You can follow instructions here to access your retool database connection strings. Once you have that, you can connect to your database to add indexes.

joeBumbaca · November 13, 2023, 4:31pm

You can also add indexes to the RetoolDB tables from a SQL mode RetoolDB query in a Retool app as well.