Join Index Types
There are two basic types of join index:
You can define a join index with either a nonpartitioned or row-partitioned primary index, but keep in mind that you can define a join index with row-partitioned primary index only if it is not row compressed. See “Join Index Applications” on page 504. You can also define a join index with column partitioning (and no primary index) with optional row partitioning.
The MultiLoad and FastLoad utilities do not support target tables with join indexes. The workaround for this is to FastLoad new rows into an empty table and then use either a INSERT … SELECT or MERGE request to populate the indexed table (see SQL Data Manipulation Language for details).