The alternate index is used to access records other than base key. The dataset over which alternate index defined is called base cluster.
Advantages
- Can be defined for both KSDS and ESDS
- reduce data redundancy
- Can have duplicates
- Easy to define using IDCAMS
- allow datasets to be accessed by both sequentially and randomly
Disadvantages
- Performance degradation
- Complex update logic
Also Read: