How can I improve the performance of the program FAGL_MIG_SUBSEQ_POST (Update Documents to New General Ledger Accounting)?
To improve the performance of the program FAGL_MIG_SUBSEQ_POST (Update Documents to New General Ledger Accounting), perform the following steps: a) Update database statistics for the table FAGLFLEXA. Before the migration, the table FAGLFLEXA is empty. The sequential processing of the program steps gradually fills the table FAGLFLEXA with data. When transferring documents from the current year to the new General Ledger, the program FAGL_MIG_SUBSEQ_POST whether each document exists in the table FAGLFLEXA. However, during the migration, the Cost-Based Optimizer (CBO) does not yet have the required information to select the right index for accessing the database tables. To solve the problem, proceed as follows: As soon as you have migrated some data to the new General Ledger tables (for example, after migrating open items and before migrating documents from the current year), you should run the CBO or update table statistics. The programs should then use the correct index for the database
