Description of the illustration in_mem_joins.gif

This graphic depicts how vector joins are used to run queries more effectively. On the left is the CUSTOMERS table and on the right is the SALES table, both stored using columnar format. An straight line, labeled country_id='FR', with a filter operator to its right, joins CUSTOMERS to SALES. The first column in the SALES table is labeled country_id.