The Vertica Query Optimizer: The case for specialized query optimizers
Nga Tran, Andrew Lamb, Lakshmikant Shrinivas, Sreenath Bodagala, Jaimin Dave · 2014
The Vertica SQL Query Optimizer was written from the ground up for the Vertica Analytic Database. Its design and the tradeoffs we encountered during its implementation argue that the full power of novel database systems can only be realized with a carefully crafted custom Query Optimizer written specifically for the system in which it operates.