#DateForumTypeThreadPost
1615 Jun 2016 @ 12:37 PDTDatabaseReplyAlter table on huge tableThanks Samir for your opinion on this. Couple of questions arises in my mind as I have already mentioned in my previous post: 1. Under what circumstances every row in the table to be rewritten? ...
1514 Jun 2016 @ 11:47 PDTDatabaseTopicAlter table on huge tableThere is a requirement to add three NULLable columns at the end of existing table which is of volume about 1TB. I would like to know what is the best approach to perform this activity if there is ...
1409 Feb 2016 @ 05:50 PSTDatabaseTopicMerge ErrorI am trying to run a MERGE statement (to perform UPSERT) where one of the column in Primary Index is nullable. I am encountering the following error when I run the same: "The search condi...
1326 Jul 2015 @ 08:57 PDTDatabaseReplyPerformance TuningThanks once again for the correction. Yes indeed, it would be replaced  by JOIN. It's a 120 AMP system. I need to get the information on system type and will get back to you. Well, I tri...
1225 Jul 2015 @ 10:38 PDTDatabaseReplyPerformance TuningYes, there is no matching PIs. Unfortunately, I don't have access to the tables you mentioned. Not sure if the below steps that I have choosen may be correct. Need your suggestion on this 1....
1125 Jul 2015 @ 02:28 PDTDatabaseReplyPerformance Tuning( Call_Start_Dt ,Call_Start_Tms ,originating_num ,Terminating_Num ,imei_nbr ,Seq_Nr ,Prepaid_Seq , postpaid_Seq ,I_Seq ) is the PI on target table and is a multiset table. Thanks!
1025 Jul 2015 @ 02:09 PDTDatabaseReplyPerformance TuningThanks for your response. I tried the approach you mentioned. But did not gain any improvement. c.src_system , c.src_batch_nr are  derived columns and hence should be src_system & src_bat...
925 Jul 2015 @ 12:44 PDTDatabaseTopicPerformance TuningHi, The below query takes around 30-35 minutes to store results in a temporary table.  SELECT c.call_start_dt ,        'xrx' A...
815 Jul 2015 @ 07:10 PDTDatabaseReplyInsert into target table from source table for each date for a specific date rangeThis is a question regarding the post http://forums.teradata.com/forum/general/tuning-query. CALL_DETAILS is a partitioned table.
715 Jul 2015 @ 06:30 PDTDatabaseReplyInsert into target table from source table for each date for a specific date rangeI want to loop thru each day partition for the given timeframe and my understanding is that the sql query would be more optimal as it would hit the partition only each time. To hit the sql with s...
615 Jul 2015 @ 06:24 PDTDatabaseReplyInsert into target table from source table for each date for a specific date rangeThanks for your reply. I did not get your point. Issue is that we have to pick the data from this source table ( this is a partitioned table) for around 5 months date range.The tableis partitione...
515 Jul 2015 @ 05:36 PDTDatabaseReplyInsert into target table from source table for each date for a specific date rangeThe table source_tbl  is a partition table for each day and hence, assumpption is that it would be faster to hit single partition and then insert for each day.
415 Jul 2015 @ 02:43 PDTDatabaseTopicInsert into target table from source table for each date for a specific date rangeCan we loop thru insert into a target table using SQL? for each date_col in DATE '01/03/2014' to DATE '31/05/2015' loop insert into target_tbl  select col1, col2,col3 ...
326 Jun 2015 @ 04:28 PDTGeneralTopicsubstract valueHow can I substract col2 from col1?     col1 is  timestamp(0)  12/12/2014 12:08:00 col2 is varchar column   03:04:00
205 Jun 2015 @ 12:27 PDTGeneralReplyTuning queryThanks for your response. Here's the plan. Your suggestion will really help. Thanks once again in advance for giving your valuable time. Problem: insert into xerox.tmp_call_dtl ( ... ...
104 Jun 2015 @ 02:14 PDTGeneralTopicTuning queryselect          c.call_start_dt         ,c.call_start_tm         ,c.call_dir_ind ...