![]() |
I have been experimenting with using MAXVALUELENGTH to make additional columns in multi-column stats significant. I have not been able to find anywhere a definition for what the maximum value is for this stats attribute.
17 Jan 2016
,
|
![]() |
Hi All,
11 Aug 2015
| 3 comments
,
|
![]() |
Hi,
08 Apr 2015
| 2 comments
,
|
![]() |
Hello,
04 Feb 2015
| 7 comments
,
|
![]() |
Hi,
05 Nov 2014
| 4 comments
,
|
![]() |
The accuracy of sample statistics has been greatly improved over the last Teradata releases. So I usually try to use sample stats on most of the big tables and I found them to be reliable on many columns, not only the officially recommended unique or nearly-unique columns, e.g. on DATEs.
02 Oct 2014
| 12 comments
,
|
![]() |
Statistical information is vital for the optimizer when it builds query plans. But collecting statistics can involve time and resources. By understanding and combining several different statistics gathering techniques, users of Teradata can find the correct balance between good query plans and the time required to ensure adequate statistical information is always available. This recently-updated compilation of statistics collection recommendations are intended for sites that are on any of the Teradata Database 14.10, 15.0, or 15.10 software release levels. Some of these recommendations apply to releases earlier than Teradata Database 14.10 and some rely on new features available starting in Teradata Database 14.10. Statistics collection functionality in the Teradata Database works the same in 14.10, 15.0 and 15.10 releases. For greater detail on collecting statistics for Teradata Database 14.10, see the orange book titled: Teradata Database 14.10 Statistics Enhancements by Rama Krishna Korlapati. Contributors: Carrie Ballinger, Rama Krishna Korlapati, Paul Sinclair, September 11, 2014
11 Sep 2014
| 43 comments
,
|
![]() |
An earlier blog post focused on simple steps to get started using the Teradata 14.10 Automated Statistics Management (AutoStats) feature. One of the new capabilities that AutoStats relies on when it streamlines statistics collection is the new “Threshold” option. Threshold applies some intelligence about when statistics actually need to be re-collected, allowing the optimizer to skip some recollections. Although you will probably want to begin relying on AutoStats when you get to 14.10, you don’t have to be using AutoStats to take advantage of threshold, as the two features are independent from one another. This post will give you a simple explanation of what the threshold feature is, what default threshold activity you can expect when you get on 14.10, and what the options having to do with threshold do for you. And you’ll get some suggestions on how you can get acquainted with threshold a step at a time.
06 Feb 2014
| 18 comments
,
|
![]() |
Database Version: Teradata 13.10.0609 13.10.06.09A
12 Aug 2013
| 5 comments
,
|
![]() |
I have a long query generated from Microstrategy with lots of joins which was running our of spool space. I checked the query and confirmed that we had stats collected on all the join columns and stats were current. Then there was one column on which I dropped stats, it had both single and multi column stats after which the query started to run fine.
08 Jul 2013
| 2 comments
,
|
![]() |
Hi
18 May 2013
| 1 comment
,
|
![]() |
We have a stored procedure which will look at a table and collect statistics on different columns and indexes based on types etc. We use this inside of other stored procedures after loading staging tables. For some reason I keep getting the following error:
29 Sep 2011
| 3 comments
,
|
![]() |
Hi All !!! In Teradata 12, collect statistics step fails with spool space error for the below mentioned table. Skewness of the table is under the acceptable range. PFB the table structure and collect statistics step: CREATE SET TABLE DB_1.TABLE_1, NO FALLBACK,
31 Dec 2010
| 2 comments
,
|
![]() |
|
![]() |
From Books: When doing collect stats on fields/indexes , system collects the information like: total row counts of the table, how many distinct values are there in the column, how many rows per value, is the column indexed, if so unique or non unique etc The above information are known as statistics. case1: I dont have collect stats on "Emp_Details" table.
07 Sep 2010
| 18 comments
,
|
![]() |
I’ve mentioned it before, Marcio has blogged about it, customers have brought it up at the Partners Conferences. It’s cheap, fast, risk-free, with immediate results. But some of you are still not getting it. Or it could be you’re one of the few who truly don’t need it.
24 May 2010
| 22 comments
,
|
![]() |
Collecting full statistics involves scanning the base table and performing a sort to compute the number of occurrences for each distinct value. For some users, the time and resources required to adequately collect statistics and keep them up-to-date is a challenge, particularly on large tables.
29 Apr 2010
| 23 comments
,
|
![]() |
Please note: This posting is relevant only to software releases prior to Teradata Database 14.0. Ignore this recommendation if you are on 14.0 or greater software.
24 Nov 2009
| 11 comments
,
|
![]() |
This article delves into the potential excessive use of Multi-Column (MC) Statistics and a process for identifying those that are not providing benefit and should be removed. This will reduce complexity and save resources on the re-collection of these redundant statistics.
22 Nov 2009
| 22 comments
,
|
![]() |
You’re in a time crunch. Maybe you’ve got an undersized backup environment that is incredibly slow, or you just have important stuff happening and you need to keep the software upgrade window as short as possible.
23 Jun 2009
| 1 comment
,
|
![]() |
Authors: Carrie Ballinger, Rama Krishna Korlapati, Paul Sinclair Looking for a fresh perspective on collecting statistics, or just want a confirmation that you’re on the right track? Either way, you’ll want to read this quick summary of recommendations for Teradata 12 stats collection.
01 May 2009
| 59 comments
,
|
![]() |
Until you have Teradata V13 Statistics Wizard Easy Feature available for your Teradata installation, here is a set of stored procedures that will generate and/or run collect statistics statements based on a set of index, column and referential integrity rules.
07 Apr 2009
| 3 comments
,
|