DP-800: Developing AI-Enabled Database Solutions

You have an Azure SQL database that supports a customer-facing API. The API invokes a stored procedure named dbo.GetCustomerOrders thousands of times each hour.

Following a deployment that updated indexes and statistics, users report that the API endpoint supported by dbo.GetCustomerOrders is slower. In Query Store, the same query now has two persisted execution plans. Over the past hour, the newer plan has had a substantially higher average duration and CPU time than the older plan.

You need to restore the earlier performance quickly without modifying the API code.

Which Transact-SQL command should you run?