I did a test on MS SQL 2005 using the following tables: A 400K rows, B 26K rows and C 450 rows. ... SQL ...
stackoverflow.com