Indexes on Data Sources

Data source indexes are required while importing data using database loader. It is also helpful when multiple data sources are joined in the direct load import and the load sizes are huge, that is, more than 200 thousand.

Create the index file under: $MQ_COMMON_DIR\enterpriseinternalname\datasource \datasourcename.idx. Filename must match to the data source name. Each new line in this file represents an index. Composite index multiple columns can be specified with a comma separated.

Indexes are created only when uploading a data source. Therefore, create the index file before the actual upload or re-upload the data source after creating the index file.

Example 1: For Option loaddb and loaddbwithcontains

If the CID column of the DF_33969_37793_TAB data source table is mapped to PRODUCTID; and not mapped to PRODUCTIDEXT, create an index file as UPPER("CID").

Example 2: For Option loadrelationship

If the CID column of the DF_33969_37793_TAB data source table is mapped to PRODUCTID, and CEXT is mapped to PRODUCTIDEXT, create an index file as UPPER("CID"),UPPER("CEXT")

Syntax of the index file based on the databases is as follows:
  • Oracle: UPPER("CID"),UPPER("CEXT")
  • Microsoft SQL Server: CID,CEXT
  • PostgreSQL: CID,CEXT