Simple Join Indexes
The primary function of a simple join index is to provide the Optimizer with a high‑performing, cost-effective means for satisfying any query that specifies a frequently performed join operation. The simple join index permits you to define a permanent prejoin table without violating the normalization of the database schema. Simple join indexes are also referred to as multitable join indexes.