Oracle APPS :Reports Tuning
Database Indexes
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.
Fetching Ahead
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
