#DateForumTypeThreadPost
822 Feb 2016 @ 12:12 PSTToolsReplyWhen are secondary indexes required?HI Santhanu, Thanks for the example. Thanks Saeed.  
701 Jul 2014 @ 10:14 PDTTrainingReplyTeradata Online Training & certification Guys,   Do not waste your time in outside trainings.   www.info.teradata.com is THE BEST site,  plenty of documents & manuals available from TD12 to TD14.1...
601 Jul 2014 @ 10:12 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad?? Guys,   Do not waste your time in outside trainings.   www.info.teradata.com is THE BEST site,  plenty of documents & manuals available from TD12 to TD14.1...
526 Jun 2014 @ 01:09 PDTDatabaseTopicHow to modify DDL when UPI is on IDENTITY COLUMN & RI imposed Hi Forum,   I have a table created as SET table using IDENTITY column as UPI and it has data in it. Now, the user wants us to change it to MULTISET, but, as the PI is on Identit...
419 Jun 2014 @ 03:58 PDTDatabaseReplyABNORMAL BEHAVIOR OF QUERY IN TD14.10 after upgrade from TD14Hi Dieter, Thanks a lot and sorry for late response. Yes, when I have contacted TERADATA CS, we got to know that, its a bug with optimizer. The optimizer doesn’t have the logic to handle t...
307 May 2014 @ 10:26 PDTDatabaseReplyLock row for access : In insert-SelectHi, Locking row for access can be used in an INSERT, but, the Locking statement should be provided on top. Lock tab1 for access insert into tab2 sel * from tab1;   Sravan.
230 Apr 2014 @ 09:20 PDTDatabaseTopicABNORMAL BEHAVIOR OF QUERY IN TD14.10 after upgrade from TD14Hi Forum, We have upgraded our system from TD14 to TD14.10 (2days back) and facing abnormal behavior of one query. The query when executed from SQLA, Bteq , TDStudio provided the result in less t...
122 May 2012 @ 10:09 PDTToolsReplyTeradata Urgent Help! Hi, As mentioned above, (By default, AccessCount and LastAccessTimestamp will be disabled). ObjectUseCountCollectRate field in DBS Control must be set to a non-zero value. Then y...