#DateWhereItemComment
1507 Sep 2016 @ 11:09 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0 Hi Carrie,  Thanks for the explanation... We sometimes have tables with several multicolumn stats having the same number of unique values. In this example: collect stats column (A,...
1406 Sep 2016 @ 09:25 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Thanks For the clarification on ROWID......   I have another question.  In the original blog you have the explanation below.  Could you please expand  eon this?  I am not...
1309 Aug 2016 @ 07:04 PDTcarrie's blogDetermining Precedence Among TASM Planned EnvironmentsThank you Carrie, great information....
1205 Aug 2016 @ 04:33 PDTcarrie's blogDetermining Precedence Among TASM Planned EnvironmentsHi Carrie, Thanks for the information.  Yes, Workload Designer is not letting me. Once I move the workload to SLG in on environment, it moves the workload from all environment to SLG... ...
1103 Aug 2016 @ 10:44 PDTcarrie's blogDetermining Precedence Among TASM Planned EnvironmentsHi Carrie, I need to create a new workload and a new planned environment. No problem here... The new workload needs to be in SLG Tier2 during the new planned environment,, but then in Timeshare o...
1027 Jun 2016 @ 06:38 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi carrie, Is there a benefit in collecting stats on the ROWID column in a join index? For the first time today, we saw a recommendation from Stats Manager to collect stats on ROWID col...
929 Oct 2015 @ 11:45 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Carrie, We have USEOUNT enabled for all our end table databases... But I was wondering if there will be a negative system impact if we turn it ON for ALL databases,, fro example  st...
824 Mar 2015 @ 02:31 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hello, I just heard from someone that in TD14.10 stats can be collected on only NEW Partition of a table. And they are not talking about collecting stats on column PARTITION.   Can we coll...
716 Mar 2015 @ 10:51 PDTcarrie's blogEasing Into Using the New AutoStats FeatureHi Carrie, Do we need to do some clean up before we start a new analyze job in stats manager. I have been running Analyze jobs for differernt databases, and every time the job runs longer than be...
613 Nov 2014 @ 01:35 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Asking see I see this:     show statistics column (orig_sys_id) on NA_EDW.WHSE_INV_LOC COLLECT STATISTICS             &nb...
513 Nov 2014 @ 01:24 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Carrie, I am not sure I quite understand the Syssampleoption in DBSControl. When its set to 0 or 1(default), does it mean all stats collections are sampled based on the optimizer dec...
404 Nov 2014 @ 09:47 PSTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hi Carrie, I have stats collection run on DBC tables rcommended above daily.  But it looks like , and according to 14.10 orange book on stats, the collection skips,,, the optimizer internally...
304 Nov 2014 @ 07:57 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Thanks Carrie. That was very helpful... I have another question. If I understand correctly, if we drop stats on a table, we lose history. If we drop a table, we will also lose history. So, when...
230 Oct 2014 @ 07:25 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi carrie, In the 14.0 orange book, section 2.1.5 Column Ordering for Multicolumn Stats, it says that column ordering is honored with the exception of the statistics collected with Index specifica...
117 Jun 2014 @ 09:26 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Carrie, Starting with Teradata 12 or 13 (cannot remember), we collected stats on column PARTITION on ALL our tables (partition tables and non partition tables),as we were advised. With T...