SELECT *
FROM products
WHERE id IN (12, 13, 2010, 1987);
is faster than
SELECT *
FROM products
WHERE id = 12 OR id = 13 OR id = 2010 OR id = 1987;
Title:
mysql in vs or performance
Description:
SELECT * FROM products WHERE id IN (12, 13, 2010, 1987); is faster than SELECT * FROM products WHERE id = 12 OR id = 13 OR id = 201...
...
Rating:
4