LogicalProject(EMPNO=[$0]) LogicalSortExchange(distribution=[hash[1]], collation=[[0]]) LogicalProject(EMPNO=[$0], ENAME=[$1], DEPTNO=[$7]) LogicalTableScan(table=[[scott, EMP]])
In this case the column `DEPTNO` is not required in LogicalSortExchange nor in the Project top on it.
- links to