Hello there; I have the following mysql Select:
SELECT ndc, ln, fdb.rndc.gcn_seqno, rt FROM fdb.rndc INNER JOIN fdb.rgcnseq on fdb.rgcnseq.gcn_seqno=fdb.rndc.gcn_seqno LEFT JOIN fdb.rrouted ON fdb.rrouted.gcrt=fdb.rgcnseq.gcrt WHERE ln LIKE '%%%' GROUP BY gcn_seqno, ln ORDER BY rndc.ln LIMIT 50;
This select works only that it's very slow! I have tried to create ln and gcn_seqno indexes but it's still slow. Having said that, I'm wondering what I can do to speed it up...?
Happy Holidays Sincerely David
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
