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.