1. Base Currency Conversion Implementation Guide
  2. Creating Indexes Before Running JD Edwards EnterpriseOne Base Currency Conversion

Creating Indexes Before Running JD Edwards EnterpriseOne Base Currency Conversion

The type of database that you use determines whether you use the Where or Order By clause to create an index.

See Clauses for Conversion Program Indexes.

  1. Compile a list of tables in which you want to create indexes.

  2. Create an index for each table.

    Use structured query language (SQL) to run the Create Index command for the database.

  3. For Oracle and SQL server databases, update statistics for the tables involved using the Analyze Table (Oracle) or the Update Statistics (SQL Server) command.

  4. Run the base currency conversion.

  5. After you successfully complete the base currency conversion, delete the indexes that you created in step 2.