Updated the indexed joins.