USE AdventureWorks2022;  
GO         
SET STATISTICS IO ON;  
GO  
SELECT *   
FROM Production.ProductCostHistory  
WHERE StandardCost < 500.00;  
GO  
SET STATISTICS IO OFF;  
GO

如果输出physical reads 或者 read-ahead reads  大于0 ，则表示有物理读取

参考：

SET STATISTICS IO (Transact-SQL) - SQL Server | Microsoft Learn