> For the complete documentation index, see [llms.txt](https://til.notdu.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://til.notdu.com/database/intro-to-database-systems/buffer-pool-and-memory-management/buffer-pool-bypass.md).

# 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