A method of combining data in a database system, the method comprising: obtaining source data from a source data structure by performing a single scan of the source data structure; performing a plurality of merge operations using the source data, wherein each merge operation is an operation to combine the source data with data from at least one of a plurality of destination data structures contain