To incorporate the Database Optimization Hint on a page that enables virtual result sets, follow these steps:
Add the page that will incorporate the Database Optimization Hint to Page Preferences (PGPREF).
Enable the “Use DB Optimization Hint” option for the page entry.
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.
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.