What indices do you have? What does explain say?
Richard Reina wrote:
Anyone know why this query takes so long?
SELECT SUM(l.cost+l.fscc) FROM orders o, acctg.invoice i
LEFT JOIN acctg.payable p
ON (o.ORD_NO=p.ORD_NO)
WHERE p.ORD_NO IS NULL
AND i.ORD_NO=o.ORD_NO;
Is there something I can do to speed it up?
Thanks,
Richard
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]