#DateForumTypeThreadPost
1128 Aug 2015 @ 12:53 PDTDatabaseTopicNeed to re-write delete statement Below delete is consuming 11K CPU.Need assistance to re-write the below delete sql to consume less CPU.   DELETE  FROM IMPORT_REFER_F AA WHERE ( AA.JOB_ID,  AA.JOB_HEADER_...
1003 Jul 2015 @ 12:54 PDTAsterReplyHow to identify a row ?No,above suggestion is not fit for my requirement.
915 May 2015 @ 02:12 PDTAsterTopicHow to identify a row ?Looking for a pseudo column/system column that helps to identify a row in a table in Aster database(similar to rowid in Oracle).Any inputs ?
807 Mar 2015 @ 10:08 PSTDatabaseReplyHigh CPU utilization query : While doing all-AMPS merge Record count : ARCH.GLOBAL_BKP : 284,167,734 ODS.GLOBAL_SOURCE(WITH ( PERD_ID/100) IN (2013,2014)) : 205,975,537 (RECORDS THAT ARE GOING TO BE INSERTED) After using between ( PERD_ID) BETW...
706 Mar 2015 @ 11:25 PSTDatabaseTopicHigh CPU utilization query : While doing all-AMPS merge We are doing insert into select from source to back up table.Select part is running fine ,where are when doing insert it is taking time and using high CPU. Based on below parameters and expla...
620 Feb 2015 @ 02:49 PSTDatabaseTopicSpool Space ErrorWhen running "SEL * FROM WEB_S_V" recieving spool space error.WEB_S_V is a complex view and underlying tables has the latest stats. Diagnostic help stats is not showing any recommendatio...
523 Jan 2015 @ 03:41 PSTDatabaseReplyHow to decide about Stats for new queries Check this out : http://developer.teradata.com/database/articles/identifying-used-unused-and-missing-statistics  
406 Dec 2014 @ 12:01 PSTDatabaseReplyList of Teradata CustomersHi All, As we are unable to find the list at one place,I request all to share the Teradata customer names which you are aware of. (To whom you worked with on Teradata system) It would be of great...
305 Dec 2014 @ 09:19 PSTDatabaseTopicList of Teradata CustomersHi All, I am looking for assistance in creating a list of all Teradata customers.i.e.List of companies who use Teradata. Located below URL ,where as I noticed this as incomplete as companies ...
226 Oct 2014 @ 05:22 PDTDatabaseTopicHadoop threat to data warehouse vendorsA friend pointed me to this article and comment on it :  http://wikibon.org/wiki/v/Data_Warehouse_Vendors_Moving_to_Contain_the_Hadoop_Threat I saw a recent announcement between Cloudera and...
118 Oct 2014 @ 10:09 PDTJobsReplyI am looking for job in Teradata.I assume you have not worked previously in IT.Plan to answer questions on data section of this forum.By the time you answer 30 to 40 questions your technicall skills improve vastly and will help yo...