You can use the graphical showplan feature of SQL Server Query Analyzer to learn more about how the optimizer will process your statement.