Indexes - Getting Started With SQL for Application Developers

Description

This is a lecture from the Cockroach University course “Getting Started with SQL for Developers”. In this lecture, we'll learn about secondary indexes in CockroachDB. We'll look at how you know when an index is needed, how to create the index, and what benefits it might give you. We'll also cover compound indexes and how they are different from a single-column index. Learn more about CockroachDB by signing up for free training at Cockroach University: https://university.cockroachlabs.com/ 0:00 What is an Index? 1:00 Primary Indexes 1:55 Secondary Indexes 2:42 Creating Indexes 3:03 Composite Indexes 4:17 Table Scans 5:07 When To Index