Showing entries 1 to 1
Displaying posts with tag: join strategy (reset)
Jul
27
2007
How to avoid an extra index scan in MySQL
Posted by Baron Schwartz (xaprb) on Fri 27 Jul 2007 12:07 UTC
Tags:

Is your MySQL server doing an extra index scan on queries that need to check a key for matches or NULL? It's easy for this to happen accidentally, but it's also easy to fix, especially in MySQL 5.0 and up. Here's how.

Showing entries 1 to 1