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.

compound indexindexingmysql

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+TreeDatabase PerformanceMongoDB

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.

Database PerformanceGeospatial IndexMongoDB

0 likes · 8 min read

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