Skip to main content

How to build computed columns

In this Cockroach University lesson titled “How to build computed columns”, you will learn what a scalar expression is, how computed columns can be created from JSON, and indexing computed columns improves query efficiency. In this lesson, you will learn: • 00:00 What are computed columns • 00:29 Why a Computed Column is Useful • 1:10 How to Build a Computed Column • 1:47 How to Index a Computed Column Learn more about CockroachDB by signing up for free training at Cockroach University: https://university.cockroachlabs.com/ * This is a preview from our upcoming course, "Composite Indexes and Index Prefixes". ---------- Reference Links •Computed Columns: https://www.cockroachlabs.com/docs/v20.1/computed-columns.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