Database Version: Teradata 13.10.0609 13.10.06.09A
Provider Version: ODBC 14.00.00.04
CREATE TABLE MY_TABLE AS (
PRIMARY INDEX (COL1);
COLLECT STATISTICS MY_TABLE INDEX(COL1);
The table gets created, but collect statistics fails.
I have run the same process for months, but now I cannot collect statistics
No error message is generated.
After lots of trial and error, the solution was to uninstall and reinstall
Teradata SQL assistant. Do not know what went wrong, but everything
is back to normal, for now.
You can use DBQL to locate the error code and message (if the client was able to submit the SQL statement to the Teradata, which is hopefully true).
I am taking a join on a index column & its taking time to execute the following query
You need to show the ddl of the tables, the stats that are collected and the explain from the query to help determine why it is performing slowly.