How to create fake statistics for testing query plans

How to create fake statistics for testing query plans

  • Comments 1

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.

Leave a Comment
  • Please add 1 and 8 and type the answer here:
  • Post