Reducing SQL Server I/O Contention during Sync :: Tip 2
All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.
SQL Compact 4
All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.