Features of the OLE DB Provider
Because the CONNX OLE DB Provider 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 OLE DC Provider 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 OLE DB Provider 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.
The CONNX OLE DB Provider supports Unicode and ANSI data types