text prefetch size

text prefetch size limits the number of pages of text, unitext, and image data that can be prefetched into an existing buffer pool.

Summary Information

Default value

16

Valid values

0–65535

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration Group

Network Communications

SAP ASE prefetches only text, unitext, and image data that was created with SAP ASE 12.x or was upgraded using dbcc rebuild_text.