Re: Query Optimization

[Bill Karwin]

Doh! I was scanning for instances of "masterquotes.dtEntered". Sorry about that.

Well, I would write the query as follows:

SELECT ...
FROM masterquotes AS m
JOIN carriersettlement AS cs ON m.webquotecontrol = cs.webquotecontrol
JOIN status AS s ON m.statusdi = s.statusdi
WHERE m.dtEntered LIKE '2006-04-26%'
AND m.statusedi NOT IN ('Pend-I', 'Memo', 'MEMO', 'NOT SRCS', 'NOT SRCS-I', 'PEND-I', 'Pend-A')

It should give equivalent results, and perhaps the optimizer can understand NOT IN and JOIN syntax more easily.

What version of MySQL are you using?

Regards,
Bill K.