#DateWhereItemComment
8604 Aug 2016 @ 02:36 PDTÜber SQLNew StatsInfo query for TD14Hi 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...
8522 Jul 2016 @ 02:10 PDTExtensibilityUDF User GuideDid 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...
8414 Jul 2016 @ 09:11 PDTÜber SQLNew StatsInfo query for TD14This 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 ...
8321 Apr 2016 @ 09:48 PDTÜber SQLNew StatsInfo query for TD14Hi 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. 
8210 Feb 2016 @ 07:47 PSTÜber SQLWhen sample statistics go wildAfaik 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...
8105 Jan 2016 @ 10:31 PSTÜber SQLHow to simplify your statistics collection with a queue tableHi 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 ...
8021 Dec 2015 @ 01:25 PSTÜber SQLHow to simplify your statistics collection with a queue tableHi 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)...
7915 Oct 2015 @ 11:45 PDTÜber SQLNew StatsInfo query for TD14Hi Chet, my old Statsinfo query can be found here. The link is in the 1st paragraph :-)
7826 Sep 2015 @ 12:54 PDTÜber SQLNew StatsInfo query for TD14It'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, ...
7723 Jul 2015 @ 05:00 PDTÜber SQLNew StatsInfo query for TD14Hi Arpit, if this is a TD Express you should download a newer release
7622 Jul 2015 @ 01:50 PDTÜber SQLNew 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...
7501 Jul 2015 @ 07:02 PDTÜber SQLHow 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...
7430 Apr 2015 @ 02:02 PDTÜber SQLGlobal and session level parameters in SQLHi 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 ...
7331 Jan 2015 @ 08:36 PSTÜber SQLNew StatsInfo query for TD14Hi 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....
7216 Jan 2015 @ 05:08 PSTÜber SQLNew StatsInfo query for TD14Hi Giovanni,  that's a bug, it was fixed half a year ago, but I forgot to upload it. Now it's attached, thanks Dieter
7115 Jan 2015 @ 09:31 PSTDatabaseExtracting table and column statisticsHi 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...
7017 Dec 2014 @ 02:02 PSTÜber SQLNew StatsInfo query for TD14Hi Samir, yep, this is correct :)
6924 Oct 2014 @ 10:22 PDTÜber SQLWhen sample statistics go wildSorry, but I don't have expertise in using AutoStats, yet.
6803 Oct 2014 @ 06:03 PDTÜber SQLWhen sample statistics go wildHi Gyanendra, in TD14+ the SAMPLE is automatically applied when you collect the next time. You need to switch it off explicitly using NO SAMPLE.
6723 Sep 2014 @ 08:17 PDTÜber SQLNew StatsInfo query for TD14There's no replacement. Dbc.StatsTbl.Histogram holds the binary stats, similar to dbc.Indexes.IndexStatistics, but the internal structure is totally different.
6622 Sep 2014 @ 08:57 PDTÜber SQLNew StatsInfo query for TD14There's no other replacement than IndexStatsV. What else do you need from the old view?
6522 Sep 2014 @ 05:28 PDTÜber SQLNew StatsInfo query for TD14ColumnPosition 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 ...
6408 Aug 2014 @ 02:11 PDTÜber SQLNew StatsInfo query for TD14Hi 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'...
6305 May 2014 @ 01:09 PDTÜber SQLNew 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...
6214 Mar 2014 @ 03:29 PDTÜber SQLNew StatsInfo query for TD14Hi 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...

Pages