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 3 years ago
