MySQL: Composite indexes in 5 minutes
How MySQL composite index column order affects query plans, range scans, and date filtering, with EXPLAIN examples and a date-column alternative.
Read the postTag: mysql
Posts tagged mysql from Setfive.
From the archive
3 posts
SQL: 5 Tips and tricks to impress your DBA friends
Five MySQL techniques for custom sorting, filtering LEFT JOINs, reusing aggregate variables, generating ranked columns, and selecting maximum rows per group.
Read the postMySQL and System Time
How system clock skew and time zones can affect MySQL date queries, and why changing the server time zone may require a full MySQL restart.
Read the post