Glossary

ORDER BY

The query requests sorted output, and no index provides the data in that order - **GROUP BY** — Aggregation may require a sort to group matching values together (although hash-based grouping can sometimes avoid this) - **DISTINCT** — Duplicate elimination may require sorting - **UNION** (not UNION A

Learn More

Related Terms