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 data source. Therefore, create the index file before the actual upload or re-upload the data source after creating the index file.