> ## Documentation Index
> Fetch the complete documentation index at: https://docs.regatta.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Hint - Join distribution

### Synopsis

`DISTRIBUTE JOIN ([ join_alias, ] number)`

Define distribution level for the specific `JOIN` by using the keyword **DISTRIBUTE JOIN** followed by the objects to join and the requested distribution number of nodes to execute the join.

Like all the other hints related to joins, this hint requires an explicit join with an alias. If no join is specified, the hint will affect all the joins in the statement.

Specifying multiple hints with the same **join\_alias** and different numbers is contradictory and is not allowed. Specifying multiple hints without **join\_alias** and with different numbers is contradictory and is not allowed.

### Example

```sql theme={null}
SELECT /*++ DISTRIBUTE JOIN (dept_join, 2) */ name, id
FROM (staff s JOIN org o ON s.deptno = o.deptno) as dept_join
WHERE o.division = 'EASTERN';
```