Partial Indexes | Performance in CockroachDB

Description

Partial indexes allow you to specify a subset of rows and columns to add to an index. Partial indexes include the subset of rows in a table that evaluate to true on a boolean predicate expression (i.e., a WHERE filter) defined at index creation. Join our Technical Evangelist Rob Reid as he demonstrates how you can use partial indexes to optimize storage. Partial Indexes | Performance in CockroachDB 00:00 What are partial indexes? 00:28 Creating a demo environment: Customer transactions 01:21 Running without indexing 02:15 Running with a secondary index 02:30 Running with partial indexes 03:33 Querying non-index data 04:40 Why partial indexes are great for cluster performance #cockroachdb #distributedsql #indexing #databaseconcepts