SQL Operations Guide

SETENV DH_DO_AHEAD

Disables 'FETCH AHEAD' logic. Fetch ahead logic normally provides database stability with only a small performance hit on fetches.

Example

SETENV DH_DO_AHEAD=N