#DateWhereItemComment
528 Nov 2013 @ 03:22 PSTcarrie's blogAre AMP Worker Tasks used by FastExport in Response Mode?Thank You Carrie for the important piece of information. I have always been concerned about sessions stuck in long responding state . Based on the statement : "In addition, the CPU for retu...
420 Mar 2013 @ 11:40 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Thank You Carrie .... That was really helpful . #3 was a beautiful explanation :) For #2 , The volatile table is getting joined to itself .. so there are no other tables involved .What amazes me i...
318 Mar 2013 @ 10:02 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0@Barani_Sachin : I have come across this error ...this happens when you conurrently try to define stats on same table ... Not related to stored proc ... To confirm , Just try keeping one collect s...
216 Mar 2013 @ 07:45 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Thank You Carrie .. That was informative . 1> I was going through the orange book , which mentions the aggregation algorithm being used only when the stats are recollected . But I have tried de...
112 Feb 2013 @ 05:56 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Carrie , 1.I would like to understand , why do the figures of using pre aggregation optimization alogrithm vary ? for one 100 GB table I get 75% saving and for another 1TB table I get 15 % fo...