#DateWhereItemComment
905 Nov 2015 @ 12:59 PSTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Is there a provision to recollect stats based on their names ? COLLECT STATS <Statistics Name> ON TABLENAME;
804 Jan 2014 @ 10:04 PSTcarrie's blogEntering and Exiting a TASM StateHello Carrie.. I wanted to confirm if my understanding (from my previous question regarding the priority schemes) is near correct. Priority schemes can essentially be set for different states....
704 Jan 2014 @ 09:58 PSTcarrie's blogCPU Limits at Multiple LevelsI apologize for not being clear. I'll repost my uderstanding under the appropriate blog.. Thank you so much for taking time to answer. Sincere Regards Sanjeev
630 Dec 2013 @ 10:42 PSTcarrie's blogCPU Limits at Multiple LevelsThank you Carrie..Appreciate you responding... Quick one though.. In the context of "a different priority scheme"... how different is it from Workload change (based on a state change) fr...
521 Dec 2013 @ 12:17 PSTcarrie's blogCPU Limits at Multiple Levels Another question.. does a Resource Partition CPU's limit effect the RP's relative weight calculation. Similarly would a CPU limit on an AG impact the Relative Weight within the RP % calc...
420 Dec 2013 @ 04:00 PSTcarrie's blogCPU Limits at Multiple LevelsHi Carrie !!! Excuse me if this question is outside the scope of this discussion... From the TASM orange book... While defining an exception action for "Change WD across all operating envir...
328 Mar 2013 @ 07:14 PDTMarcio MouraLet's talk about Aggregate Join Indexes (AJI)Well explained article. Quick question though. What if we use a function while aggregating. For instance SUM(ZEROIFNULL(<column_name>)) The optimizer seems to ignore the AJI. The foll...
226 Nov 2012 @ 11:00 PSTDatabaseStatistics Collection Recommendations for Teradata 12Thanks.. Appreciate your response.
123 Nov 2012 @ 01:17 PSTDatabaseStatistics Collection Recommendations for Teradata 12What happens to the validity of the stats if a single column index is dropped ? (Considering that stats were collected on the index) Internally the single column index's stats are stored as column...