The Query Optimizer in Tandem's new ServerWare SQL Product
Pedro Celis · Very Large Data Bases · 1996
A brief overview of Nonstop SQL product will be followed by a description of what is different in ServerWare SQL. The current Nonstop SQL optimizer uses a traditional bottom-up dynamic programming optimizer. This is the same type of optimization algorithm used in System R and many commercial products. The optimizer in the new product is a top-down branch and bound ruledriven cost based optimizer similar to work done on the Volcano optimizer.