Home / Companies / Yugabyte / Blog / Post Details
Content Deep Dive

YugabyteDB 1.1 New Feature: Speeding Up Queries with Secondary Indexes

Blog post from Yugabyte

Post Details
Company
Date Published
Author
Karthik Ranganathan
Word Count
1,025
Language
English
Hacker News Points
-
Summary

In this latest release of 1.1, YugabyteDB introduces secondary indexes that can be used to speed up queries and enforce uniqueness of column values. Secondary indexes are fully decentralized with no single point of failure, making the cluster resilient to various faults. They also provide linear scalability, ACID compliance, high performance, and support for multiple indexes per table. The data for each secondary index is an internal table that is sharded into tablets, internally replicated, and distributed across nodes much like user tables. This allows for efficient point-queries when looking up by the index columns, and additional columns can be included to further increase performance.