Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Poole Intersect, Except, Union, All and Any RE: Intersect, Except, Union, All and Any

  • May 23, 2010 at 11:06 pm

    #1171376

    When INNER JOIN returns duplicate rows then INTERSECT returns distinct values only. Thats why the difference in execution time occurs.