Re: Query using IN Clause slow

2020-06-10 Thread Ilya Kasnacheev
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

Query using IN Clause slow

2020-06-10 Thread njcstreet
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