set statistics on a table RRS feed

  • Question

  • If a table has only 200M rows, is it possible to run some SP or SQL to update the statistics to make SQL server think the table have 400M rows. I know it is not good to do that, but in my case I think it will help as it will increase the memory for sort. 
    Friday, November 4, 2011 12:45 AM