Blog22.9K views4,494 votes0 replies2,447 following
Firebird pagination with FIRST and SKIP: stable pages and the offset cost
Use Firebird's FIRST and SKIP clauses to return bounded result-set windows, but always pair them with ORDER BY and understand the cost of large offsets.