Buffer Pool Bypass

The sequential scan operator will not store fetched pages in the buffer pool to avoid overhead

  • Memory is local to running query

  • Works well if operator needs to read a large sequence of pages that are contiguous on disk

  • Can also be used for temporary data (sorting, joins).

Called "Light Scans" in Informix

Last updated