ποΈ Indexes
Overview of index types in StarRocks: built-in indexes (Prefix, Ordinal, ZoneMap) automatically created by the system, and user-created indexes (Bitmap, Bloom filter, Inverted, N-gram, Vector).
ποΈ Prefix indexes
How Prefix indexes work in StarRocks as automatically generated sort-key indexes that accelerate range queries and equality filters on sort key columns.
ποΈ Bitmap indexes
How to create and manage bitmap indexes in StarRocks to accelerate equality and range queries on low-cardinality columns using bitmap data structures.
ποΈ Bloom filter indexes
How to create and manage Bloom filter indexes in StarRocks to skip data files that don't contain queried values, improving query performance on high-cardinality columns like IDs.
ποΈ N-gram bloom filter index
How to use N-gram Bloom filter indexes in StarRocks to accelerate LIKE queries and ngram_search functions by tokenizing strings into N-character substrings before indexing.
ποΈ Full-text inverted index
How to create and use full-text inverted indexes in StarRocks (from v3.3) to accelerate text keyword searches and LIKE queries by indexing individual words.
ποΈ Vector Index
How to create and use vector indexes (IVFPQ, HNSW) in StarRocks for approximate nearest neighbor search (ANNS) on high-dimensional vector data, available in shared-nothing clusters from v3.4.
