#DateForumTypeThreadPost
21416 Nov 2015 @ 01:26 PSTDatabaseReplyQuery runs for 5 hoursThe values are not known beforehand nore are fixed so the voaltile table cannot be populated. Dieter,  Can you help rewriting this query?  
21304 Nov 2015 @ 07:51 PSTDatabaseReplyQuery runs for 5 hoursHow can it be rewritten ?
21203 Nov 2015 @ 06:54 PSTDatabaseReplyQuery runs for 5 hoursDieter need your expert opinion!
21129 Oct 2015 @ 01:16 PDTDatabaseReplyQuery runs for 5 hoursThanks for responding! The  CURR_A_MTCH_FLG has stats. We are currently on TD 15 and its a 960 amp system.
21029 Oct 2015 @ 12:18 PDTDatabaseReplyQuery runs for 5 hoursDieter, need your expert opinion!
20929 Oct 2015 @ 08:47 PDTDatabaseTopicQuery runs for 5 hours explain UPDATE E_TBL       FROM DB1.WHSL_E_TBL         AS E_TBL,         DB1.WHSL_A_TBL&nbs...
20828 Sep 2015 @ 12:38 PDTToolsReplyHigh ImpactcPU Explain DELETE FROM    ETL_DB.D_TRAN WHERE   ID in   ( SEL     ID FROM    ETL_DB.D_C WHERE   CURRENT_DATE ...
20728 Sep 2015 @ 12:36 PDTToolsTopicHigh ImpactcPU
20629 Jul 2015 @ 07:31 PDTAnalyticsReplyTrend analysisAny suggestions?
20517 Jul 2015 @ 11:03 PDTAnalyticsTopicTrend analysisHi all We have some fact tables . Now the business needs a view (fact table left outer joined to some other dimesion tables )which they can use for historical trend analysis. So even though the fa...
20425 Jun 2015 @ 07:34 PDTDatabaseReplyPPI delete shows high estimates EXPLAIN DELETE FROM DB.TBL_HIST WHERE TRANS_DATE = (SELECT TRANS_DATE  FROM DB. TBL2) AND TRANS_DATE = (SELECT TRANS_DATE  FROM DB.TBL GROUP BY 1 )   1) First, we lock a dist...
20324 Jun 2015 @ 01:51 PDTDatabaseTopicPPI delete shows high estimates DELETE FROM db.tbl_HIST WHERE trans_date = (SELECT trans_date  FROM db.tbl2 ) AND trans_date = (SELECT trans_date  FROM db.tbl GROUP BY 1) ; DELETE FROM  db.tbl_HIST WHE...
20224 Jun 2015 @ 07:47 PDTConnectivityTopicParameter for no of connections or sessions to Teradata 2015-06-23 15:00:37,075 [Thread-11] ERROR com.XXX.dataconnector.ClientThread  - Unable to load connector and populate data: Unable to read data source; [Teradata JDBC Driver] [TeraJDBC 14....
20128 Apr 2015 @ 08:57 PDTDatabaseReplyTune qryAppreciate any pointers!
20022 Apr 2015 @ 09:04 PDTDatabaseReplyTune qryAnyone, any suggestions?
19921 Apr 2015 @ 03:53 PDTDatabaseReplyTune qryDieter, Need your expert help..Any suggestions on how this query can be written to improve performance?
19810 Apr 2015 @ 11:16 PDTDatabaseTopicTune qry Explain SELECT  AA.REPORT_DATE,  BB.PD_DT AS FILE_DATE, AA.ACE_PRM_LG_HRY_NUM  AS PRM_UPID, AA.ACE_FNL_LG_HRY_NUM AS UPID, AA.ACE_PRM_LG_HRY_NM  AS PRM_UPNM, AA.ACE...
19730 Mar 2015 @ 09:07 PDTDatabaseReplyTune queryExperts any suggestions?
19626 Mar 2015 @ 12:38 PDTDatabaseReplyTune query Explain INSERT INTO    DB1.Table1  SELECT S.DT , ‘STG’ , ‘NF’ , S.SID , S.OID , S.FID , S.B_NUM , NULL , NULL , NULL , NULL , S.LOB , CUR...
19526 Mar 2015 @ 12:32 PDTDatabaseTopicTune query
19419 Feb 2015 @ 11:40 PSTDatabaseReplyProduct joinDieter, Appreciate any suggestions.
19318 Feb 2015 @ 06:50 PSTDatabaseReplyProduct join Explain UPDATE ALIAS2      FROM TABLE2         AS ALIAS2        , TABLE1     &...
19217 Feb 2015 @ 05:05 PSTDatabaseTopicProduct join Explain SELECT MAX(TABLE1.FD_DT)                      FROM TABLE1 AS TABLE1 WHERE TABLE1.AC...
19104 Feb 2015 @ 12:48 PSTDatabaseTopicTuning qry  INSERT INTO Db.TbInserted      -- SET table with UPI SELECT S.PD_DT , 'StgTbl1' , 'CG FLTY' , S.SS_ID , S.OR_ID , S.FY_ID , S.BK_NO , '...
19015 Jan 2015 @ 11:54 PSTDatabaseTopicSpool space issue CREATE MULTISET VOLATILE TABLE VolatileTable2 AS (  SELECT   ROW_NUMBER() OVER ( ORDER BY    ............................  FROM  (   SELECT ...

Pages