Write better distributed queries for Informix data servers
A guide to improving query performance
From the developerWorks archives
Date archived: January 13, 2017 | First published: May 10, 2007
Learn how to optimize your queries for the best possible performance when accessing multiple Informix servers. In this article, you'll learn to read the optimizer's Explain output and understand how Informix processes distributed queries. You'll learn to recognize inefficiencies in a query execution plan and write queries that avoid these pitfalls.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.