#DateForumTypeThreadPost
3728 Nov 2009 @ 09:05 PSTToolsReplycomrpess columnThere is always performance degrade whenever any column is compressed and doesnt matter as used in which kind of join(left, right, inner etc). However, compression is used for space saving.
3628 Nov 2009 @ 08:59 PSTToolsTopicError while loading multiple files in Teradata using Multiload.HI, I am loading 2 input files into Teradata in a single Multiload script, but multiload behaves unpredictably and loads the rows into error tables(both UV and ET). However, when loading the same f...
3519 Feb 2009 @ 04:38 PSTToolsReplyMultiload and Fast Load estimationthanks Mchunu, for your reply.. Sorry, from my side, I didnt explain fully that what I am looking. Actually, I have to estimate a whole project, and there would be say n number or Multiloads, k num...
3418 Feb 2009 @ 05:05 PSTToolsTopicMultiload and Fast Load estimationHi All, I need to estimate the Multiload, FastLoad, and BTEQ scripts in project. Can any body tell me that which which things will consider in complexity of each Multi load, Fastload, and BTEQ jobs...
3316 Mar 2007 @ 04:54 PDTDatabaseReplySequential Execution of the Stmts within the MacroHi Abhijit, As from point of view Jose is right.... thanks
3204 Nov 2006 @ 02:39 PSTDatabaseTopiclocksHi all,How we can upgrade and downgrade the locks in Teradatacan any body explain on it...Thanks in Advance....
3104 Nov 2006 @ 02:38 PSTDatabaseTopicDBS Control...Hi AllCan any body reply on the following questionsWhat is the DBS control and How and what kind of information it is keeping...?Thanks in Advance....
3004 Nov 2006 @ 02:35 PSTDatabaseTopiclocksHi all,How we can upgrade and downgrade the locks in Teradatacan any body explain on it...Thanks in Advance....
2904 Nov 2006 @ 02:31 PSTDatabaseTopiccost and rule based OptimizerHi all,what is the COST BASED OPTIMIZER and RULE BASED OPTIMIZER and on what criteria optimizer is deciding which one to choose... can we set it in configuration setting...or user can define it in...
2813 Oct 2006 @ 06:40 PDTDatabaseReplywhether row hash changes when new nodes or Amp added?hithanks all for replying.... it is more clearer to me....Thanks......
2711 Oct 2006 @ 02:33 PDTDatabaseTopicwhether row hash changes when new nodes or Amp added?Hi All, As I am going to prepare for PI and puzzled in few questions, looking to find the answer of these questions...whether hash row changes when we add new AMPs or Nodes in the existing Terada...
2611 Oct 2006 @ 02:32 PDTDatabaseTopicwhether row hash changes when new nodes or Amp added?Hi All, As I am going to prepare for PI and puzzled in few questions, looking to find the answer of these questions...whether hash row changes when we add new AMPs or Nodes in the existing Terada...
2506 Oct 2006 @ 07:53 PDTDatabaseTopicwhat is diff stats on coln and Index.Hi All, What is the differnce between Collecting Stats on a Column and Collecting Stats on Index, which is created on the same colneg... say coln emp_no is having Index on it...Hence, what is th...
2405 Sep 2006 @ 01:51 PDTDatabaseReplySQL Qery Performance ProblemHi SPS, try below sql, and let me know resultSELECT Q.CNTCT_ID ,Q.INSTNC_ID ,Q.CMPGN_RUN_DT ,Q.CMPGN_RUN_TM ,Q.CMPGN_RUN_DATE ,Q.TRKING_ID ,Q. USER_ID ,Q.ITEM_ID ,Q.CONV_TYPE_ID ,Q. ACTIVITY_DATE...
2309 Aug 2006 @ 01:09 PDTDatabaseReplyNUSI Bitmapping?HiAs we are constantly using the term weakly/strongly selected NUSI, then how the Optimizer assures that Indexes are weekly/strongly selected, or it depends on whether statistics colleted or not?th...
2208 Aug 2006 @ 09:05 PDTDatabaseReplyNUSI Bitmapping?Hi thanks for reply, but scenario is not getting clear that what actual bitmapping is? Can anybody explain with giving query as example....Thanks in Advance......
2108 Aug 2006 @ 09:04 PDTDatabaseReplyNUSI Bitmapping?Hi thanks for reply, but scenario is not getting clear that what actual bitmapping is? Can anybody explain with giving query as example....Thanks in Advance......
2028 Jul 2006 @ 03:42 PDTDatabaseReplyNUSI Bitmapping?Hi Angel, thanks for reply, Does it mean, that it compares all the rowid of cond in where clause(which are having NUSI) to each other and then create the BITMAP.thanks in Advance.....
1928 Jul 2006 @ 03:41 PDTDatabaseReplyNUSI Bitmapping?Hi Angel, thanks for reply, Does it mean, that it compares all the rowid of cond in where clause(which are having NUSI) to each other and then create the BITMAP.thanks in Advance.....
1821 Jul 2006 @ 01:25 PDTDatabaseTopicNUSI Bitmapping?Hi All, What is NUSI Bitmapping, is it similar to Oracle Bitmap index or something else...can any body explain it.Thanks in Advance...
1717 Jul 2006 @ 09:57 PDTDatabaseReplydifference between Hash join and Merge joinHi Barry, Since it is not the case of merge join and nested join, but how will it decides between product join and Hash Joini.e. as per my understanding I am finding that when, one table is very...
1613 Jul 2006 @ 05:08 PDTDatabaseReplydifference between Hash join and Merge joinHi Barry, Thanks for reply,but I am finding that Hash join would do the product join, because one by one it is picking all the rows from small table and comparing(scanning) this with all the rows...
1512 Jul 2006 @ 02:10 PDTDatabaseTopicdifference between Hash join and Merge joinHi All, I am unable to find the difference between Hash Join and Merge Join, and when the optimizer opt among Hash join and Merge join. Can any body explain, so that things can clear..Thanks in ...
1411 Jul 2006 @ 10:02 PDTDatabaseTopicSI or PI will be choosen by Optimizer?two table are joining and on columns on which one table has both indexes ie PI and Secondary Index on single col say empno, then optimizer will choose which index to access the row, moreover statis...
1329 Jun 2006 @ 04:42 PDTDatabaseReplyJoinsDieter Thanks for reply but, Is it sure for Nested join, or can't say anything about it too.Thanks in advance

Pages