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.
You can deceive the optimizer by using ROWCOUNT and PAGECOUNT options of UPDATE STATISTICS.I don't this its documented in MSDN(not sure).I rememebr reading this in a SQL Server Performance Tuning book from Wrox publishers.Also the link has details
