Prefetch delay (-prefetchDelay)

Use Prefetch delay (-prefetchDelay) to enable a delay when sending the first network message for queries with prefetch capabilities.

Operating system and syntax UNIX / Windows -prefetchDelay
Use with Maximum value Minimum value Single-user default Multi-user default
Database Server 1

When you specify Prefetch delay, the Prefetch Num Recs (-prefetchNumRecs) and Prefetch factor (-prefetchFactor) parameters determine the duration of the delay. Prefetch delay is on by default.