Compiling SQL into System/370 Machine Language
Abstract

To improve performance of repetitive transactions in System R, IBM's Raymond Lorie devised a scheme to create, save, and reuse a generalized access plan that could be instantiated with specific values. The author recounts his role in compiling such generalized access plans into machine code for even better performance.


pdf