Tagged articles

Index Covering

2 articles · Page 1 of 1

Mar 29, 2023 · Databases

How Index Covering and Avoiding Table Lookups Boost MySQL Query Performance

This article explains MySQL index covering and how avoiding table lookups (back‑to‑table) can reduce retrieval steps, improve query performance, and provides practical examples, execution‑plan analysis, and optimization tips for large tables in production.

Index CoveringPerformance OptimizationSQL

0 likes · 9 min read

How Index Covering and Avoiding Table Lookups Boost MySQL Query Performance

Java Interview Crash Guide

Jan 4, 2021 · Databases

Understanding B‑Tree Indexes: Clustered vs Non‑Clustered in Databases

This article explains the fundamentals of database indexing, detailing B‑Tree structures, the differences between clustered and non‑clustered indexes, their storage formats, and how they affect query, insert, and delete operations, including the concept of index covering.

B+TreeClustered IndexIndex Covering

0 likes · 15 min read

Understanding B‑Tree Indexes: Clustered vs Non‑Clustered in Databases