Indexing Archives - ITFROMZERO - Share tobe shared!

Optimizing MySQL Queries with Covering Indexes: The Secret to Eliminating Table Lookups

By IT From Zero October 18, 2026

Table Lookups are the primary cause of I/O bottlenecks on large datasets, even when queries use an index. Master Covering Indexes and Deferred Joins to slash query latency from seconds down to milliseconds.

MySQL

A Guide to Using Multi-Valued Indexes in MySQL 8: Optimizing JSON Array Queries

By IT From Zero October 17, 2026

Real-world experience optimizing JSON array queries in MySQL 8 using Multi-Valued Indexes, slashing query times from 1.8s down to 2ms across tables with over 10 million rows.

Database

PostgreSQL Optimization: Using Partial and Covering Indexes to Reduce Storage by 90% and Speed Up Queries

By IT From Zero August 16, 2026

Don't let indexes slow down your system. Discover how to combine Partial and Covering Indexes in PostgreSQL to optimize performance and save storage space effectively.