# | Date | Where | Item | Comment |
---|---|---|---|---|
4 | 10 Jun 2013 @ 06:01 PDT | carrie's blog | New opportunities for statistics collection in Teradata 14.0 | Hi Carrie In the SQL Data Definition Langauge - Detailed Topics manual for TD14 it lists: - SYSTEM MAXINTERVALS - SYSTEM MAXVALUESLENGTH With SYSTEM SAMPLE the manual suggests that ... |
3 | 24 Mar 2011 @ 10:34 PDT | carrie's blog | How to set a System-Level CPU limit for Capacity-on-Demand | Carrie - is there any level you would say not to set this at. The reason for asking is that our DR server is set at 35% - which we can increase during a DR event - but I always felt it was so low i... |
2 | 10 Aug 2010 @ 08:58 PDT | carrie's blog | If You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now. | Hello Carrie, Is there a cut off point when collecting statistics on DBC is not a good idea. I have worked at sites where users have the ability to create/drop tables. On a daily basis you can se... |
1 | 10 Aug 2010 @ 08:48 PDT | Marcio Moura | When is the right time to refresh statistics? - Part II | Marcio Thanks for the information - there is a recommendation to collect statistcis on PARTITION for all tables, regardless of whetehr they are PPI or not. Your Part 1 shows the syntax and the e... |