
Chapter 11. Performance tuning of DB2 UDB Workgroup Server 323
used, it may be useful to place this table in a tablespace with its own buffer pool
to make the data memory resident.
With DMS table spaces, the table data, indexes, and long data can be placed in
separate table spaces. This makes it possible to have a separate buffer pool for
an index to keep the index memory resident and improve the performance.
By default the prefetcher reads contiguous pages from disk and may write them
into non-contiguous pages in the buffer pool. With DB2 V8, you can configure a
block-based buffer pool. When this feature is activated (during creation of a