Master MySQL Index Usage: When and How Indexes Improve Queries

This guide explains how MySQL decides whether to use an index for range queries, LIKE patterns, and ORDER BY operations, detailing key_len calculation, index key vs filter vs table filter concepts, and practical examples for BETWEEN and sorting optimization.

BETWEENOrder Byindex

0 likes · 10 min read

Master MySQL Index Usage: When and How Indexes Improve Queries

Qunar Tech Salon

Apr 8, 2015 · Databases

Understanding Date‑Range Queries in SQL: Between, Timestamp Precision and Code Readability

The article examines common pitfalls when retrieving a day's orders in MySQL, explains why using BETWEEN can be ambiguous, shows how timestamp precision and appending .999 affect results, and argues for clear, maintainable SQL and test‑code practices.

BETWEENJUnitcode-quality

0 likes · 8 min read

Understanding Date‑Range Queries in SQL: Between, Timestamp Precision and Code Readability