Using Catalog Functions Because catalog functions, such as those listed here, are slow compared to other ODBC functions, their frequent use can impair system performance: • SQLColumns • SQLColumnPrivileges • SQLForeignKeys • SQLGetTypeInfo • SQLProcedures • SQLProcedureColumns • SQLSpecialColumns • SQLStatistics • SQLTables SQLGetTypeInfo is included in this list of expensive ODBC functions because many drivers must query the server to obtain accurate information about which types are supported (for example, to find dynamic types such as user defined types). Caching Information to Minimize the Use of Catalog Functions Avoiding Search Patterns Using a Dummy Query to Determine Table Characteristics