Hello Every one,
I am using
(SELECT ROW_NUMBER() OVER (PARTITION BY ft.EmpID , dimdt.YEAR_NUMBER, dimdt.MONTH_OF_YEAR_NUMBER ORDER BY dimdt.Date DESC) row_number
, field1
.field2 .. ec
my ft table has millions of row. I can get the result (month end most recent records of each employee) what I want but it is very slow rather extremely slow. Is there any alternative or a way to optimize the performance?
thanks
I am using
(SELECT ROW_NUMBER() OVER (PARTITION BY ft.EmpID , dimdt.YEAR_NUMBER, dimdt.MONTH_OF_YEAR_NUMBER ORDER BY dimdt.Date DESC) row_number
, field1
.field2 .. ec
my ft table has millions of row. I can get the result (month end most recent records of each employee) what I want but it is very slow rather extremely slow. Is there any alternative or a way to optimize the performance?
thanks