Query Analyzer SQL Query Analyzer is an interactive, graphical tool that enables a database administrator or developer to write queries, execute multiple queries simultaneously, view results, analyze the query plan, and receive assistance to improve the query performance.
query optimizer The SQL Server database engine component responsible for generating efficient execution plans for SQL statements.