In recent years, the technology of multi-core processor has been improving dramatically.
As the number of cores on a chip increases, the memory location relative to cores is beginning to vary the memory access time. In order to take full advantage of the hardware for DBMSs, it is important to clear how the various core-memory locations affect DBMS performance.
In this paper, we provide an experimental performance study of the core-memory location effects for different relational joins.
We observed that different join operations had different sensitivity to the core-memory locations.
Our discussion and insights are useful for DBMS performance optimization on multi-core computers.