Improving Babelfish query performance - Amazon Aurora
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Improving Babelfish query performance

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

Topics

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.