Because the CONNX ODBC driver uses the CONNX Data Dictionary (CDD), there are functions that can be used to enhance performance.
The CDD utilizes keys and key segments that enable the ODBC driver to perform SQL optimization automatically. During a query, the driver uses the key information to access the requested data. This feature dramatically reduces the need for sequential reads of files.
The advanced optimization feature driver also enables the use of ranges during a keyed lookup, promoting faster retrieval of information.
The CDD and the ODBC driver also support the use of segmented keys and perform rapid keyed retrievals, requiring only part of a key. Segmented keys are an important element in many business applications. CONNX automatically utilizes a segmented key if the leftmost field in the key is included.
