All Forums Connectivity
jkoskela 1 post Joined 04/13
22 Jan 2015
Teradata ODBC driver 14

The Teradata ODBC driver v14 does not seem to conform to the specs. When running SQLStatistics with SQL_QUICK, the call does lots of locking and count(*) operations. The manual says that SQL_QUICK should prevent this behavior.

Tags:
vhari 111 posts Joined 12/08
22 Jan 2015

ODBC Driver does count(*) on small tables with cardinality <1000 to provide most accurate results.  If you think this behavior is slowing down application, please open an incident with Teradata Customer Services, so that the problem can be understood more in-detail and a solution be provided.

You must sign in to leave a comment.