The join indexes are updated to reflect any updated records stored in the table, wherein 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 the common spool file is used to materialize {HEAD ~ one or more rows} for updating {TAIL ~ the join indexes} 
The join indexes are updated to reflect any updated records stored in the table , wherein 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 the common spool file is used to materialize { HEAD ~ one or more rows } for updating { TAIL ~ the join indexes }
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 OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH HEAD HEAD HEAD HEAD HEAD HEAD HEAD HEAD REL REL TAIL TAIL TAIL TAIL TAIL TAIL TAIL