# | Date | Forum | Type | Thread | Post |
8 | 11 Sep 2015 @ 02:55 PDT | General | Topic | Need 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... |
7 | 15 Jul 2014 @ 04:07 PDT | General | Reply | ORDER BY cannot be used in sub queries | Thanks for your help, Dieter! :)
Regards,
Soumik
|
6 | 15 Jul 2014 @ 01:47 PDT | General | Reply | ORDER BY cannot be used in sub queries | Thanks 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... |
5 | 15 Jul 2014 @ 01:24 PDT | General | Topic | ORDER BY cannot be used in sub queries | Hi,
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... |
4 | 28 Dec 2013 @ 08:45 PST | Database | Reply | Teradata architechtural behaviour | Thanks a tonne Raja!
Could you please provide me a link for such document, so that it can be more understandable to me?
Regards,
Soumik
|
3 | 19 Dec 2013 @ 10:01 PST | Database | Topic | Teradata architechtural behaviour | Hi 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... |
2 | 10 Dec 2013 @ 11:36 PST | Database | Reply | Merge statement showing 0 records merged | hi 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.
... |
1 | 08 Dec 2013 @ 05:19 PST | Database | Topic | Merge statement showing 0 records merged | Hi 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... |
|
|