Live Query Statistics in SQL Server 2016

Live Query Statistics.sql

-- Script to demonstrate the Live Query Statistics Feature in SQL Server 2016

SELECT * FROM Production.Product PR
INNER JOIN Production.Product_ondisk PO 
ON PO.SellStartDate = PR.SellStartDate
--ON PO.ProductSubcategoryID = PR.ProductSubcategoryID
INNER JOIN Production.ProductModel PM
ON PM.ProductModelID = PR.ProductModelID
CROSS APPLY Production.ProductSubcategory PSC
WHERE PR.ProductNumber LIKE '%FR%'


--------------------------------------------------------------

SELECT * FROM Production.Product PR
INNER JOIN Production.Product_ondisk PO
ON PO.FinishedGoodsFlag = PR.FinishedGoodsFlag
CROSS APPLY Production.ProductSubcategory PSC
WHERE PR.ProductNumber LIKE '%FR%'