1.2 Summary Query performance Enhancements

This topic provides an overview of summary query performance enhancements for handling the high volume data.

Oracle FLEXCUBE Development Workbench provides the developer with a user-friendly console for defining criteria-based search for handling the high volume data with the following parameters. The following parameters/features are introduced for performance enhancements:

• Criteria Based Search
• Minimum number of Search Characters
• Lov Details

Figure 1-4 Summary Details Screen

Criteria Based Search

Criteria Based Search is present in the Summary screen. If the user wants to enable a Criteria Based Search feature for the Summary screen, select the checkbox for a Criteria Based Search. Then on clicking the Property button, the user will have to provide the minimum search character length for that field.

Figure 1-5 Criteria Based Search

Description of "Figure 1-5 Criteria Based Search"

Minimum Number of Search Characters

If the user wants to provide minimum search character length for the Lov for handing high volume data, the user has this option to provide a minimum number of characters required for the Lov to fetch the result of Lov.

If the user is not providing a minimum number of characters of the Lov while querying in the Summary screen, then the user will get an error message to provide minimum search character length.

There is a restriction to this field. If the user enters a value that is greater than the value of the field in the data source level, then ODT will not allow it, it will throw an error message.

LoV Details

If a particular summary field needs to be attached to a Lov, then the user has to provide these details on click of the Property button. The user can map the corresponding return fields and the related bind variables.

Click Default From Lov Definition, then choose the required query columns, corresponding Block Name and the Return Field Name.