Solved my issue with mod, select count (1) where condition = constant and id mod 100 = 0, with this count, it's an estimated staticstic but it's pretty close...

I was happy too soon 🙁 The estimated row count from the execution plan is way off from the actual row count. Back to square one for me.

Oh well. I was happy too soon. The execution plan estimated way off the actual row count. Back to square one for me.

I solved my problem :-). The code below is written in C# on how to get the execution plan.

string connectionString = "Data Source=server; Initial Catalog=database; User Id=user;...

I read about the estimated execution plan but I don't know know to use it. 🙁 I will be reading more into it now. Select count (id) or select...