R007032 report taking too much time
Dear Oracle ,
We run R007032 report quarterly for total data. It is taking tooo much time. Some times it is ending without conclusion.
The same report I have prepared an Oracle Query (given below) in SQL Developer. It is giving result in less than 2 minutes.
{
select a.* from
(
select glicut, glicu, sum(glaa/100) as glaa from f0911 where gllt = 'AA'
group by glicut, glicu
)a
where a.glaa <> 0
}
Kindly provide us solution.
thank you,
regards,
david raja