Oracle APPS :Reports Tuning
Columns used in a SQL WHERE clause should be indexed. The impact of indexes used on columns in the master queries of a report are minor, as these queries access the database once. To improve performance significantly, indexes should be used on any linked columns in the detail query.
Oracle Reports enables you to display data such as total number of pages or grand totals, in the report margins or on the report header pages.
Fetching-ahead requires the entire report to be processed before the first page can be output. The usual model is to format pages as and when required.
Although the fetched-ahead functionality does not affect the overall time the report takes to generate, it affects the amount of temporary storage required and the time taken before the first page can be viewed.
For more information on Reports tuning Click Here