Skip to main content

Cockroach University: Introduction to Secondary Indexes

In this Cockroach University lesson titled “Introduction to Secondary Indexes”, we’ll talk about how to create secondary indexes, how to find them, and how to understand how they are being used. Then we’ll discuss how these indexes relate to the underlying key-value store. In this lesson, you will learn to: •Define a table scan •Create an index •Find all indexes on a table •Read a logical EXPLAIN plan •Trace the lookups performed when using a secondary index to find a table row Learn more about CockroachDB by signing up for free training at Cockroach University: https://university.cockroachlabs.com/ --------------------------------------------------------------------------------------------------------------------------- Reference Links •Indexes: https://www.cockroachlabs.com/docs/stable/indexes.html (CockroachDB Docs) •SQL Tuning with Explain: https://www.cockroachlabs.com/docs/v19.2/sql-tuning-with-explain.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