Re: SELECT Optimization (speeding up a SELECT)

[Ed Leafe]

On Dec 24, 2003, at 2:51 PM, David Kinyanjui wrote:

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...?
	Do you have indexes on fdb.rrouted.gcrt and fdb.rgcnseq.gcrt? Also, 
what's up with the LIKE expression? Are you trying to find a single 
percent sign?

     ___/
    /
   __/
  /
 ____/
 Ed Leafe
Linux Love:
unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]