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.