Remove unused `consider_intermediate_updates` flag..optimizing query