Creation of Indexes Before Running the Conversion
When processing records, many of the programs for the base currency conversion use data selection and data sequencing that do not have indexes. If conversion programs cannot find indexes, they try to build them. This takes an inordinate amount of processing time and causes serious performance problems.
The programs for the base currency conversion process millions of records, making performance a critical issue. By creating indexes before you run the conversion, you can help improve the time that it takes to process records.
Determine whether indexes have already been created for the tables that you are going to convert. For those tables in which indexes have not been created, be prudent and consider creating indexes for larger tables only.