我有一个sql查询从4个表中获取数据。但下面的查询只获取1个结果，超过10000次，而且显示时间很长。有人能帮我优化这个查询吗。

SELECT A0.* 
FROM Part A0, UnitValue A1, StringValue A2, PARTMASTER A3 
WHERE (A0.ida3reference=A3.id and A3.PartNumber LIKE 'RT-3294%') 
AND (((A1.idA6 = 3853762) AND (A1.value = 0.037099) 
AND (A1.idA4 = A0.id)) OR ((A2.idA6 = 19907282) AND (A2.value = '22') 
AND (A2.idA4 = A0.id)))