# Improving Babelfish query performance
<a name="babelfish-query-performance"></a>

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

**Topics**
+ [Using explain plan to improve Babelfish query performance](working-with-babelfish-usage-notes-features.using.explain.md)
+ [Using T-SQL query hints to improve Babelfish query performance](babelfish-tsql-hints.md)

You can also improve the query performance using `sp_babelfish_volatility` procedure. For more information, see [sp\$1babelfish\$1volatility](sp_babelfish_volatility.md).

You can also improve the query performance using subquery transformation and subquery cache. For more information, see [Optimizing correlated subqueries in Aurora PostgreSQL](apg-correlated-subquery.md).