I read this topic so many times "Logical Query Processing" , the first phase
"(1) FROM The FROM phase identifi es the query’s source tables and processes table
operators. Each table operator applies a series of subphases. For example, the phases
involved in a join are (1-J1) Cartesian Product,"
That's where I am confuse.. Does SQL Server engine reads all the records from table1 and table2 in memory and apply cross join and get Virtual table for us?
View Complete Post