Abstract
When performing the join operation in relational databases, one problem involves finding the optimal page access sequence such that the number of page re-accesses is minimized, given a fixed buffer size. This paper presents a new heuristic for this problem (known as OPAS2) that generally outperforms existing heuristics.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have