APEX

Hi All,


I have developed an application in oracle application express 3.2.My data size is very huge and reports are taking too much time in displaying contents.

I have 30 million records in the table which has 4 years of data.

Filters on the user interface are company,month,year,work location,employee name and category.Since this is my first application.Also first time i am working in Oracle database and APEX.So i don't have any idea in which way i can make it faster.


I guess this can be done by some modification in tables like generating indexes or something else.

Please guide me on this it will be highly appreciated.

Also i am not using any images,graphical thing which is causing any delay in report generation.I am just creating a simple report and showing values sum,group by.

Since my application is ready and already in production So it will be difficult to do changes in the report level.If by doing any changes in the tables can make it faster that would be really great.


Regards,
Oracle Rookie