Developers and administrators can use this book to improve Informix application and systems performance, thereby increasing productivity and system quality. Shows how to set up an optimization test environment, presents indexing strategies, and shows how to use the Informix optimizer effectively. Presents tips for better SQL, 4GL and ESQL/C performance. Offers detailed tips for Informix OnLine SE, Informix OnLine and Informix OnLine DSA engines. Presents a chapter of detailed case studies.