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