skills.rest
SolidLao
SolidLaoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

indexing

Guide storage index selection and implementation for GenDB query performance.

71|8|Updated Feb 8, 2026
Search Tags:#query optimization#indexing#data structures#performance tuning#genDB#storage design
One-click install
npx skills add https://github.com/SolidLao/GenDB --skill indexing-solidlao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: indexing
Source: https://github.com/SolidLao/GenDB/tree/main/.claude/skills/indexing
Command: npx skills add https://github.com/SolidLao/GenDB --skill indexing-solidlao

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps optimize GenDB query performance by guiding the selection, design, and implementation of appropriate storage structures and indexes, reducing query execution time and resource consumption.

Core Features & Use Cases

  • Index Type Selection: Provides guidance on choosing the best index (Hash, Zone Map, Bloom Filter) based on query patterns and column characteristics.
  • Index Implementation Details: Offers specific implementation guidelines for Zone Maps, Hash Indexes, and Bloom Filters, including format, skip logic, and construction strategies.
  • Use Case: When planning a query that involves range filters on a column, this Skill advises on using Zone Maps for efficient block skipping, or a Sorted Index if the column is not naturally clustered.

Quick Start

Use the indexing skill to understand how to implement zone maps for range filters.

Frequently Asked Questions about indexing

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize GenDB query performance with indexes?▼

To optimize GenDB query performance, select appropriate storage indexes based on query patterns, such as zone maps for range filters or hash indexes for equality lookups, to reduce execution time and resource consumption.

When should I use zone maps versus sorted indexes for range filters?▼

Use zone maps for range filters when a column is naturally clustered to enable efficient block skipping. If the column data is not naturally clustered, a sorted index is advised to optimize the range query performance.

How does a bloom filter work for query existence checks?▼

A bloom filter provides an efficient data structure for existence checks by testing whether an element is definitely not in a set, allowing the query engine to skip unnecessary block probes and improve execution speed.

What is the best index for equality lookups and joins in GenDB?▼

Hash indexes are the best index for equality lookups and joins in GenDB, utilizing hash table structures to provide fast direct access to matching records without scanning the entire dataset.

Does GenDB indexing require specific data distributions to be effective?▼

Yes, index effectiveness depends on data distributions and query patterns. The implementation details cover construction, probe logic, and effectiveness criteria to ensure the chosen index optimizes storage and retrieval for specific data shapes.

Related Skills

Explore More Software Engineering Skills→
w95w95
145

data-exploration

Profile datasets to assess structure, quality, and column patterns.

Community
Intermediate
SolidLaoSolidLao
71

data-structures

Select hash tables, bloom filters, or sorted arrays for database query operations.

Community
Intermediate
ryukyagamilightryukyagamilight
1

sql-optimization

Analyze execution plans and optimize SQL queries for MySQL and PostgreSQL.

Community
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-index-analysis

Analyze ClickHouse index usage against query patterns to reduce data scanned.

Official
Advanced