General Setup for Pages

To incorporate the Database Optimization Hint on a page that enables virtual result sets, follow these steps:

  1. Add the page that will incorporate the Database Optimization Hint to Page Preferences (PGPREF).

  2. Enable the “Use DB Optimization Hint” option for the page entry.

  3. If the selection queries for the page’s picks should also incorporate the Database Optimization Hint, then enable the “Use DB Hint on Page’s Pick(s)” option for the page entry. There are also special rules for custom pick pages, and they are described in the "Exceptional Setup for Custom Pick Pages" topic.

  4. When this configuration is enabled, the application ensures that selection queries retrieve only the records needed for the current virtual result window. When the user navigates to a different window of records (for example, by selecting Next), the application reissues the query to retrieve the next appropriate set of records.

Note that changes on Page Preferences will not take effect until the application server is restarted.

In addition to the previous steps there are other levels of control for incorporating the Database Optimization Hint on pages that enable virtual result sets. These levels are the application level and the record-source and pick level, and they are described in the following topics.