Tbl_Hurdle_Test Only has 25 000 rows why in the actual plan does the Table contain over 400 mil rows
In the table Tbl_Hurdle_Test has only 25 000 rows but on executing the query according to actual execution plan there is over 400 mil rows in the table.
How can this be? I have checked statisic and statistics also indicate that there are only 25 000 rows in the table.
On estimated execution plan the table also only contains 25 000 rows.
Thanks for your help.