#DateForumTypeThreadPost
1411 Mar 2015 @ 06:03 PDTDatabaseReplyAPI for DBC.SysExecSQLhi gents, i'm currently having a problem.  not sure if this is a teradata bug or something I'm running a dynamic insert sql (complete with generating a where clause based on values)....
1307 Feb 2014 @ 02:07 PSTDatabaseReplySQL WorkaroundGuys, Apologies for the late reply .   I had discussed this with my colleagues and here's what we've came up with:  The problem is that the joining columns are skewed so here...
1227 Jan 2014 @ 04:45 PSTDatabaseReplySQL WorkaroundRaja, Dieter, Thank you for responding.  I'll try to explain as much as I can for Raja: > data volume, explain, amps etc if any. Ok. data volumes vary.  I've one query...
1123 Jan 2014 @ 06:24 PSTDatabaseReplySQL Workaroundhi TD forumers, I'm experiencing a query that goes like this ( due to some legal restrictions, im not permitted to write down codes outside the premise, i'll try my best to write a pseudo ...
1021 Nov 2013 @ 04:43 PSTDatabaseReplyNo More Spool SpaceGuys, I want to answer my question based from what I've experienced.  It's not good to deliberately change the PI just to address the problem.  My ImpactCPU went higher than expe...
926 Oct 2013 @ 05:11 PDTDatabaseReplyNo More Spool SpaceI dont know if its a good practice to deliberately address the skew problem by using as many columns as possible (to address skewing ) even if the query's wont use these columns.  I unders...
826 Oct 2013 @ 05:01 PDTDatabaseReplyDELETE statement taking 2 hours.hi, id like to share something. Ive faced a situation like this.  The thing I did was to copy ONLY the records needed into a another table, verify the records, rename tables and asked DBA to d...
710 Oct 2013 @ 09:41 PDTDatabaseReplyMinimizing Redistribution  hi, im also interested in this.would there be any kind of query rewriting technique that can be used to force teradata doing what kind of joins we wanted first before the others? or the onl...
629 Sep 2013 @ 02:43 PDTUDAReplyto check is a string is numeric or notI'm going to face a problem like this.   I have a query to tune that does joins to own table using like any conditions.  The pseudo code would be something like  SEL A.COL1, A....
519 Sep 2013 @ 08:27 PDTDatabaseReplySQL Workaroundah yes, i think i saw things like that dieter on my previous project.   Anyway, an update to everyone.  I was advised by my partner to just make recommendation of a structural change sin...
417 Sep 2013 @ 05:36 PDTDatabaseReplySQL WorkaroundYes, Dieter, that's what I need to test now - to see if the rewrite did change the resultsets.  I do found out that there are joins to NUPI columns and count of distinct is around 30% less...
317 Sep 2013 @ 09:17 PDTDatabaseReplySQL WorkaroundRaja, Thanks, I'll try that out.     For everyone's record, what i did was a query rewrite. I found some columns that can be used to link together. Hopefully I can get a smilin...
216 Sep 2013 @ 05:30 PDTDatabaseReplySQL WorkaroundHi dieter,   The BIG table had 500m records and the small one had 48m. The DBQL shows high CPU Impact, skewness and spool usage. BTW I was told that our systrm is sitting on 680 AMPs.
116 Sep 2013 @ 09:42 PDTDatabaseTopicSQL Workaroundhi Teradata forumers,       Can you guys help figure an SQL? here's my problem.  For my query tuning work, Im joining a fairly big table and a small one.The column being...