Requirements for loading and using simulated statistics

To use simulated statistics, you must issue the set statistics simulate on command before running the query.

For more information, see “Running queries with simulated statistics”.

To accurately simulate queries:

Simulated statistics can be loaded into the original database, or into a database created solely for performing “what-if” analysis on queries.