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.
By sleon 0 asked Apr 11, 2017 at 01:45 PM