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.