Community

Destination Improvement: replicate indexes from source tables to destination

Parmjit Bajwa User

Can connectors sync the indexes for the tables from the source to the destination to improve performance of the destination database

Please sign in to leave a comment.

2 comments

Official comment

Kevin Kim Fivetranner
- March 07, 2022 03:34
Hi Parmjit,

Thank you for your feedback on our feature request portal! I'm Kevin from the product team here at Fivetran.

We don't have a concrete timeline at the moment for adding this feature. However, many customers have asked for this same functionality, so I will be sure to add yours to the tally. Can you share any additional information on the types of indices you are using, as well as how you plan to use them in the destination database? Is this primarily for performance, or are they any other potential benefits that you would like to highlight?

Any insight you can share will help us scope out this project!
Jack Dyer User
- July 26, 2022 16:08
Hi,

We would like to upvote this feature and understand future timelines. Our connector is a Heroku Postgres connector and supplies most of our core tables for the business. We require the indexes for database performance and will need to look into alternative products as this feature is core to our table use. Everything in our database is slower because of this, we also lose our uniqueness definitions.