SQL Server is smarter than I had assumed
SQL Server can use statistical information about a table to optimise queries in ways you probably didn't expect.
SQL Server can use statistical information about a table to optimise queries in ways you probably didn't expect.