The Query Analyzer has many useful features, which I won't cover here in an attempt to focus on the basics. To find out what those features are, use the toolbar or press F1 to get the Transact-SQL ...

Management Studio includes the functions of SQL Server 2000 Enterprise Manager, Analysis Manager, and SQL Query Analyzer in one tool, along with the ability to write MDX, XMLA, and XML statements.

Integrated into the MySQL Enterprise Monitor application, the query analyzer is meant to help designers and database administrators find any problematic SQL code hurting performance.