Write better distributed queries for Informix data servers

A guide to improving query performance

From the developerWorks archives

Evan Lee

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=218940
ArticleTitle=Write better distributed queries for Informix data servers
publish-date=05102007