Query Optimizer

Query Plan find all - NP

The order of operator

Pull at every node Break into SELECT BLOCK

cross product to theta or other types of join on some predicate

NoSQL keep pulling tuples up the tree