Using catalog functions
- Last Updated: October 7, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Aha! 8.0
- Amazon Redshift 8.0
- Apache Cassandra 8.0
- Apache Hive 8.0
- Apache Spark SQL 8.0
- Autonomous Rest Connector 8.0
- Cloudera Impala 7.1
- dBase 7.1
- + 24
Because catalog functions, such as those listed here, are slow compared to other ODBC
functions, their frequent use can impair system performance:
- SQLColumns
- SQLForeignKeys
- SQLGetTypeInfo
- 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).