The very fact that IN can produce different query plans than an equivalent EXISTS is a very nasty smell. As a developer, I shouldn't have to care. The databas

The very fact that IN can produce different query plans than an equivalent EXISTS is a very nasty smell. As a developer, I shouldn't have to care. The database is supposed to figure that out. That's why we're paying no small sum of money for this.