Re: Optimizing queries info

Greg Sheppard (imop%uspfo.wa-ngnet.army.mil@wa-ngnet.army.mil) 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. You will also find a Tutorial book on INFORMIX - Guide to SQL v4.10, published by Informix, very useful. Especially the Chapter 4 on Optimizing Your Queries. Regards, - Rajhans G Tawde. -------------------------------------------------------------------- Rajhans G Tawde Internet: raj@shack.csci.csc.com CSC Intelicom Voice : (303) 643 1476 116 Inverness Drive East Fax : (303) 792 0319 Englewood, CO 80112 Standard Disclaimers Apply. --------------------------------------------------------------------