The following rules apply when determining what can be delegated to a data provider:
- OFFSET can be delegated to a data source provider if the data provider supports it.
- OFFSET can be delegated if the entire query can be delegated.
OFFSET allows a block of rows to be returned from a query beginning at a certain row. This is typically used with LIMIT, which determines how many rows to return.
For more information on OFFSET, see the Limit and Offset in the MapInfo SQL Reference.