How to add index in postgres using Talend

[m3h3r]

Hi,

I need to make my ETL process fast. So I want to first CREATE INDEX in tables postgres and run the job. I use component TDBRow but i didn't find the query.

Please suggest a way to do this.

Thanks

[root]

You can try https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F744&pi=marketplace%252F1%252Fproducts%252F744%252Fitems%252F1050

We use it to run adhoc DDL queries.