Re: 3-Way Table Join....Running sloowwww, Any ideas?? - telnet.cap (0/1)

Melvin, The first thing you need to do is get rid of the Temp space. Building of temp space just kills ya on a query. Create an index on the fields you are ordering by. The index must be ordered on only one table ( and it must be the first table read) to get a direct read and it appears that you can do this if you change focgennerator.errortype to foxfaxccna.errortype and then create the index (errortype, ccna,icsc ) on table FoxFaxccna. Hope this helps. Is this a telesales database by any chance? hwill@ix.netcom.com