#DateWhereItemComment
44517 Feb 2015 @ 03:56 PSTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10Utility limit definitions and current utility throttle counters are kept in memory in the parsing engine.   If you want to view what TASM sees in terms of throttle definitions and current th...
44416 Feb 2015 @ 10:48 PSTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Individual column statistics and multicolumn statistics are not interchangeable.  For example, the optimizer will not use two individual column stats to replace a multicolumn stat that include...
44312 Feb 2015 @ 04:33 PSTcarrie's blogExpediting Express RequestsSmarak,   Thank you for catching the typo where I left off "cache" after "data dictionary" above.  I have made that correction.   Express requests first look ...
44210 Feb 2015 @ 08:27 PSTcarrie's blogWhy collect PARTITION statistics on Non-Partitioned tables?Growth detection relies on both RAS comparisons and row count comparisons.  Extraploation only happens if growth in a table that the statistic belongs to (let's call that statistic p_name)...
44106 Feb 2015 @ 02:01 PSTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionThere's an earlier posting that explains the earlier approach to how the parsing workload is selected:   http://developer.teradata.com/blog/carrie/2014/12/a-closer-look-at-how-...
44004 Feb 2015 @ 02:04 PSTcarrie's blogWhy collect PARTITION statistics on Non-Partitioned tables?Collecting statistics on PARTITION only applies in Teradata releases BEFORE 14.0.  After 14.0 you do not want to collect on PARTITION for all tables, only for partitioned tables.   I...
43904 Feb 2015 @ 02:01 PSTcarrie's blogEasing Into Using the New AutoStats FeatureHaritha,   One thing to check.  When you access DBC.ObjectUsage its best to use one of the DBC views for that purpose.  When you access UDI counts for a table, those table-level Ob...
43815 Jan 2015 @ 08:07 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0There is posting here on Dev that addresses 14.10 statistics recommendations.  Information contained there should answer your question:   http://developer.teradata.com/blog/carrie/2014/...
43712 Jan 2015 @ 03:52 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Geeta,   The reason for separating non-utility work at the WD level by means of Utility classification is three-fold:  1.)  As you already mentioned, for reporting and analysis pur...
43609 Jan 2015 @ 10:32 PSTcarrie's blogRejection CAN be RewardingI believe you can use a period event type to do this.   I have not done this myself, but you should be able to set up a TASM event that triggers a program to run at specific times, by doing ...
43507 Jan 2015 @ 12:57 PSTcarrie's blogExpediting Express RequestsHi Dan,   Those two are not really very comparable, other than within the columnar functionality you may experience something called autocompression if you define a partition with a type of ...
43406 Jan 2015 @ 11:18 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Response to Geeta's second posting above:   In 14.0, you will still have a workload evaluation order, but you no longer have the ability to change the workload evaluation order across di...
43306 Jan 2015 @ 11:16 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Response to Geeta's first posting above:   If you only have 40 workloads, then it really doesn't matter from the performance perspective if you re-order the evaluation order list bas...
43202 Jan 2015 @ 12:46 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Sudhakar,   Different statistics collections on different tables will behave differently when you move to either 14.0 or 14.10 from an earlier release.    I am glad to hear th...
43118 Dec 2014 @ 04:41 PSTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadRoberto,   There is no "default"  workload for just parsing.   Parsing will happen at the same workload that the session's logon uses.   Depending on t...
43001 Dec 2014 @ 04:23 PSTcarrie's blogControlling the Flow of Work in TeradataVipin,   One of the points I tried to make in the posting above had to do with the limit of 20 messages being associated to the work type:  "The message queue o...
42917 Nov 2014 @ 02:41 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Nazy,   The SysSampleOption is to enable or disable system-determined sample percent globally.   When it is enabled, the system decides whether or not to using sampling, and at ...
42805 Nov 2014 @ 11:18 PSTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hi Nazy,   You are correct that there is an internal time threshold set for all data dictionary tables of 15 days.  Using the default settings, when you submit a stats collection on a d...
42705 Nov 2014 @ 08:28 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Response to Nazy:   You can export stats and then after you have inserted into all rows into the new table, you can import them back.    When you issue this command:  &n...
42605 Nov 2014 @ 08:24 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Response to HateOra:   From a statistics point of view, make sure you have followed all the recommendations for PPI table statistics that are provided in this blog posting:   http://d...
42531 Oct 2014 @ 09:11 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Nazy,   If the INDEX specification is included in the multicolumn collect stats statement, the columns will be reordered to match the index.  This is because the index columns are ...
42428 Oct 2014 @ 10:14 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Sandeep,   Once you are using TASM, or even just using the throttle category of TASM, the DBS Control parameters (MaxLoadTasks and MaxLoadAWTs) are no longer honored.   Under those co...
42328 Oct 2014 @ 09:19 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Harsha,   Why don't you talk to your Teradata account team and ask if they can help you locate a resource to answer questions you have on AutoStats.  Unfortunately, I am not that pe...
42228 Oct 2014 @ 08:57 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10The only information I currently have on AutoStats has been posted on Developer Exchange at:   http://developer.teradata.com/blog/carrie/2013/12/easing-into-using-the-new-autostats-feature ...
42128 Oct 2014 @ 08:22 PDTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandIt would be best to ask both of your questions of Teradata associates who specialize in hardware setup and configurations.   Unfortunately, that is not an area of expe...

Pages