Running SQL Server 2008 Enterprise, SP1 CU7, 10.00.2766.
When executing a query with multiple joins, I get the following from the execution plan on a table, which is a Clustered Index Seek node in the execution plan:
Actual Number of Rows: 27779037
Estimated Number of Rows: 3486
When I exectute the following on the table upon which this clustered index seek was performed, I get 238,850.
SELECT COUNT(*) from dbo.MyTable
Now, I am sure someone is tempted to say, "Your statistics are out of date", or "You need to update statistics".
Okay, granted, I understand that may be an issue, but that is not the reason for this post, or answering my question, which is:
How can the Actual Number of Rows, (may I repeat, the Actual Number of Rows, not the Estimated Number of Rows) be 27,779,037 when the number of rows in the table are only 238,850?
Also, the node that gives these metrics, is the beginning node in the branch, that is, the node that gives an Actual Number of Rows of 27,779,037 is not fed by any other nodes, or incoming data nodes. It is the beginning node in the branch, not being fed by any other nodes.