#DateForumTypeThreadPost
603 Jul 2012 @ 03:04 PDTDatabaseTopicTemporary Tables in Teradata Hi Gurus, I am looking for some guidelines on when to use each of the following form of temporary tables: 1) Derived Table 2) Volatile Table 3) Global Temporary Table Any poi...
508 Feb 2012 @ 04:24 PSTDatabaseReplyFastest way to update a table joining to a huge table If both the table have same PI then use MERGE UPDATE. Nothing faster than that.
411 Jan 2012 @ 03:41 PSTAnalyticsReplydifference between having a filter condition in the where clause as against a on join clause Since all the joins are inner joins, the optimizer will filter the rows of table 'a' as per the condition prod_cat = 7980. The timing will not get affected by where you put it. Check the...
311 Jan 2012 @ 03:34 PSTUDAReplyQuery Tuning Few others: 1) Check if there are any functions being used in the joins. Makes stats ineffective. 2) Use DIAGNOSTICS HELP STATS ON FOR SESSION to make sure you are not missing any single...
211 Jan 2012 @ 03:10 PSTDatabaseReplyWill colease function in join condition invoke secondary index In my view no. One should avoid using functions in joins.
110 Nov 2011 @ 04:35 PSTDatabaseReplyHigh SkewnessDid you get the issue resolved? In my view, the skewness primarily happens due to "bad" data distribution over amps. Here the PI seems to be fine but apparently you might be getting a lot of null v...