Using indexes with Heroku Connect

Issue

Salesforce allows users to enable indexing for certain fields. These indexes behave much like those in a traditional database.

New mappings within Heroku Connect do not import indexes from Salesforce.

Resolution

Heroku Connect offers the ability to add a simple index through a mapping's edit page in the Heroku Connect dashboard. While these are only simple indexes, they comes with the additional benefit of being included when a connection's configuration is exported. If a more complex index is desired, while it won't be exported with a connection's configuration, one may be added using PostgreSQL directly.