how to override a table's cardinality or statistics histogram
You can use the UPDATE STATISTICS  WITH ROWCOUNT and PAGECOUNT option 

See here some examples :
 https://www.mssqltips.com/sqlservertip/2870/using-with-rowcount-and-pagecount-option-of-sql-server-update-statistics/
or
https://sqlsunday.com/2016/02/27/update-statistics-with-rowcount/