5 years ago

Query syntax is limited. Queries are unlimited. Predicate pushdown, group by pushdown, offset pagination, keyset pagination, join optimization, search optimization...we've discussed it all. Still, it's important to understand the default, simple — albeit slow — execution flow of the query.