top-k
Short Description
The top-k node is used to sort data and return a limited set of rows.
Detailed Description​
The top-k node is used to sort data and return a limited set of rows. This is seen in LIMIT and ORDER BY operations.
It it NOT recommended to use LIMIT/OFFSET for paginating result sets, for this, use keyset pagination instead
Additional Links​
- CockroachDB Blog - SQL Performance Best Practices
- CockroachDB Docs - Limit Query Results
- CockroachDB Docs - Pagination
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.