#DateWhereItemComment
34518 Dec 2013 @ 08:55 PSTcarrie's blogEasing Into Using the New AutoStats FeatureIt turns out that there is an issue with the Automated Statistics Management orange book avalability on Teradata at Your Service.  It is in the process of being addressed.   Thank ...
34416 Dec 2013 @ 01:13 PSTcarrie's blogAutomatic Throttles in Teradata 14.0 and 14.10Hi Reddy,   Unfortunately, that's out of my area of experience.  My suggestion is to try posting this question on Teradata Forum or other Teradata-specific email groups.   Th...
34313 Dec 2013 @ 10:55 PSTcarrie's blogEasing Into Using the New AutoStats FeatureAkleema,   I was able to access this orange book just now on Teradata At Your Service.   This is what I did, see if this works for you:   From the Home page, click on the Knowl...
34212 Dec 2013 @ 02:44 PSTcarrie's blogAutomatic Throttles in Teradata 14.0 and 14.10Starting in Teradata 13.10, you can apply "common classification" to system throttles.  This means that you can create a system throttle and add classification criteria of the Query ...
34112 Dec 2013 @ 02:42 PSTcarrie's blogEasing Into Using the New AutoStats FeatureDinesh,   Prior to Teradata 13.0 a user must have INDEX or DROP privileges on the table in order to collect statistics, if the user is other than DBC.   If you are using  INDE...
34009 Dec 2013 @ 01:27 PSTcarrie's blogEasing Into Using the New AutoStats FeatureHi Ulrich,   There are two ways I know of to find orange books on Teradata At Your Service site.  It sounds like you tried the first method, by writing “orange book...
33906 Dec 2013 @ 08:59 PSTcarrie's blogFastExport for Really Short Queries in Teradata 13.10Padhia,   The sessions access data in a round robin fashion across the AMPs, getting one block of rows at a time from each AMP, then moving on to the next AMP.   The...
33805 Dec 2013 @ 04:39 PSTcarrie's blogTeradata 13.10 Statistics Collection Recommendations The number of distinct values is more significant for these types of multicolumn statistics you are asking about below, than is the length of the values stored in the statistics histogram. &nb...
33704 Dec 2013 @ 08:21 PSTcarrie's blogAre AMP Worker Tasks used by FastExport in Response Mode?There is a  high priority given to the CPU usage required when returning rows. This is because it is in internal activity, as opposed to a user-initiated SQL execution type of activity, a...
33620 Nov 2013 @ 04:41 PSTcarrie's blogStatistics collection recommendations – Teradata 14.0Chetan,   I am so sorry, but I must have missed answering this question at the time it was posted.    The asterisk under column names is indeed new in 14.0 and represents the num...
33520 Nov 2013 @ 08:21 PSTcarrie's blogAutomatic Throttles in Teradata 14.0 and 14.10Vasudev,   Your understanding is correct.   Please re-read the response I made to you last week, as I think that suggests a reasonable direction for you to take going forward.  ...
33415 Nov 2013 @ 11:03 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Raja,   Fresh statistics are always the best.  But extrapolation capabilities, particularly in releases 14.0 and above, can provide some relief for sites that simply do not have the tim...
33313 Nov 2013 @ 08:52 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Raja,   There is a blog posting that lists the recommendations for collecting statistics.     It makes these recommendations for indexed columns:   Collect Full Stati...
33213 Nov 2013 @ 08:29 PSTDatabaseSkew-Sensitivity in the Optimizer: New in Teradata 12Vasudev,   Unfortunately, I am not able to provide personalized responses to all the various questions/problems that you have posted as comments across my blog in the last few months (three ...
33108 Nov 2013 @ 02:15 PSTcarrie's blogControlling the Flow of Work in TeradataSumeet,   Work message queue length is not considered a tunable.  The queue length may be different from one configuration to another and one site to another.   That diff...
33008 Nov 2013 @ 08:06 PSTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeIf your average CPU time has increased after an upgrade there are several factors that could be responsible for this:   - While you may have more CPUs per node after the upgrade, it is possi...
32906 Nov 2013 @ 08:01 PSTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10I agree!   Good hearing from you Barry.  Keep in touch.   Thanks, -Carrie
32831 Oct 2013 @ 10:42 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksVasudev,   The flowcontrolled field is a snapshot of the state of the AMP (either it is in flow control, or not) at the end of the logging period.  It does not tell you if the AMP was i...
32729 Oct 2013 @ 08:31 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Hi Barry, Even if you were not delaying these queries, there is still a small window of time between query optimization and query start time where the replace view command could get submitted a...
32625 Oct 2013 @ 11:32 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hi Chetan,   In 14.0 the HELP STATS statement has been enhanced to show a summary of the table's statistical information.  The first row of output, which will display an asterisk un...
32518 Oct 2013 @ 10:32 PDTDatabaseSkew-Sensitivity in the Optimizer: New in Teradata 12Bhavesh,   The optimizer looks at the query and sees what columns are used for selection criteria and for joins, and then attempts to find statistics for just those columns.  If it...
32409 Oct 2013 @ 01:36 PDTcarrie's blogTASM State Changes are Streamlined in Teradata 14.0Two system events could be triggered at the same point in time.   At each event interval, a check is done to see if any system events have taken place.  It is possible more than one ...
32309 Oct 2013 @ 01:33 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Ram,   I am not aware of any such script, but your could post your questoin on one of the Teradata forums and see if anyone in Professional Services or anyone working at a Teradata site has ...
32225 Sep 2013 @ 04:15 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Suhail,   You do not need to collect summary stats, unless no other stats have been collected on the table during the recent timeframe.  Summary stats are automatically collected every ...
32124 Sep 2013 @ 03:03 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0To Suhail,   It is always a good thing to collect stats on PARTITION for all partitioned tables.  It is not used for extrapolation in 14.0, but is important for optimizer decisions when...

Pages