For some large databases, the API function SQLTables(), which is called to get a list of the tables and information about them, sometimes takes a long time to execute. If you are experiencing such problems, you can instruct the interface to build a test SQL query and use the API function call SQLNumResultCols() to determine if the table exists. This may improve performance for large databases.
To turn on this new functionality, set the A_ODBC_USE_SQLTABLES configuration variable to FALSE.
The default value of this variable is TRUE, which means the interface will use the SQLTables() API function.