Skip to main content

How ORDER BY statements work

In this Cockroach University lesson titled “How ORDER BY statements work”, you will learn how to receive ordered query results, how indexes assist with ordering, and how to reverse sort query results. In this lesson, you will learn: • 00:00 ORDER BY statements in CockroachDB •0:34 How “ORDER BY” Affects Your Queries •1:17 How Indexes are Used to Avoid Sorting Query Results •1:47 How “ORDER BY” Takes Advantage of Index Efficiency * This video is a preview from our upcoming course, "Composite Indexes and Index Prefixes". Learn more about CockroachDB by signing up for free training at Cockroach University: https://university.cockroachlabs.com/ ---------- Reference Links •Ordering Query Results: https://www.cockroachlabs.com/docs/v20.1/query-order.html (CockroachDB Docs) ---------- Careers: https://www.cockroachlabs.com/careers CockroachCloud: https://www.cockroachlabs.com/product/cockroachcloud/ Blog: https://www.cockroachlabs.com/blog/ Docs: https://www.cockroachlabs.com/docs/stable/ Community Slack: https://cockroa.ch/Welcome-to-Slack Twitter: https://twitter.com/CockroachDB