714 Jun 2016 @ 03:44 PDTDatabaseTopicSpool in which volatile table lies.Hi, Is it possible to find the spool number in which volatile table lies? Regards, Chirag  
614 Jun 2016 @ 03:40 PDTViewpointReplyNegative Spool in ViewpointHi Carlos, Thanks for you answer. But can you please update on what is Phantom / Orphan spool, Or do you have a link where I can read about it?  Regards, Chirag  
519 May 2016 @ 06:01 PDTViewpointTopicNegative Spool in ViewpointHi All,   Recently while monitering Viewpoint I saw one of the delete queries showing negative spool. Can any one tell me what does that indicate.   Regards, Chirag
402 May 2016 @ 01:18 PDTDatabaseReplyAvoid skewing during delete TeradataThanks for the Responce Todd. Its a TYPO here the condition is tbl1.non-PI is not null. Can you give me solution to solve the issue.   Regards, Chirag  
302 May 2016 @ 01:12 PDTDatabaseReplysystem-determined change threshold for Stats-- TeradataThanks Dinesh
212 Apr 2016 @ 04:39 PDTDatabaseTopicAvoid skewing during delete TeradataHI,   I am trying to delete the non PI column from the pi column of the same table. Query as below.   delete From A tbl1   Where  Exists(       &n...
103 Mar 2016 @ 04:21 PSTDatabaseTopicsystem-determined change threshold for Stats-- TeradataHi, We are collecting stats on a table , however the stats collection is getting skipped. On going for explain for the stats collect statement, we find something like: We SKIP collecting STATIST...