Using simulated statistics

The optdiag utility allows you to load simulated statistics and perform query diagnosis using those statistics. You can load simulated statistics even for empty tables, which lets you perform tuning diagnostics even in small databases that contains only tables and indexes. Simulated statistics do not overwrite existing statistics when they are loaded.

Once you have loaded simulated statistics, instruct the optimizer to use them (rather than the actual statistics) by entering:

set statistics simulate on

See “Using simulated statistics”.