Loading...
Loading...
Found 15 Skills
Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
Optimizes ClickHouse queries for speed and efficiency. Helps with primary key design, sparse indexes, data skipping indexes (minmax, set, bloom filter, ngrambf_v1), partitioning strategies, projections, PREWHERE optimization, approximate functions, and query profiling with EXPLAIN. Use when writing ClickHouse queries, designing table schemas, analyzing slow queries, or implementing analytical aggregations. Works with columnar OLAP workloads.
MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.