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

Posted in 1996

Roland Mller — Wed, 10 Jan 1996 13:57:07 +0000 — source: Informix-list mailing list archive (1991-1998)

Hi Melvin, In your query you have the following condition: AND (((FocGenerator.DateTimeSt >= '95-12-27 13:12:56.000')M AND (FocGenerator.DateTimeSt <= '95-12-28 13:12:56.000'))M OR ((FocMailer.timestamp >= '95-12-27 13:12:56.000')M AND (FocMailer.timestamp <= '95-12-28 13:12:56.000')))M 1. I'd replace this part with: (FocGenerator.DateTimeSt BETWEEN '....' AND '...')AND (FocMailer.timestamp BETWEEN '....' AND '...') 2. Clearly separating between primary and foreign keys could be a help, too. I'm not sure if that will do, just my thoughts. Sincerely, Roland