#DateForumTypeThreadPost
1305 Dec 2015 @ 12:55 PSTDatabaseTopicHow to Identify Table(s) are Candidate for Columnar using DBQL...?Hi,   Need to identify tables which are candidate for Columnar. DB Version 14.10
1215 Oct 2015 @ 02:23 PDTDatabaseReplyRe write a queryExplain:-   1) First, we lock a distinct xyz."pseudo table" for write on      a RowHash to prevent global deadlock for      xyz.#VAU_DETAIL...
1114 Oct 2015 @ 04:46 PDTDatabaseTopicRe write a queryHi, Can you please help me re-write below query as it is highly skewd and having very high Impact cpu.   DELETE FROM xyz.#VAU_DETAIL a  where exists  (select 1 from &nb...
1013 Aug 2015 @ 12:19 PDTDatabaseTopicTop resource consuming queryHi, I have to get the top resource hungry queries...? If any one help with the queries which can give me top 10 distinct queries it will be very help full. I have onle select access on pdcrinfo vi...
905 Aug 2015 @ 04:56 PDTDatabaseReplyMonitor Index CreationThanks Dieter
805 Aug 2015 @ 02:28 PDTDatabaseTopicMonitor Index CreationHi, Can we check how much in % of index creation is completed..?   Say I have a table of 2TB in size; I just fired a command to create an USI and after some time if i wanted to know how muc...
713 Jul 2015 @ 11:15 PDTDatabaseReplyUnderstanding BLC featuresHi, A)See below link hope it will help. http://tinyurl.com/p3cu24l Compression in Teradata - by Carrie Ballinger (Orange Book) I read it on one of the orange book. B).Statistics collection ...
611 Jul 2015 @ 11:45 PDTDatabaseReplyQuery to get most expensive query running/historical without/with using DBQL..? Is it always required to login to viewpoint to monitor queries which are expensive; For historical queries I can check in DBQL but what to do for current running..?
511 Jul 2015 @ 11:39 PDTDatabaseTopicQuery to get most expensive query running/historical without/with using DBQL..? Hi,   I just wanted to know how can I monitor queries currently running in my Database which are eating up resources i.e. CPU etc..?  
411 Jul 2015 @ 02:32 PDTDatabaseReplyBackup and Restore only statistics in TeradataHi Glass,   Thanks, Got it. If there is a way I can take backup of statistics of a table_A so that if I refresh the statistics of table_A I have always a backup of stats which i can restore...
310 Jul 2015 @ 06:04 PDTDatabaseTopicBackup and Restore only statistics in Teradata Hi,   Actually I am new to Teradata;    I Just wanted to know if there is a way to restore old statistics or copy only statistics from table A to Copy of table A.....
209 Jul 2015 @ 12:45 PDTDatabaseTopicInstall Teradata on Laptop / VMHi,  1) I am new to teradata; I wanted to Install Teradata Software all my on a Laptop/VM. Please help where can I get the binary and installation Instructions.   2) I have previously ...
103 Jul 2015 @ 12:09 PDTDatabaseTopicBackup and Restore only statistics in TeradataHi,   Actually I am new to Teradata; I Just wanted to know if there is a way to restore old statistics or copy only statistics from table A to Copy of table A...?   Regards, Arpit