Homec4science

Use (a = ? AND b = ?) instead of (a, b) IN (?, ?)

Authored by Jakub Vrana <jakub@vrana.cz> on Apr 6 2013, 08:02.

Description

Use (a = ? AND b = ?) instead of (a, b) IN (?, ?)

Summary: MySQL is not able to use indexes with searching for tuples.

Test Plan:
Explained the query before and after, saw key_len 16 instead of 8.
Also saw time 0.0 s instead of 2.9 s (but that was probably caused by warming up).

Reviewers: epriestley

Reviewed By: epriestley

CC: aran, Korvin

Differential Revision: https://secure.phabricator.com/D5580

Details

Committed
Jakub Vrana <jakub@vrana.cz>Apr 6 2013, 08:02
Pushed
aubortJan 31 2017, 17:16
Parents
rPH8716b295e7bc: Specify `phd.start-taskmasters` in documentation
Branches
Unknown
Tags
Unknown

Event Timeline

Jakub Vrana <jakub@vrana.cz> committed rPH3391e3d34b10: Use (a = ? AND b = ?) instead of (a, b) IN (?, ?) (authored by Jakub Vrana <jakub@vrana.cz>).Apr 6 2013, 08:02