• EXCEPT is not optimized to perform like a join. it's the same as doing thing as you dumping your first query into a temp table and then deleting any rows that match the second query. A properly written join or sub-select could do this more efficiently.

    Also remember that with EXCEPT both queries have to have the same columns and all columns will be compared.