There are many ways to enhance the performance in the reporting environment and they are dependent on the database and environment that the reporting solution runs in. The following list some methods which can be used to optimize BIA Reporting:
- Database Indexing : Each of the database vendors include different indexing algorithms that can be used to increase the speed with which queries are serviced. BIA Reporting provides indexing but the optimal indexing strategy is dependent on the environment.
- Database Partitioning : Partitioning involves the task of breaking a single database table into sections which are stored in multiple files. The strategy used may increase performance.
- Materialized Views : A materialized view is a database object that contains the results of a query. As discussed in the section ' Running Reports ' materialized views can increase the performance when running reports.