A method of processing data in a database, wherein the database includes a first table and a second table, each of the tables having a plurality of rows of data, wherein a key identifies one or more rows of data in the tables, and wherein there is a plurality of matching key pairs among the tables, each key pair including (i) a key of a first table, and (ii) a matching key and a unique row of a second table, the method comprising:
- (a) simultaneously processing row data of key pairs associated with a first row of the second table of the database;
- and
- (b) simultaneously processing row data of key pairs associated with any remaining rows of the second table of the database in sequential row order.