How to analyze the database to improve the performance of reports? - BO Designer

How to analyze the database to improve the performance of reports?

- Execute the SQL from SQL Navigator(A reporting tool) / Toad after passing all the required parameters

- Identify the performance of SQL , whether it takes less time or more time than the report. If the time is less than the report time then the problem is with the Universe. Otherwise the problem is with the report

- Execute an ‘explain plan’ on the SQL.

- Verify if indexes are built and used. Verify if aggregate tables can be utilized.

- Use materialized views which enable the pre-execution of complex joins and stores the data.

- Outer joins need to be checked properly

- Remove unnecessary outer joins

- Delete unnecessary or additional filters on the report