GilaMonster (7/28/2015)
Not really surprising. IN is usually a tad faster than a join (a very, very small amount). Changing the IN to a join may have also changed the logic of the query, resulted in more rows, etc, etc.
Gila, Thank you for your valuable feedback; as always. 🙂