#DateWhereItemComment
42017 Oct 2014 @ 10:09 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Vincent,   Session management in Workload Designer only covers the load utilities, and TPT Stream is SQL-based, so it not it is not officially a utility.    The numb...
41914 Oct 2014 @ 02:23 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Sadeep,   It is normal to get this warning if statistics have been skipped and you do not have USECOUNT logging on.     If you look up that message (or google it), here is w...
41814 Oct 2014 @ 02:19 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations Considerations for collecting stats are generally the same for a NoPI table and a PI table.  Other than (obviously) not collecting stats on the PI of a NoPI table.    However, stat...
41708 Oct 2014 @ 09:20 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Peter,   I tried your syntax on a pre-14.0 version of SQLA and it worked fine for me.     Unfortunately, I'm not going to be able to help you with SQLA behavior ...
41608 Oct 2014 @ 09:19 PDTcarrie's blogEasing Into Using the New AutoStats FeatureSandeep,   Analyze Jobs will always read USECOUNT data from DBC.ObjectUsage regardless of what the “Database containing log tables” is set to.   Although it is true that U...
41529 Sep 2014 @ 08:14 PDTcarrie's blogEasing Into Using the New AutoStats FeatureSandeep, There are several good reasons to set NoDot0Backdown = TRUE when you get onto 14.10.  Use of extended object names require it, as does use of increased data block and spool block siz...
41424 Sep 2014 @ 08:02 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Hi Terry,   I wish I could help you, but this is not an area of familiarity for me.  And I have no idea who might know something like this.      I'd suggest you pos...
41324 Sep 2014 @ 07:59 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksVasudev,   Whether or not you want to remove the reserve count of 2 depends on how those reserves are being used.  If they are not being used ever by any work, then it makes sense to re...
41219 Sep 2014 @ 03:36 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hi Jessie,   You do not need to collect statistics on any of the StatsTbl columns unless you have users who are accessing StatsTbl as one of the participating tables in a mult-itable qu...
41117 Sep 2014 @ 08:09 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Armin, If you haven't seen it, take a look at my blog posting Statistics Threshold Functionality 101.  That may provide a little more understanding about how to use threshold. In general...
41010 Sep 2014 @ 09:49 PDTcarrie's blogWorkload Management with User Defined Functions and Table OperatorsGeeta,   The flow control event in 13.10 is not a very reliable way to assess the frequency or even the presence of flow control on the AMPs.  That is because it does not use the flow c...
40908 Sep 2014 @ 08:34 PDTcarrie's blogWorkload Management with User Defined Functions and Table OperatorsGeeta,   FlowControlled:  This metric tells you if the AMP is in flow control at this point in time. It is a snapshot taken at the end of the logging interval.  If it is zero, it i...
40804 Sep 2014 @ 12:04 PDTcarrie's blogExpediting Express RequestsDan,   That's a question that is better addressed to your Teradata account team.  Or you might want to ask that question on one of the Teradata Q&A forums and get feedback from ...
40702 Sep 2014 @ 03:00 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Pietro,   Even when a table has no rows at the time you collect stats, the optimizer will always adjust that up to one row before it attempts to build the query plan.   The cost...
40629 Aug 2014 @ 04:50 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Srini,   My apologies, but I did not get notified of your comment.   The asterisk in the first line of the HELP STATS output represents the row count of the table.  It comes from...
40529 Aug 2014 @ 04:42 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Chetan,   The first line that you see in the HELP STATS output in 14.0 represents the table row count in the UniqueValues column.   That is why it has an asterisk for the Column Na...
40429 Aug 2014 @ 04:34 PDTcarrie's blogWorkload Management with User Defined Functions and Table OperatorsGeeta,   There are many different delay queues in the database.   When you say "delayed sessions in the delay queue" that you say you can see in Viewpoint, I believe you ...
40322 Aug 2014 @ 08:37 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Pinal,   Statistics rows in the new DBC.StatsTbl in 14.0 refer to table id not table name. So, there is no problem with renaming a table, the stats from the old name (collected and RAS) will...
40222 Aug 2014 @ 08:33 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations Whether the PPI table uses a single level of partitioning, or multiple level of partitioning, the guidelines are still the same.  The fourth bullet under "Other Considerations" above...
40118 Aug 2014 @ 04:36 PDTcarrie's blogExpediting Express RequestsSarathy,   Although it is possible,  I would not expect tactical queries to be impacted much, if at all, from competition with express requests.    Express requests ...
40014 Aug 2014 @ 08:46 PDTcarrie's blogFastExport for Really Short Queries in Teradata 13.10Ambuj,   I am not able to help you with this question as I am not experienced with FastExport coding conventions.  I'd suggest you post your question on Teradata Forum at:  htt...
39913 Aug 2014 @ 01:59 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksHi Ana,   Releasing COD will not increase the number of AMP worker tasks to your platform, but it will increase CPU and I/O resources, so requests that are holding AWTs&n...
39829 Jul 2014 @ 04:21 PDTcarrie's blogTips on using Sampled StatsSantanu,   You cannot actually apply USING SAMPLE to summary stats, which are the table-level statistics new in 14.0.  I'm guessing you meant you were collecting sampled stats on a ...
39722 Jul 2014 @ 02:43 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Murali,   You are correct that DelayTime and WDDelayTime are formatted differently.    Starting in 14.0, DelayTime is made into FLOAT so a user can see microseconds. &nbs...
39616 Jul 2014 @ 04:13 PDTcarrie's blogExpediting Express RequestsRasika,   I have never used Teradata Studio Express.  I think you may have posted this question on the wrong blog.   Sorry I cannot help you.    You could try post...

Pages