The join indexes are updated to reflect any updated records stored in the table, wherein {HEAD ~ one or more common joins} are identified among the join indexes, each of the common joins are materialized only once in a common spool file, and {TAIL ~ the common spool file} is used to materialize one or more rows for updating the join indexes 
The join indexes are updated to reflect any updated records stored in the table , wherein { HEAD ~ one or more common joins } are identified among the join indexes , each of the common joins are materialized only once in a common spool file , and { TAIL ~ the common spool file } is used to materialize one or more rows for updating the join indexes
OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH HEAD HEAD HEAD HEAD HEAD HEAD HEAD HEAD HEAD OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH TAIL TAIL TAIL TAIL TAIL TAIL TAIL TAIL OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH