Database, Data Engineering, Dbms, Data Modeling, Data Management.
03 Efficient pagination Imagine that you need to sort the data in a specific order and then retrieve record №90,001 to record №90,010. This means you have a large offset of 90,000. This is what we call a deep pagination query. Even though you only require a result set of 10 rows, the database