#DateForumTypeThreadPost
811 Sep 2015 @ 02:55 PDTGeneralTopicNeed help in pointing out the exact issue leading to high CPU usage to improve query performance. 2. We do an all-AMPs RETRIEVE step from TEST_DB.TEST_TABLE by way of an all-rows scan with no residual conditions into Spool 5 (all_amps) (compressed columns allowed), which is built locally o...
715 Jul 2014 @ 04:07 PDTGeneralReplyORDER BY cannot be used in sub queriesThanks for your help, Dieter! :)   Regards, Soumik
615 Jul 2014 @ 01:47 PDTGeneralReplyORDER BY cannot be used in sub queriesThanks Dieter!   Could you please help me the reason for failure of the below script as its related to my posted question: INSERT INTO HR_STG_T.PstnToEmpl_WT (PstnCd, effper, prsnlNbr) W...
515 Jul 2014 @ 01:24 PDTGeneralTopicORDER BY cannot be used in sub queriesHi, Recently our TD system got upgraded to Teradata 14.10.0206 from Teradata 13.11. After the upgradation, I can see an unusual behavior. the script never used to fail previously, but now its fai...
428 Dec 2013 @ 08:45 PSTDatabaseReplyTeradata architechtural behaviourThanks a tonne Raja! Could you please provide me a link for such document, so that it can be more understandable to me?   Regards, Soumik
319 Dec 2013 @ 10:01 PSTDatabaseTopicTeradata architechtural behaviourHi all, I would like to know that in which specific scenarios, an AMP will be overloaded - for example, while firing an untuned query, how would this SQL be submitted to the AMPs and how the AMPs...
210 Dec 2013 @ 11:36 PSTDatabaseReplyMerge statement showing 0 records mergedhi Raja, as you mentioned that it can be the behaviour of teradata sql assistant, but as per my experience, when i ran the same query in sql assistant, i could see the non zero record counts. ...
108 Dec 2013 @ 05:19 PSTDatabaseTopicMerge statement showing 0 records mergedHi all, I have been recently facing an issue while asking TD DBAs to execute a MERGE statement.  Everytime a merge statement is executed by them, it shows 0 records MERGED, whereas while cro...