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