#DateForumTypeThreadPost
705 Feb 2016 @ 02:40 PSTDatabaseTopicPatitioning expressionWhich of the following partitioning expression has a better performance while SELECT, INSERT operations ? Consider the table has data around couple of Terabytes. PARTITION BY RANGE_N(LOAD_TIMESTAM...
625 Nov 2015 @ 09:45 PSTDatabaseReplyOracle Table to Teradata DDLTry AQT (Advanced Query tool).
531 Aug 2015 @ 05:14 PDTGeneralReplySQL (combine multiple insert-sel statements into one ) Hi Kirti,   Thanks for help. It seems I have to go with UNION ALL as the suggested query is not returning the appropriate data. I tried another way as below but that too ...
431 Aug 2015 @ 01:43 PDTGeneralReplySQL (combine multiple insert-sel statements into one )Hi Adeel, I just want to compare the performace of both queries and then decide, which one to implement finally.
328 Aug 2015 @ 02:51 PDTDatabaseReplyOracle Table to Teradata DDLHi Muthu, I think there is a tool Teradata aceleration manager provided by Teradata .It will be helpful if you have to do this migration activity for large numner of objects. If you have to do th...
226 Aug 2015 @ 12:33 PDTGeneralTopicSQL (combine multiple insert-sel statements into one )Hi , I want to merge following multiple insert - select statements into a single insert-select statement without using UNION/UNION ALL. Please suggest.   INSERT INTO Fact SELECT DATE AS LO...
130 Jul 2015 @ 03:12 PDTGeneralReplyHow to update a datatype of a column in a table having huge dataHi Aakash, As you mentined that you have to update the data of a column of a production table, the best and safest way would be to create another table as per your requirement and load data into t...