#DateWhereItemComment
410 Jun 2013 @ 06:01 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi 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 ...
324 Mar 2011 @ 10:34 PDTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandCarrie - 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...
210 Aug 2010 @ 08:58 PDTcarrie's blogIf 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...
110 Aug 2010 @ 08:48 PDTMarcio MouraWhen is the right time to refresh statistics? - Part IIMarcio 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...