How to create fake statistics for testing query plans

Published Mar 23 2019 04:52 AM 200 Views
Microsoft
First published on MSDN on Mar 12, 2007

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.


Version history
Last update:
‎Mar 23 2019 04:52 AM
Updated by: