🔥 3-day streak
Microsoft Azure Database Administrator Associate139 / 144
Question 139 of 144

A developer reports that a stored procedure on your Azure SQL Database (compatibility level 150) has become much faster than it was on an older on-premises SQL Server 2016 instance, without any code changes. The procedure loads several thousand rows into a table variable and then joins that table variable to a large fact table. On the old server, the query plan always assumed the table variable contained only 1 row, causing nested loop joins and poor performance. Which Intelligent Query Processing feature is responsible for the improvement on Azure SQL Database?

Reviewed for accuracy · Report an issueNext question