Performance Best Practices for Database Loader

To obtain optimum performance when using Database Loader, consider the following points:

• Create Indexes which are shipped with the product as part of Seed Data.
• Create Indexes on data source as mentioned in Data Source Indexes.
• Create separate tablespaces or data files for large TIBCO MDM tables and Indexes. For information, refer to Tablespaces Configuration and Database Optimizations on Microsoft SQL Server - Customer Study.
• Disable logging on the Oracle database for the following tables:
  • MCT's
  • Productkey
  • Principalkey
  • Relationship
  • Goldencopy
  • MVT
  • RCT