CoachVectorised query execution runs each operator of a query plan on a batch of values of a column at a time (a vector of a few thousand), so that the per-call overhead is paid per batch and the inner loops are tight loops over arrays. Late materialisation delays assembling result rows from columns until after the filters: operators pass positions of qualifying rows, and only the surviving rows’ other columns are ever read.
