How to create fake statistics for testing query plans

  • Article

This is very cool - an undocumented option to UPDATE STATISTICS that allows you to fool the server into thinking a table has more rows or pages than it actually has - very useful for testing. See this blog post on the old Query Optimizer team blog. Thanks to Tony Rogerson for pointing it out.