| # | Date | Forum | Type | Thread | Post |
|---|---|---|---|---|---|
| 7 | 05 Feb 2016 @ 02:40 PST | Database | Topic | Patitioning expression | Which 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... |
| 6 | 25 Nov 2015 @ 09:45 PST | Database | Reply | Oracle Table to Teradata DDL | Try AQT (Advanced Query tool). |
| 5 | 31 Aug 2015 @ 05:14 PDT | General | Reply | SQL (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 ... |
| 4 | 31 Aug 2015 @ 01:43 PDT | General | Reply | SQL (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. |
| 3 | 28 Aug 2015 @ 02:51 PDT | Database | Reply | Oracle Table to Teradata DDL | Hi 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... |
| 2 | 26 Aug 2015 @ 12:33 PDT | General | Topic | SQL (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... |
| 1 | 30 Jul 2015 @ 03:12 PDT | General | Reply | How to update a datatype of a column in a table having huge data | Hi 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... |