Quote:
|
Originally Posted by redwolf
Yes I'm talking about a table space that I have designated NUMBLOCKPAGES 75000. This is 50% of the total tablespace size. Are the 2 areas treated as separate entities ?
|
Block area of a block-based bufferpool is only used for sequential prefetch operations. Page area is used for other types of IO operations. In that sense you can say they are treated as separate entities. If too many pages that are to be read by a sequential prefetch are already in the page area, the block area will not be used.
By the way, it has little to do with large (or small) result sets, contrary to what
azs0309 is saying.