Performance after loading pre-11.9 databases

When pre-11.9 databases are loaded into an 11.9.2 Adaptive Server, the upgrade process inserts rows into the statistics tables, based on available statistics. The upgrade process does not scan the tables and indexes to generate the new types of statistics that can be used by the improved query optimizer. For statistics that are new in this version, the upgrade process inserts computed or magic values.

If you load a pre-11.9 database, run update statistics on the tables as soon as possible. If you experience performance problems after loading a pre-11.9 database, run update statistics for the tables in the application before you attempt other solutions.