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