#DateForumTypeThreadPost
714 Jul 2016 @ 01:25 PDTDatabaseReplyALTER_PPINo, you are trying to modify the PPI of a populated table. Rows are already distributed in this case and you can not redistribute.   
614 Jul 2016 @ 01:19 PDTDatabaseReplyAvoid all-row scan in driving table using NUSIIts the Optimizer to choose the best cost effective plan. However, there are maultiple conditions underwhich SI will not be used. You may need to read more of USI/NUSI selection criteria.
514 Jul 2016 @ 01:12 PDTDatabaseReplyRegarding Teradata MigrationKaushik, From your post I understand that, you are migrating from 15.00 to 15.10(the versions for source and target Tearadata is close), then it would be a minor upgrade.  It may be a patch u...
412 Jul 2016 @ 01:11 PDTDatabaseReplyRestore using DSA with NO BUILD option.Thanks Abhishek for your reply. My question was, is it possible to  BUILD the table separately after restore completed with NO BUILD just like ARCMAIN. Anyway I got the answer from TD univers...
308 Jul 2016 @ 06:31 PDTDatabaseTopicRestore using DSA with NO BUILD option.Hi, I have a large restore around 5 TB, I'm using DSA to Backup and restore. I want to restore with NO BUILD option and BUILD the tables separately using ARCMAIN(Build Data Table (xx.yy) ...
229 Feb 2016 @ 08:59 PSTDatabaseTopicGetting Error Message inside a Stored Proc Exception Handler Hi All,   I'm a core-DBA, not much idea in  stored Proc's.   I have written a a SP with Exception CONTINUE HANDLER. My requirement is to get the Error Mess...
118 Nov 2015 @ 01:00 PSTDatabaseTopicMultiple DDL/Grant statements inside Procedure Open Exec_cursor;   SET RECCOUNT = ACTIVITY_COUNT;   REPEAT FETCH Exec_cursor into sql_text2 ; CALL DBC.SYSEXECSQL(sql_text2); --CALL dbc.sysexe...