这将解决您的性能问题:您应该创建一个新表(PRODUCT_INFO),并使外键指向产品主键。使用来自ATTRIBUTE_CODE和ATTRIBUTE_VALUE的各个值填充该表。
SELECT pa.code
FROM ParametrickeVyhladavanie pa
WHERE EXISTS
(
SELECT 1 FROM produkty p
JOIN
PRODUCT_INFO AS pi
ON p.ProId = pi.ProduktID
WHERE pi.ATTRIBUTE_CODE = pa.Code
AND pi.ATTRIBUTE_VALUE = pa.ValueCode
AND p.KATEGORIA IN ('Mobily'))
GROUP BY pa.code