ποΈ Indexes
Indexes can help quickly locate data that matches certain query conditions. To be specific, when an index is built on a table based on some of the table's columns, queries that use these columns as query conditions require scanning only on portions of the table data in order to locate the data that meet the conditions. As such, query efficiency is improved. StarRocks provides a variety of index types, mainly divided into the following two categories:
ποΈ Prefix indexes
Description
ποΈ Bitmap indexes
This topic describes how to create and manage a bitmap index, along with usage cases.
ποΈ Bloom filter indexes
This topic describes how to create and modify bloom filter indexes, along with how they works.