Indexing & Query Optimization
Deep dive into database indexing mechanisms — covering disk I/O, B-Trees, hash indexes, composite index design, geospatial indexing, inverted indexes, EXPLAIN analysis, and Spring/JPA performance.
4 docs tagged with "indexing"
View all tagsMySQL Indexing Vượt Qua Dấu Bằng: ORDER BY, Range Scans, ICP & Deferred Joins
Chi tiết cơ chế đánh index MySQL nâng cao: phân biệt Seek vs Filter, quy tắc Leftmost Prefix, ESR rule, Index Condition Pushdown (ICP), Skip Scan, và kỹ thuật Deferred Join tăng tốc 148 lần.
Online DDL: Adding Indexes Safely in Production — ALGORITHM Matrix, Row Log & gh-ost vs pt-osc
Online Schema Change mechanics in MySQL and PostgreSQL: why staging finishes in 40s while production exhausts connection pools, ALGORITHM & LOCK matrix, innodb_online_alter_log_max_size overflow, gh-ost vs pt-osc, and PostgreSQL's INVALID index trap.
PostgreSQL BRIN Index (Block Range Index): 99% Smaller Than B-Tree
Comprehensive guide to PostgreSQL BRIN Index (Block Range Index) — mechanics, 99% RAM and disk space savings vs B-Tree, physical correlation pre-requisite, pages_per_range tuning, and Spring Data JPA integration.