REMOTE NESTED JOIN BETWEEN PRIMARY ACCESS MODULE PROCESSORS (AMPS)

摘要

A query optimizer identifies a condition that supports a remote nested join. A first Access Module Processor (AMP) is sent the condition to obtain a first set of rows that satisfy the condition from a first table and the first AMP is instructed to perform the remote nested join with a second remote AMP to acquire a second set of rows that satisfy the condition from a second table. The first AMP joins the first set of rows and the second set of rows as a join result, which is returned to the query optimizer.

主权项

1. A method, comprising:
identifying, by a processor, a condition for a remote nested join between a first table and a second table of a Relational Database Management System (RDBMS); sending, by the processor, the condition to a first Access Module Processor (AMP) having first rows from the first table that satisfy the condition and directing the first AMP to identify a second AMP to perform the remote nested join on second rows from the second table with the first rows and provide a join result from the remote nested join, wherein the second AMP includes the second rows that also satisfy the condition.