Total Pageviews

May 3, 2017

5/03/2017 12:03:00 AM

Oracle APPS :Reports Tuning

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
Related Posts Plugin for WordPress, Blogger...