Co-Clustering Relations
SELECT E.name, D.dname FROM Emp E, Dept D WHERE E.dno = D.dnum
Fast if employees are stored “with” their departments (co-clustered).
Co-clustering slower for file scans of each file.
Difficult implementation.
Provided in Oracle, other systems.