|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:
|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
|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...
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... |