Loading simulated statistics adds rows describing cache configuration to the sysstatistics table in the master database. To remove these statistics, use delete shared statistics. The command has no effect on the statistics in the database where the simulated statistics were loaded.
If you have loaded simulated statistics into a database that contains real table and index statistics, you can drop simulated statistics in one of these ways:
Use delete statistics on the table which deletes all statistics, and run update statistics to re-create only the non simulated statistics.
Use optdiag (without simulate mode) to copy statistics out; then run delete statistics on the table, and use optdiag (without simulate mode) to copy statistics in.
