Tag
DuckDB's file_row_number option for paging through Parquet files is 2.53x faster than using LIMIT/OFFSET, as it leverages row group metadata to skip irrelevant blocks, but the benefit depends on having many row groups.
The article explains the undefined default ordering behavior in SQL queries without ORDER BY, using PostgreSQL examples to show how insertion order, updates, and deletions can change results, and warns against relying on default order for paging.