Canonical paper on SQL query optimization. By Patricia Selinger. The dynamic programming algorithm for determining join order proposed in this paper still forms the basis for most of the query optimizers used in modern relational systems.