Query Optimisation

A poorly designed query will not run efficiently. Now to most people that is obvious, but knowing there is a problem is not the same a knowing how to solve it. The following sections aim to explain how to construct queries so that they run more efficiently.

The latest Informix query optimiser is arguable the best of all the various vendors offerings. It is rare that the optimiser gets it wrong and in most cases it will do better than you.