When I am querying a particular table, Teradata SQL assistant is going to not responding state . Table record count is 19K
Table structure :
CREATE SET TABLE <TABLENAME> ,NO FALLBACK ,
Please provide the version of SQLA. Did you try querying few records like top 10 or sample 10?
SQLA version is 13.11
TD database version is 14.10
I tried with Sample 10 , still its going to Not responding state .
SQLA 13.11 seems very old now. One of the reasons might be memory error. Try upgrate SQLA to new version.
Also, check SQLA error log, you might get some idea why it goes into not responding state.