9 | 20 Dec 2013 @ 12:48 PST | carrie's blog | Statistics collection recommendations – Teradata 14.0 | Hi Carrie,
In TD 13.10 and older, when collecting on multiple columns, the order of the columns in which the optimizer analyzed the demographics was determine not by the order of the collect state... |
8 | 02 Dec 2011 @ 10:37 PST | Über SQL | Global and session level parameters in SQL | That is the same behavior that I experienced! The GetQueryBandValueSP also seems to return the correct value. Can you give me a good explanation of what deterministic and not deterministic actual... |
7 | 02 Dec 2011 @ 08:50 PST | Über SQL | Global and session level parameters in SQL | Thanks deiter!
This is really interesting now... I decided to replace the getquerybandvalue as 'NOT DETERMINISTIC' instead of 'DETERMINISTIC'. Believe it or not, this eliminated the behavior d... |
6 | 01 Dec 2011 @ 03:09 PST | Über SQL | Global and session level parameters in SQL | When I execute a view with a function it appears as though the view results get cached and do not change unless(1) a certain amount of time passes, or (2) the view gets replaced. I am executing th... |
5 | 30 Nov 2011 @ 07:37 PST | Über SQL | Global and session level parameters in SQL | Perfect... just what I was looking for.... Thanks!
I'm in the process of developing a row and column level security scheme in our EDW. I believe I am going down the path of creating a security ... |
4 | 29 Nov 2011 @ 06:43 PST | Über SQL | Global and session level parameters in SQL | Hi Deiter,
I replaced GetQueryBandValue as deterministic and then ran the following:
SET QUERY_BAND = 'dbname=dbc;MyDate=2011-03-01;' UPDATE FOR SESSION;
explain SELECT * FROM dbc.Datab... |
3 | 09 Jun 2011 @ 07:18 PDT | Viewpoint | Teradata Manager - Where is that in Viewpoint? | I schedule and run many DBA related bteq scripts on the TD MGR box. Is there currently a scheduling feature like this in ViewPoint? If not, do you have any recommendations on how to replace this ... |
2 | 08 Sep 2010 @ 07:59 PDT | Database | Workload Toolkit – Part 4 – Compression Analysis | I agree JK... I just bought CompressTool (along with SyncTool) a couple of weeks ago and love it. My only point was that to justify the cost, even though we know it saves money, to upper managemen... |
1 | 08 Sep 2010 @ 05:32 PDT | Database | Workload Toolkit – Part 4 – Compression Analysis | AtanaSoft has a pretty good tool called CompressTool (there is a pretty hefty price tag with it though). Deiter also has a pretty good compression algorithm that I have used quite a bit in the pas... |