I am using:
- SQL Server Management Studio v18.1
- SQL Server 2017 CU9
- AdventureWorks restored from here
Test query:
USE [AdventureWorks];
GO
SELECT TOP (13) *
FROM Sales.SalesOrderHeader AS s
INNER JOIN Sales.SalesOrderDetail AS d ON s.SalesOrderID = d.SalesOrderID
WHERE s.TotalDue > 1000
OPTION (RECOMPILE);
GO
Turn on Actual Execution Plan (Ctrl+M). Looking at the 'Clustered Index Seek' I see 13 of 17 (76%)
. Looking at the properties I see Estimated Number of Rows
or Estimated Number of Rows to be Read
value is 3.85562. My question is where is this number 17 coming from?