Transfering stats to another database
I have the following problem. I work for a small software vendor, and we have an application that can be deployed on Oracle or SQL Server. During the install process, we use our standard, out of the box , APIs to load several tens of thousands of rows of data into the system. This process runs acceptably if we import some representative stats into the schema using the dbms_stats.import_schema_stats procedure. If we don't import these stats, performance tanks because the plans are horrible. Now in our testing of a procedure to import these stats we have discovered that the import
0