title: Does EXCEPT execute faster than a JOIN when the table columns are the same
body: <p>To find all the changes between two databases, I am left joining the tables on the pk and using a date_modified field to choose the latest record. Will using <code>EXCEPT</code> increase performance since the tables have the same schema. I would like to rewrite it with an <code>EXCEPT</code>, but I'm not sure if the implementation for <code>EXCEPT</code> would out perform a <code>JOIN</code> in every case. Hopefully someone has a more technical explanation for when to use <code>EXCEPT</code>.</p>