--configure query Store
USE AdventureWorks2025
GO
ALTER DATABASE AdventureWorks2025
SET QUERY_STORE = ON;
GO
ALTER DATABASE AdventureWorks2025
SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 150);
--repeat query
SELECT h.OrderDate ,h.CustomerID , p.name, OrderQty , d.UnitPrice
FROM Sales.SalesOrderHeader AS h
INNER JOIN Sales.SalesOrderDetail AS d
ON h.SalesOrderID = d.SalesOrderID
INNER JOIN Production.Product AS p
on p.ProductID = d.ProductID;
GO 100
SELECT od.productid, p.name, SUM(od.orderqty) AS UnitsSold, SUM(od.orderqty *
od.unitprice) AS TotalSales
FROM Sales.SalesOrderDetail AS od
INNER JOIN Production.Product AS p ON od.productid = p.productid
GROUP BY od.productid, p.name
ORDER BY od.productid;
--
SELECT plan_id, query_id, [compatibility_level], is_forced_plan, count_compiles,
last_compile_start_time, last_execution_time
FROM sys.query_store_plan
