Optimizing queries info

Greg Shepard wrote > We've recently written a couple of reports which take >FOREVER (hours) to run...and are getting very interested in streamlineing >our queries for speed and efficiency. Is there a book or useful info on >how best to get the quickest results with queries using iSQL? Or is it >just a matter, as we suspect here, of slugging our way through it, trying >this and trying that until we get what we're after? > Any help and/or pointers in the direction of some useful info would >be muchly appreciated. I suggest that Jonathan Leffler's book - "Using Informix-Sql" [ISBN 0-201-51240-8] is *required* reading if you want to do anything with isql. I'd also suggest you post some of your queries on the net and ask for suggestions for improvements. There are some really clever solutions out there only waiting for a suitable problem .. ** Opinions expressed are my own and not necessarily those of my employer ========================================================================= Barry Toomey Phone +353-1-2822333 AT&T Network Systems Ireland Fax +353-1-2822864 Corke Abbey Avenue, email: bt@irl3b2c.att.comm Bray, uunet: att!irl3b2c!bt Co. Dublin Ireland =========================================================================