O'Reilly logo
  • Dustin Waybright thinks this is interesting:

SQL Server knows that with a cross join followed by a filter it can evaluate the filters first (which is especially efficient when there are indexes to support the filters), and then match the remaining rows.


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


Thus optimizing what could be a massive product of rows.