SQl Analytics function

General

SQl Analytics function

Hi All,

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.

Regards,

Rakesh

Tags (1)
1 REPLY
Enthusiast

Re: SQl Analytics function

no it wont help in this situation.