Re: Optimizing queries info

Posted in 1994

Gregory F. Hogg — Mon, 3 Jan 1994 17:18:16 GMT — source: Informix-list mailing list archive (1991-1998)

Greg, The best way to speed up queries is temp tables. If you use set explain on you might find informix is creating its own temp tablesbut not making good choices. You know you data better that the engine so you should be able to build better (smaller) temp tables. -- Greg Hogg voice : 410-679-1431 uucp : greg@halexvii.clark.net HOGG'S SOFTWARE fax : 410-679-1329 cis : 74176,1320