Vectorized Execution Engine

NuoDB’s SQL Engine is known as the Vectorized Execution Engine (VEE). A vectorized approach allows the engine to process batches of 32 rows (or a subset of columns from 32 rows) at a time, speeding up execution. 32 is the default vector size.

VEE features many enhancements over the now-obsolete Scalar Execution Engine (SEE), primarily in query compilation and optimization. Another improvement is that the explain plans for VEE are more concise making them easier to read and use.

Query Optimizer

The Query Optimizer evaluates multiple semantically equivalent plans and attempts to find the one which will execute in the fastest time using the least resources.