15 | 20 Aug 2014 @ 11:33 PDT | Database | Reply | Partition effectiveness | I didn't think about empty partitions! I'll do some testing with Dieter's suggested syntax, and I'll also test your suggestion for current vs. historical.
Teradata t... |
14 | 19 Aug 2014 @ 01:56 PDT | Database | Reply | Partition effectiveness | Yep.
|
13 | 19 Aug 2014 @ 10:50 PDT | Database | Reply | Partition effectiveness | Dieter,
I think I understand what you are getting at. Here's another issue, though...that '9999-12-31' date is overwhelmingly the most frequently occurring date that we have, so ... |
12 | 13 Aug 2014 @ 10:37 PDT | Database | Reply | Partition effectiveness | Thanks for your reply Raja, but I don't think that's what I'm looking for.
I guess I'm trying to get some assurance that if the optimizer uses a partition for access when i... |
11 | 11 Aug 2014 @ 01:32 PDT | Database | Topic | Partition effectiveness | All of our tables have effective start and end date columns (EFF_STRT_DT, EFF_END_DT). We want to create date partitions on some of our larger tables, and our fist instinct is to create the p... |
10 | 07 Aug 2014 @ 11:48 PDT | Database | Reply | Need metrics for database, table, and column usage in queries. TD 13.10/14.10 | I will look at this info. I believe that I saw some information the other day about QryLogObjects. History is turned on in our 13.10 environments, but it is still turned off in our rece... |
9 | 07 Aug 2014 @ 07:59 PDT | Database | Reply | Determine how much space a Global Temporary Table is using - TD 13.10/14.10 | Dieter,
Thanks very much...just what I needed. I'm still learning where all of this information is stored, so I really appreciate your response.
Robin
|
8 | 04 Aug 2014 @ 11:30 PDT | Database | Topic | Need metrics for database, table, and column usage in queries. TD 13.10/14.10 | We're using Teradata 14.10 and 13.10.
I'm trying to determine which DBC tables and their "historical" counterparts can be queried to tell me how often particular database... |
7 | 04 Aug 2014 @ 11:18 PDT | Database | Topic | Determine how much space a Global Temporary Table is using - TD 13.10/14.10 | How can I best determine how much temp space a Global Temporary Table used during SQL execution? We're running Teradata 14.10 in DEV & QA, and 13.10 in Prod, if it matters.
T... |
6 | 18 Jul 2014 @ 06:54 PDT | Tools | Reply | Scroll Bars in SQL Assistant 15.0 | I got my answer...
When I sent a note to the author of the "What's new in Teradata SQL Assistant 15.0" article, I got my answer. I had to change the "Application Style&quo... |
5 | 24 Jun 2014 @ 08:25 PDT | Tools | Topic | Scroll Bars in SQL Assistant 15.0 | How do I change the appearance of the scroll bars in Teradata SQL Assistant 15.0? There's nothing for me to grab, just a solid line. I don't remember it looking like that when I... |
4 | 04 Mar 2014 @ 10:35 PST | Database | Reply | Primary Index - for access | Krishna,
Thanks for your response.
Many of our tables are only joined one way, but some are joined in multiple ways - for those, we're thinking of creating bridge tables to help keep the join... |
3 | 28 Feb 2014 @ 01:04 PST | Database | Topic | Primary Index - for access | I need some general guidance on choosing a new PI to make table A more easily accessible in joins.
If my join looks like this:
LEFT JOIN A
ON A.INVC_ID = B.INVC_ID
... |
2 | 14 Aug 2013 @ 06:56 PDT | Teradata Studio | Reply | SQL results in Studio 14.2 don't match results from SQL Assistant 13.10 | Sorry for the deelay getting back to you, but I thought that I set myself up to be notified if I received responses.
I got the TMODE reset, and it looks good now. I knew it was somet... |
1 | 10 Jul 2013 @ 07:30 PDT | Teradata Studio | Topic | SQL results in Studio 14.2 don't match results from SQL Assistant 13.10 | When I execute the code below in Teradata Studio 14.2, I get 0 rows returned. When I execute it in SQL Assistant 13.10, I get 129 rows, which is correct. The connections for both applic... |