Re: How could this SQL be optimized?

[Øystein Grøvlen]

Hi,

I do not think these statements are equivalent. Are you optimizing for speed or statement complexity? If the former, and assuming that ORDERID values are unique, I suggest the following:

SELECT ID,WAYBILL_NO,EXP_TYPE,PKG_QTY,EXPRESS_CONTENT_CODE,EFFECTIVE_TYPE_CODE
FROM T_EXP_OP
WHERE AUX_OP_CODE NOT IN ('NEW','UPDATE','DELETE') OR NOT ((OP_CODE IN (176, 162, 171, 131, 136) AND EXP_TYPE IN ('10', '20', '30')) OR (OP_CODE IN (191, 121) AND EXP_TYPE IN ('10', '20')) OR (OP_CODE IN (181, 111)AND EXP_TYPE = '10'));

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway