Re: 3-Way Join Running Sloowww with the Query/Schema

Melvin, At a a stab I'd suggest that you select into temp from focgenerator and focmailer and then use the results for your three-way join. The only thing I can think of that might cause the problem is and OR in the where clause which spans tables. Otherwise, I'm stumped! HTH. >I have a query that is returning 1791 rows which consists of a 3-way >join. I have attach a copy of the 3 tables with the query and a copy >of sqexplain.out. I have run the query on an HP h70-2 CPU 9.04 and >HP T500-2 CPU box from Dbaccess using Informix 7.11 UC1. The query >runs in 17 minutes on the H70 and 21 minutes on the T500. > >The tables are not that large and it seems like this query should run >a lot faster than it is, especially on a T500. > >Any suggestions would be appreciated from the Informix gurus out there >and thanks in advance for any response. Please email and post to the >newsgroup since others will probably be interested in the results. -- Cheers, Billy. ----------------------------------------------------------------------------- billy.wheeler@pixie.co.za +27 11 803 2151 p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324 informix developer at large (and i mean _large_) -----------------------------------------------------------------------------