SQL Server has an optimizer that usually does a great job of optimizing code for the most effective execution. A query execution plan is the breakdown of how the optimizer will run (or ran) a query.

Does anyone know how Query Analyzer calculates the cost for the various values it gives, particuarly stuff like "Estimated I/O Cost" when you are looking at an Estimated Execution Plan?