​
Synopsis

DISTRIBUTE ORDER BY (number)

​
Example

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;