Depends on your SQL engine. SQL Server will do a index seek and a key lookup. It’s not as fast as UNION ALL, however for most queries it’s close enough. It’s also more readable.