many-to-many joins . support joins where both sides are too large to fit into memory. available in our / release optimize foreign key joins . optimize foreign key joins by leveraging our skip scan filter. available in our / release semi/anti joins . support semi/anti subqueries through the standard [not...