Improving Babelfish query performance

You can achieve faster query processing in Babelfish using query hints and the PostgreSQL optimizer.

Topics

• Using explain plan to improve Babelfish query performance

• Using T-SQL query hints to improve Babelfish query performance

You can also improve the query performance using sp_babelfish_volatility procedure. For more information, see sp_babelfish_volatility.

You can also improve the query performance using subquery transformation and subquery cache. For more information, see Optimizing correlated subqueries in Aurora PostgreSQL.