full table scan for an OR in a WHERE statement...

Using IN() clause resulting in Filesort...

Optimize Query creating indexes to remove using temporary and using filesort from query plan...

Store XML explain plan in PostgreSQL database...

MySQL: random effect on ANALYZE TABLE...

MySQL query ignores index for a where clause...

Understanding Rails / PG Explain...

MySQL has indexed tables and EXPLAIN looks good, but still not using index...

MySql Explain ignoring the unique index in a particular query...

mysql - OR operator not using index...

Indexes not being shown as possible keys...

MySQL EXPLAIN statement shows ALL on type...

Understanding the output of an EXPLAIN statement (MySQL)...

MySQL EXPLAIN automatic analyzing...

MYSQL query EXPLAIN SELECT...

MySQL. Creating an index for "OR" queries...

There is no possible_keys available, but there exists keys in the where clause...

How to determine what is more effective: DISTINCT or WHERE EXISTS?...

indexed query, but still searching every row...

Efficiency of multicolumn indexes in MySQL...

joining table in mysql not using index properly?...

Mysql Order by clause using "FileSort"...

Mysql query optimisation, EXPLAIN and slow execution...

MySQL: 'EXPLAIN' showing different explanations for similar queries...

Optimise query using filesort and temporary...

Slow query grouping on blob column...

mysql foreign key does not work...

Judging Length of SQL Query based on Explain...

SELECT statement not using possible_keys...

mysql using temporary table with subqueries, but not group by and order by...