Summary information |
|
|---|---|
Default value |
16 |
Valid values |
0–65535 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration Group |
Network Communications |
text prefetch size limits the number of pages of text, unitext, and image data that can be prefetched into an existing buffer pool. Adaptive Server prefetches only text, unitext, and image data that was created with Adaptive Server 12.x or was upgraded using dbcc rebuild_text.
