Hello, I am using a Data Virtualization tool, Teiid Designer, to create a teradata "source model" which is fetching metadata for each table I select for the model. This connectivity is supported using JDBC connection URL "jdbc:teradata://database/tmode=ANSI". I have tried the Teradata 13 and 15 JDBC drivers with associated jar files and registered class: terajdbc4.jar, tdgssconfig.jar, com.teradata.jdbc.TeraDriver.
The issue we are having is that we are experiencing a >30 sec wait/processing time between each selection and we have many many selections potentially. This step should only fetch table metadata, not running table data query. For db2 jdbc connection and import of table metadata, there is zero wait for us so I am wondering if anyone has any ideas on how to tune the teradata jdbc connection so the process is faster.
Any help would be appreciated.
Please review the Teradata JDBC Driver User Guide section "DatabaseMetaData Performance". Slow performance of queries against Data Dictionary views can sometimes be due to a lack of accurate, up-to-date statistics.