#DateForumTypeThreadPost
1803 Aug 2015 @ 01:21 PDTDatabaseReplyDefining Index on a table having multiple Joining columns!!Hi, Chosing the Join columns of one of the joins as the Primary Index makes definitely sense. Regarding the secondary index: It really depends if the index can be used. This is influenced by selec...
1703 Aug 2015 @ 01:17 PDTDatabaseReplyClob Column - performance implicationsHi. I was writing a post on my blog about this topic. Basically, CLOBs are not stored in the base table but in a sub table. Depending if you select the CLOB column or not this may have an performan...
1608 May 2015 @ 12:10 PDTDatabaseTopicFree Compression ToolWe developed a free compression tool, which you can download from our website (the documentation, 15 pages, is included) http://www.dwhpro.com/teradata-compression-3/ Sincerely Roland   &...
1516 Feb 2015 @ 12:02 PSTDatabaseReplyCompare database between prod and devI am doing this with a Unix shell script which exports all object definitions to flat files considering differences between Teradata Releases. In a second step I use Beyond Compare (http://www.sco...
1416 Feb 2015 @ 11:54 PSTDatabaseReplyFunctions in Join ConditionsI assume that performance is the same in both cases. 
1316 Feb 2015 @ 11:48 PSTDatabaseReplySpool SpaceYes, spool space is taken from the available perm space but each user has a spool space limit assigned to avoid "run-away" queries which would otherwise use up the complete space.&nb...
1216 Feb 2015 @ 11:41 PSTDatabaseReplyHow to write a select query for all columns in a join environment but only show a subset There is something missing in your query. I cannot see the second table after the "inner join" ...
1116 Feb 2015 @ 11:36 PSTTrainingReplyFree Teradata Indexing Video CourseThank you very much for your feedback. I am planing to create a video series, each video covering a certain topic. I would kindly ask you to let me know which would be the most interesting to...
1019 Dec 2014 @ 03:11 PSTTrainingTopicFree Teradata Indexing Video CourseHi,  We recorded an 01:30 hour video course about indexing and data access (i.e strategies to reduce IO) on Teradata including NUSI,USI,Join Index, Primary Index (UPI,NUPI), Full Table Scan a...
919 Dec 2014 @ 03:03 PSTDatabaseReplyJoin Index and Value OrderingThank you very much Fred.
813 Dec 2014 @ 02:39 PSTDatabaseTopicJoin Index and Value OrderingHi, The follwing is not clear to me: We have value ordering for Join Indexes, but at the same time the Join index has a Primary Index and is ROWHASH distributed. For me this means, Master Index an...
713 Dec 2014 @ 02:31 PSTDatabaseTopicContent of Row Pointer Array for Value OrderingHi, In case of a NUSI ordered by ROWHASH the array of row pointers in each NUSI data block contains the orderd ROWID of its rows. Basically (leaving the UNQIUENESS value beside), it is ordered by ...
631 Mar 2014 @ 02:46 PDTDatabaseReplySET table to Multiset TableYou can create a copy of a table and change the table level attribute from SET to MULTISET. This can be done with the statement for cloning tables CREATE TABLE AS... You can't change just the ...
510 Aug 2012 @ 09:07 PDTDatabaseReplyParsing Engine is taking long time to parse a query !!! Hi. I had the same problem with parsing times up to several minutes. Additionally we experienced flowcontrol state at one AMP during the nightly batch loads and especially with increasing number...
430 Apr 2012 @ 10:37 PDTDatabaseTopicHow to find the time a fastload was blocked because no utility slot was available Is there any way to find out from the DBC tables the delay between logon of the fastload sessions and when a utility slot was available?   thanks   Roland
330 Apr 2012 @ 08:56 PDTToolsReplyhow does fastexport multiple sessions works? Thanks.   But I wonder why i see 4 sessions with the same "SELECT * FROM <TABLE>...any ideas?
229 Apr 2012 @ 05:29 PDTToolsReplyhow does fastexport multiple sessions works? I have a similar question. We use TPT Protocoll (via Datastage using 4 partitions) for exporting data and when i look at PMON i can see 4 times (4 sessions) the same "SELECT * FROM <TABL...
129 Apr 2012 @ 05:07 PDTDatabaseTopicNumber of utility slots used in TPT fastload Hi, We are using TPT-Adapter in Datastage to load the data. Datastage is using 4 partitions and I wonder how this is related to the number of utility slots which are used in such a lad takin...

Pages