86 | 04 Aug 2016 @ 02:36 PDT | Über SQL | New StatsInfo query for TD14 | Hi Dmitry,
you mean the first stats collection when there's no row in dbc.StatsV, yet?
I don't think there's a way to avoid using a column list, there's no guarantee that PIs or S... |
85 | 22 Jul 2016 @ 02:10 PDT | Extensibility | UDF User Guide | Did you notice that this was posted 13 years ago?
There's a SQL Functions and Operators manual:
http://www.info.teradata.com/HTMLPubs/DB_TTU_15_10/index.html#page/SQL_Reference/B035_1145... |
84 | 14 Jul 2016 @ 09:11 PDT | Über SQL | New StatsInfo query for TD14 | This still works in TD15.10, there seems to be no additonal info.
Outdated stats can be found by adding a WHERE-condition on LastAlterTimeStamp/LastCollectTimeStamp and table without ... |
83 | 21 Apr 2016 @ 09:48 PDT | Über SQL | New StatsInfo query for TD14 | Hi JK,
it's still working in TD15.10.
There's a new StatsVersion 6, but when I checked those reserved/unused bytes still contain only zero.
|
82 | 10 Feb 2016 @ 07:47 PST | Über SQL | When sample statistics go wild | Afaik you can't turn of stats extrapolation and imho there's no reason to do so.
It's just a try to adjust the stats to the new count and if it's not working as expected you can si... |
81 | 05 Jan 2016 @ 10:31 PST | Über SQL | How to simplify your statistics collection with a queue table | Hi Kevin,
this queue approach was based on TD13/13.10, but my StatsInfo query changed in TD14, I removed some columns, see New StatsInfo query for TD14 for more details.
For TD14 it is ... |
80 | 21 Dec 2015 @ 01:25 PST | Über SQL | How to simplify your statistics collection with a queue table | Hi Kevin,
sorry for the late answer, I overlooked your comment...
This works as-is in 14.10, but I didn't find a way to code combining multiple related stats (e.g. (col1), (col2), (col1,col2)... |
79 | 15 Oct 2015 @ 11:45 PDT | Über SQL | New StatsInfo query for TD14 | Hi Chet,
my old Statsinfo query can be found here.
The link is in the 1st paragraph :-)
|
78 | 26 Sep 2015 @ 12:54 PDT | Über SQL | New StatsInfo query for TD14 | It's still working on TD15 (didn't check on 15.10) and I didn't notice any new info.
There's only one thing: the AccessCount no longer works (always NULL) since TD14.10, ... |
77 | 23 Jul 2015 @ 05:00 PDT | Über SQL | New StatsInfo query for TD14 | Hi Arpit,
if this is a TD Express you should download a newer release
|
76 | 22 Jul 2015 @ 01:50 PDT | Über SQL | New StatsInfo query for TD14 | @arpitsinha:
What's your Teradata release?
Did you try the latest release of my StatsInfo?
I had this error for ANSI mode, but it was fixed at 2014-02-03.
The CREATE for the reverse_by... |
75 | 01 Jul 2015 @ 07:02 PDT | Über SQL | How to decode the binary statistics stored in dbc tables | @Hibellm:
You only need this query if you're on a release lower than TD14.
Since TD14 there's a builtin view returning similar information, dbc.StatsV, try this instead, every user (=PUB... |
74 | 30 Apr 2015 @ 02:02 PDT | Über SQL | Global and session level parameters in SQL | Hi Misha,
if you see getQueryBandValue in Explain it's still defined as NOT DETERMINISTIC and will be evaluated once per row/call.
But caution: I just run some more tests and found that ... |
73 | 31 Jan 2015 @ 08:36 PST | Über SQL | New StatsInfo query for TD14 | Hi John,
to run a SHOW STATS in a SP you might try Glenn McCall's approach:
Running Unsupported Queries from a Stored Procedure
But I woud prefer creating an empty copy of the table.... |
72 | 16 Jan 2015 @ 05:08 PST | Über SQL | New StatsInfo query for TD14 | Hi Giovanni,
that's a bug, it was fixed half a year ago, but I forgot to upload it.
Now it's attached, thanks
Dieter
|
71 | 15 Jan 2015 @ 09:31 PST | Database | Extracting table and column statistics | Hi Rohan,
check the error message again :-)
"The user does not have CREATE EXTERNAL PROCEDURE access to database DBC."
You try to create the function in dbc, so you need the &quo... |
70 | 17 Dec 2014 @ 02:02 PST | Über SQL | New StatsInfo query for TD14 | Hi Samir,
yep, this is correct :)
|
69 | 24 Oct 2014 @ 10:22 PDT | Über SQL | When sample statistics go wild | Sorry, but I don't have expertise in using AutoStats, yet.
|
68 | 03 Oct 2014 @ 06:03 PDT | Über SQL | When sample statistics go wild | Hi Gyanendra,
in TD14+ the SAMPLE is automatically applied when you collect the next time. You need to switch it off explicitly using NO SAMPLE.
|
67 | 23 Sep 2014 @ 08:17 PDT | Über SQL | New StatsInfo query for TD14 | There's no replacement.
Dbc.StatsTbl.Histogram holds the binary stats, similar to dbc.Indexes.IndexStatistics, but the internal structure is totally different.
|
66 | 22 Sep 2014 @ 08:57 PDT | Über SQL | New StatsInfo query for TD14 | There's no other replacement than IndexStatsV.
What else do you need from the old view?
|
65 | 22 Sep 2014 @ 05:28 PDT | Über SQL | New StatsInfo query for TD14 | ColumnPosition is not needed anymore as you get all ColumnNames in a comma-delimited list.
IndexName and UniqueFlag would need a join to dbc.IndicesV using DatabaseName/TableName/IndexNumber plus ... |
64 | 08 Aug 2014 @ 02:11 PDT | Über SQL | New StatsInfo query for TD14 | Hi Abhishek,
yep, it's returning NULL because it's a VarChar, read the description of Min/Max/ModeVal:
(only for single column numeric or datetime stats)
The reason is simple, I don'... |
63 | 05 May 2014 @ 01:09 PDT | Über SQL | New StatsInfo query for TD14 | @TusharGade:
No, you can't use any kind of HELP or SHOW in a SP...
BUT:
There was a nice article on how to bypass that restriction recently:
Running Unsupported Queries from a Stored Proced... |
62 | 14 Mar 2014 @ 03:29 PDT | Über SQL | New StatsInfo query for TD14 | Hi Sivakunar,
afaik in TD13.10 there's no way to tell if stats are not used by the optimizer except reading explains and checking the confidence level.
In TD14.10 there's a STA... |