- **Description**: Restricts the number of rows returned.
- **Performance**: Efficiently restricts rows.
- **Factors**: Position of LIMIT in the plan.
- **Cost**: Cost of input plan.
- ![[ex_limit.svg|200x200]]
- **Operates on**: [[Result Set]]
- **Workloads**:
- [[LWLock]]
- [[BufferContent]]