How do I see execution plans or optimize queries in Babelfish?

There a number of options in Babelfish. Consider exploring the docs for a full guide. However, here are the top relevant options:

• Using explain plan to improve Babelfish query performance
• Use PostgreSQL's auto_explain to better understand how the PostgreSQL engine is processing Babelfish/T-SQL queries.

It's important to try both options so that users get familiar with the Babelfish engine and how it processes T-SQL. Keep in mind, PostgreSQL and SQL Server are very different engines, and you may need to re-optimize queries for PostgreSQL or eliminate implicit conversions.