Optimizing INFORMIX Applications

Optimizing Informix Applications is a comprehensive guide to improving the performance of database applications built on the Informix-SE, Informix-OnLine, and Informix-OnLine DSA engines. This book is an essential resource for developers and database administrators seeking to improve productivity and system quality. Among the topics covered are: Planning strategies that lead to more efficient databases; setting up an optimization test environment; indexing approaches that offer significantly improved performance; making the best use of the Informix optimizer; refining your SQL statements for more efficient execution; developing and maintaining efficient application code; tuning the Informix database engines; and taking advantage of data fragmentation and parallel processing. Optimizing Informix Applications contains numerous examples, including source code, database layouts, and hardware configurations. A chapter of case studies illustrates the optimization challenges Informix developers encounter most often, and the best solutions. If you design, develop, or administer Informix applications, this book brings together a world of information for making them faster, more reliable, and more cost-effective.

Developers and administrators can use this book to improve Informix application and systems performance, thereby increasing productivity and system quality. It shows how to set up an optimization text environment, presents indexing strategies, and shows how to use the Informix optimizer effectively.