> ## 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 - Distributed Sorting

### Synopsis

`DISTRIBUTE ORDER BY (number)`

### Example

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