Previous Topic: Other OptionsNext Topic: Setting System Default Data Source Options


Performance Considerations for ODBC Options

The following ODBC options can affect the performance of the ODBC driver:

Cache SQL Tables

Reduces the time it takes to retrieve a list of tables, but does not always provide the most current view of existing tables.

Enable Ensure

Prevents the SQLStatistics function from issuing commands to update table statistics when disabled.

Use Accessible Tables View

Specifies the name of a view, so that only a list of the tables of interest to the end user is returned.

Note: For more information about the various ODBC functions mentioned in the previous descriptions, see Microsoft's documentation for ODBC software.