#DateWhereItemComment
811 Mar 2015 @ 08:03 PDTÜber SQLWhen sample statistics go wildHello, Thank you once more for all these new tricky updates on evert TD version. One question ,  so we have to check all the PPI tables where the PI column is also a level of partition ? Fu...
718 Nov 2014 @ 08:29 PSTDatabaseRight Sizing Data for Space Savings and PerformanceWe must not also forget that by applying correct DDL ,  we will minimize the spool / cpu / io on queries which contain Varchar fieds and participate on group by / order by  . Furthermore ...
616 May 2014 @ 03:08 PDTMarcio MouraLet's talk about Aggregate Join Indexes (AJI)Hello, I would like to ask three questions about JI. Let's assume that we have one fact table and two dimension. We have implement everything as you said , RI on fact , unique PI on domains....
525 Apr 2014 @ 05:26 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hello, Thank you one more time for your replies. Concerning the (2)  , i did not set the question correctly (and correct me again , since i am not very familiar with TASM). I wanted to unde...
424 Apr 2014 @ 10:57 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hello Carrie , I would like to ask three more question concerning the stats , if it is possible. 1.If i will make a new table with different DDL (change some columns from varchar(20) to (10) or v...
313 Mar 2014 @ 04:04 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hello Carrie , Thank you very much for your responses && time.  
210 Mar 2014 @ 05:59 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hello Carrie,   First of all , i would like to thank you for your time on writting / replying all these. I would like to ask five questions , 1.Is the order of the columns of DDL the defau...
113 Feb 2014 @ 05:37 PSTViewpointIntroduction to the New Workload Designer Resource Allocation User InterfacePerfect Introduction!!   Thanks for sharing.