TIL: EXISTS SELECT 1 vs EXISTS SELECT * in SQL Server

from blog Just Some Code, | ↗ original
EXISTS is a logical operator that checks if a subquery returns any rows. EXISTS works only with SELECT statements inside the subquery. Let’s see if there are any differences between EXISTS with SELECT * and SELECT 1. There is no difference between EXISTS with SELECT * and SELECT 1. SQL Server generates similar execution plans in both scenarios....