Re: Informix query optimizer info please

In <28chlb$2gs@yeshua.marcam.com> ryan@opl.com (Bill Ryan) writes: >I am looking for detailed information on how the Informix query >optimizer operates (i.e. makes its decisions, what it looks for, >good tips on how to formulate tricky queries, etc.) I have a >reasonable amount of experience in the land of Sybase, but I'm >new to Informix. After I worked with Sybase for awhile, I learned >about the guts of the optimizer and it helped me tremendously. Wish >I had known the details earlier. >So, since I'm new to Informix, I'd like to start by learning about >its optimizer. Are there any articles, books, ftp sites, etc. that >would give me some insights? The only source I can remember seeing is Informix Training Module #1066 - "The Informix Cost-Based Optimizer". I believe this is part of the "Managing and Optimizing Informix Databases" course (3 days). As it's Informix copyright I guess I can't post it to the net! >Any and all tips would be greatly appreciated! Thanks! >(BTW, I'm using ver 5.0 on a unix server and PC/DOS version 4.1 to >access the server) graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.