WebDocs Home | Show Navigation Hide Navigation

Optimizing Data Access

Efficient queries and updates are the product of more than just wellconstructed SQL statements—they are the result of a wellplanned repository, sufficient and wellmanaged 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 ODBCenabled application, and “Improving performance with system catalog caching”.

Optimizing with keys 102

Creating efficient SQL statements 109

Using an ODBCenabled application 1012

Tracking performance 1013