#DateWhereItemComment
54512 Feb 2016 @ 01:54 PSTcarrie's blogTeradata Basics: ParallelismHi Pierre,   I am concerned that you may have misiinterpreted one of the details in the posting.   This statement that you quote:  "any sub-expressions that the different SQ...
54412 Feb 2016 @ 01:52 PSTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Here is a link for an article here on Dev X that describes STATSUSAGE and XMLPLAN:   http://developer.teradata.com/database/articles/identifying-used-unused-and-missing-statistics   T...
54312 Feb 2016 @ 01:50 PSTcarrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXHi Dave,   It depends (sorry).   With MLOADX, whether freespace percent will be honored depends on the operations being utilized within the utility.    if you are doi...
54228 Jan 2016 @ 03:41 PSTcarrie's blogEasing Into Using the New AutoStats FeatureUnfortunately, I am not able to give you specific recommendations on what to implement because I am not familiar with your site.  And I don't have first hand experience with most of enhanc...
54128 Jan 2016 @ 03:39 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0The rules that apply to a global temp table in terms of stats collection do not apply to volatile tables.   Global temp table have a definition in the dictionary, but volatile tables do n...
54026 Jan 2016 @ 03:15 PSTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0TVM and Dbase are both tables that commonly have stats collected on them.   So I don't see a problem with collecting stats in addition to the ones usually recommended for those tables...
53921 Jan 2016 @ 02:44 PSTcarrie's blogDatabase Tasks that Run on the Parsing Engine I don't think there is any "ideal" parsing time, at least that I have heard of one.  Parsing time depends on many things, such as the type of work that is undergoi...
53819 Jan 2016 @ 03:25 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0If you want to collect statistics on the instance of a global temp table within your session, you would need to include the word TEMPORARY.  If you do not include TEMPORARY, then stats wi...
53704 Jan 2016 @ 08:38 PSTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10A utility throttle evaluates and considers delaying a utility job at the CHECK WORKLOAD END statement.  CHECK WORKLOAD END is an SQL statement that procedes the utility logon.   If a...
53604 Jan 2016 @ 08:36 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0If you wish to copy the statistics that already exist on table_A to a new table that is identical to table_A, call it table_B, the fastest and easiest way to do this is to export the stats from tab...
53504 Jan 2016 @ 08:34 PSTcarrie's blogStatistics Threshold Functionality 101Laeeq,   The default settings are all zeros, your information below is correct.   The first two parameters are described above in the blog posting under the heading.   &...
53422 Dec 2015 @ 09:01 PSTcarrie's blogEasing Into Using the New AutoStats FeatureLots of things change when you go from 13.10 all the way to 15.0.  So there is no simple answer to any question involving a change in performance.   You did not say if the CDR data was ...
53322 Dec 2015 @ 08:52 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Mark,   The number of sessions used by an Informatica TPT API Stream workflow should be able to be set in the definition of the Stream connection.  I don't have direct experience in...
53218 Dec 2015 @ 08:28 PSTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerSachin,   Are you saying that all 4 workloads on SLG Tier 1 in combination have a global weight of 85%?  And that Timeshare workloads will share a global weight of 15%?   And can...
53117 Dec 2015 @ 09:26 PSTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Question #1:   I am not sure that I understand question #1:                   "Once we enable this skip...
53004 Dec 2015 @ 08:22 PSTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerSachin,   If you move a query to a different workload in the middle of a step, the new priority will take effect immediately.   If you don’t think giving a higher priority to...
52904 Dec 2015 @ 08:18 PSTcarrie's blogExpediting Express RequestsSteven,   SLES 10 and SLES 11 work in a similar way when it comes to the AWT work types different work messages will be assigned.   In SLES 10, if a workload has a tactical enforce...
52801 Dec 2015 @ 08:35 PSTcarrie's blogExpediting Express RequestsSteven,   I am assuming you are on SLES 10, as you are on 13.10 database software.   The two settings you mention ("Reserved AWT" and "Max Expedited AWTs") are not...
52725 Nov 2015 @ 03:49 PSTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionSuresh,   Could this be a PREPARE statement, if it is coming from ODBC.   Based on ODBC settings, queries will get submitted twice. The first time for parsing and second rime for actu...
52624 Nov 2015 @ 10:21 PSTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerAmir,   It is difficult to quantify CPU consumption changes between SLES 10 and SLES 11 because the accounting is completely different in SLES 11.      But in general, ...
52506 Nov 2015 @ 09:52 PSTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Hi Sanji,   Yes, you can recollect statistics by name, if a name exists.  This is particularly useful if you have multicolumn statistics.   From page 7 of the orange book titled:...
52405 Nov 2015 @ 09:43 PSTcarrie's blogStatistics collection recommendations – Teradata 14.0Christer,   There is no problem collecting sampled statstics on some columns and full statistics on others on the same table.   Full stats are often a better choice when there is n...
52305 Nov 2015 @ 09:41 PSTcarrie's blogSpecial Treatment For Users DBC and TDWMGeeta,   In terms of setting up profiles for the system IDs like DBC,TDWM,Crashdumps,Systemfe,SysAdmin,LockLogShredder,, there is no special restriction for those users, but neither is there...
52205 Nov 2015 @ 09:24 PSTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksDinesh,   There is no metric that reports the number of AWTs being used within a request or by a sessoin at any point in time, or even at the end of the request.   The ResUsag...
52102 Nov 2015 @ 04:17 PSTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadGeeta,   There are a couple of other statements types that will classify to the parsing-only workload.  Commands that using only the parsing engine, such as SHOW and/or HELP commands ma...

Pages