Initialize Fetch Size With Default Fetch Size

This Optional Feature, when enabled, will increase the default query fetch size from 10 to 100 records in order to reduce database round trips on large queries.

This feature provides improved performance.

Steps to Enable

If you need to change the Opt In state for this feature:

• Go to the Optional Feature UI - Configuration and Administration > Property Management > Optional Features.
  • NOTE: Only the DBA.ADMIN user can access and use the Optional Features page.

• Select the Initialize Fetch Size With Default Fetch Size feature

• Run the desired Action for the feature - Opt In or Opt Out.