MERGE (Transact-SQL) - MSDN - Microsoft

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL .... Because the MERGE statement performs a full table scan of both the source ...

msdn.microsoft.com