The join indexes are updated to reflect any updated records stored in the table, wherein {TAIL ~ one or more common joins} are identified among {HEAD ~ the join indexes}, each of the common joins are materialized only once in a common spool file, and 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 { TAIL ~ one or more common joins } are identified among { HEAD ~ the join indexes } , each of the common joins are materialized only once in a common spool file , and 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 TAIL TAIL TAIL TAIL TAIL TAIL TAIL TAIL TAIL OTH OTH OTH 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 OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH