> ## Documentation Index
> Fetch the complete documentation index at: https://docs.paradedb.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Pagination

<Danger>
  **Legacy Docs:** This page describes our legacy API. It will be deprecated in
  a future version. Please use the [v2 API](/) where possible.
</Danger>

## Limit

Passing `LIMIT` into a query can significantly improve query times for queries that return large result sets.

```sql theme={null}
SELECT description, rating, category
FROM mock_items
WHERE description @@@ 'shoes'
LIMIT 5;
```

## Offset

`OFFSET` can be used with `LIMIT` to paginate through results.

```sql theme={null}
SELECT description, rating, category
FROM mock_items
WHERE description @@@ 'shoes'
LIMIT 1 OFFSET 2;
```