Any performance debate amongst Except, Intersect, Exists and their variants?

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Generally speaking, EXCEPT, INTERSECT and UNION compare all the fields in the input queries, so it's not always what you want to do.

Anyway, it's just the actual execution plan that counts, not the syntax of the statement.

Different syntaxes can produce the exact same execution plan.

This is a good explanation on the difference between not exists and not in:

Hope this helps

Gianluca

-- Gianluca Sartori