Debunking the Myth of Join Ordering: Toward Robust SQL Analytics

Junyi Zhao, Kai Su, Yifei Yang +3

Join order optimization is critical in achieving good query performance. Despite decades of research and practice, modern query optimizers could still generate inferior join plans…