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: * This is a preview from our upcoming course, "Composite Indexes and Index Prefixes". ---------- Reference Links •Computed Columns: (CockroachDB Docs) ---------- Careers: CockroachCloud: Blog: Docs: Community Slack: Twitter: