I have come to know that the use of anaytics function is much better than the native sql coded. but the question is how can we understand how the execution of analytics differ from that of a normal sql.
For supposition purpose lets I have sql query like
select empno,deptno,min(sal) over (partition by grade),max(sal) over (partition by grade)
from emp where hiredate >= 2011-01-01
Note : Unique primary index is empno
how does analytics help in this situation.