When statistics are loaded into a database created solely for performing “what-if” analyses on queries, you must first veriy that:
The database named in the input file exists; it can be as small as 2MB. Since the database name occurs only once in the input file, you can change the database name, for example, from production to test_db.
All tables and indexes included in the input file exists. The tables do not need to contain data.
All caches named in the input file exist. They can be the smallest possible cache size, 512K, with only a 2K pool. The simulated statistics provide the information for pool configuration.
