Tagged articles

compound index

3 articles · Page 1 of 1

Mar 12, 2018 · Databases

How to Choose the Right Indexes for MySQL Query Optimization

This guide explains practical, rule‑based steps for creating effective compound indexes in MySQL, MariaDB, and PerconaDB, illustrates the process with a concrete query example, and warns against common indexing mistakes such as over‑indexing, OR conditions, and wrong column order.

IndexingMySQLcompound index

0 likes · 9 min read

How to Choose the Right Indexes for MySQL Query Optimization

360 Zhihui Cloud Developer

Nov 16, 2017 · Databases

Mastering MongoDB Indexes: B‑Tree, Selectivity, and Compound Index Strategies

This article explains MongoDB indexing fundamentals, covering B‑Tree structures, index selectivity, unique and compound indexes, practical code examples, and guidelines to optimize query performance and reduce I/O operations.

B+ TreeIndexingMongoDB

0 likes · 9 min read

Mastering MongoDB Indexes: B‑Tree, Selectivity, and Compound Index Strategies

360 Zhihui Cloud Developer

Sep 7, 2016 · Databases

MongoDB Indexing Best Practices: Real‑World Tips & Common Pitfalls

This article shares practical MongoDB indexing guidelines—including compound index rules, naming limits, cardinality considerations, TTL and geospatial indexes, lock behavior, and real‑world case studies—to help DBAs and developers design efficient, safe indexes for production workloads.

Geospatial IndexIndexingMongoDB

0 likes · 8 min read

MongoDB Indexing Best Practices: Real‑World Tips & Common Pitfalls