#DateForumTypeThreadPost
520 Oct 2015 @ 12:52 PDTDatabaseTopicQuery to identify missing numbers between 2 valuesHi Teradata experts,   Need your expertise in writing an SQL for the below scenario   I have a  single row in a table range_num  as follows.   start...
405 Oct 2014 @ 01:38 PDTDatabaseTopicSessionID duplicates in DBQLogTBL for 2 different dates 8 months apart!!Hi Forum,   I am observing the following sessionID’s in my dbqlogtbl. Basically it’s the same sessionID used about 8 months apart!!   SessionID    &nbs...
302 Oct 2014 @ 05:17 PDTDatabaseReplyPartitioning by a character columnHi Dieter,   Does including hashbucket/MOD function in TD13.10 cause any performance issues. I mean if I can use CHAR-PPI in 13.10 over the HASHBUCKET/MOD approach am I likely to see a perfo...
217 Jul 2013 @ 01:43 PDTDatabaseReplyAmp CPU time and query optimizationHi Dnoeth,   Can you please explain why in the calculation of PJI and UII we multiply the AmpCpuTime by 1000?   Thanks' Sandesh R Gitte
117 Jul 2013 @ 01:40 PDTDatabaseReplyDBQL MetricsHi,   Can you guys please explain , why in the calculation of PJI and UII we multiply AmpCpuTime by 1000   Thanks Sandesh