Re: Optimizing queries info
Posted in 1994
}From: bt@irl3b2c.att.com }Date: Thu Dec 16 9:15:34 GMT 1993 }Subject: Optimizing queries info }X-Informix-List-Id: <list.3228> } }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? } }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. --------------------------------------------------------------------