SUM (Salary) over (partition by deptId order by deptId desc) as TotalDeptSalary
FULL OUTER JOIN
In Employee Table i have created a NUPI on EmpId, Whereas in the Departments Table i created NUPI on DeptId. For the above query i want to create a join index on DeptId. To my knowledge we cannot create aggregate join index on analytical functions. wat is the other way to create join index for the above query.