Hello!
We had an issue with IN clause, which we thought fixed on a general case,
but if you have a complex condition it may still manifest.
Does it change if you just use (product_name = 'Product1' OR product_name =
'Product2')?
Regards,
--
Ilya Kasnacheev
ср, 10 июн. 2020 г. в 13:54, njcstre
Hi,
I am seeing poor performance on queries which use IN in the WHERE clause
with multiple items supplied. I have searched for issues related to this and
I have seen replies suggesting that when you use IN, that indexes are not
used, but I guess this must have been fixed because I do see indexes b