Improving Babelfish query performance - Amazon Aurora
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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.