Specify the value for DDSTATS.

Data Type

string

Default Value

""

Remarks

When set to ON, the Teradata JDBC Driver's DatabaseMetaData methods execute an EXPLAIN command with DIAGNOSTIC HELPSTATS ON prior to executing each query against the Data Dictionary. If the Teradata Database recommends any COLLECT STATS commands, then the recommended commands are logged at the ERROR logging level. The recommended COLLECT STATS commands are NOT executed. The Teradata Database administrator must execute the COLLECT STATS commands separately. DDSTATS=ON will have a performance impact. DDSTATS=ON is a troubleshooting tool only, and is not recommended for normal production usage. When set to OFF (the default), the Teradata JDBC Driver's DatabaseMetaData methods do not execute EXPLAIN commands.