Lazy evaluation might also help in cases where you can parallize some work. Even if you know you will need it, the fact that you can defer it can give you a num

Lazy evaluation might also help in cases where you can parallize some work. Even if you know you will need it, the fact that you can defer it can give you a number of optimization opportunities. Also, if others would like to learn more about the ORDER BY...LIMIT optimization, it's called a top-K sort.