Local indexes

Local indexes are auxiliary structures stored together with table data and applied while reading from storage. Unlike global indexes, they do not materialize a separate index table and are not selected in queries with VIEW.

This section contains practical materials on local index types:

• Bloom skip indexes — Bloom indexes for accelerating selective queries by skipping data fragments.
• min_max index — min_max index that skips data fragments based on saved value ranges.