Optimizing Data Access

Efficient queries and updates are the product of more than just well‑constructed SQL statements—they are the result of a well‑planned repository, sufficient and well‑managed resources, in addition to SQL statements that take advantage of xfODBC’s ability to optimize SQL statement processing.

The sections below introduce some of the issues that affect performance—particularly those that relate to xfODBC. You should also refer to a general SQL reference work, Appendix B: SQL Support, the documentation for your ODBC‑enabled application, and Improving performance with system catalog caching.

Optimizing with keys

Creating efficient SQL statements

Using an ODBC‑enabled application

Tracking performance