The c-treeACE SQL Optimizer underwent extensive testing and analysis with the result being dramatically improved performance in many complex queries. A brief list of the major improvements are listed here.
Improved Performance of MAX and MIN Operators
Improved Performance of the BETWEEN Operator
Improved Performance with Particular Predicate Restrictions
