Viewing post 1 (of 1 total)
When INNER JOIN returns duplicate rows then INTERSECT returns distinct values only. Thats why the difference in execution time occurs.
May 23, 2010 at 11:06 pm
#1171376