#DateForumTypeThreadPost
1520 Aug 2014 @ 11:33 PDTDatabaseReplyPartition effectivenessI 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...
1419 Aug 2014 @ 01:56 PDTDatabaseReplyPartition effectivenessYep.
1319 Aug 2014 @ 10:50 PDTDatabaseReplyPartition effectivenessDieter, 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 ...
1213 Aug 2014 @ 10:37 PDTDatabaseReplyPartition effectivenessThanks 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...
1111 Aug 2014 @ 01:32 PDTDatabaseTopicPartition effectivenessAll 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...
1007 Aug 2014 @ 11:48 PDTDatabaseReplyNeed metrics for database, table, and column usage in queries. TD 13.10/14.10I 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...
907 Aug 2014 @ 07:59 PDTDatabaseReplyDetermine how much space a Global Temporary Table is using - TD 13.10/14.10Dieter,   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
804 Aug 2014 @ 11:30 PDTDatabaseTopicNeed metrics for database, table, and column usage in queries. TD 13.10/14.10We'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...
704 Aug 2014 @ 11:18 PDTDatabaseTopicDetermine how much space a Global Temporary Table is using - TD 13.10/14.10How 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...
618 Jul 2014 @ 06:54 PDTToolsReplyScroll Bars in SQL Assistant 15.0I 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...
524 Jun 2014 @ 08:25 PDTToolsTopicScroll Bars in SQL Assistant 15.0How 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...
404 Mar 2014 @ 10:35 PSTDatabaseReplyPrimary Index - for accessKrishna, 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...
328 Feb 2014 @ 01:04 PSTDatabaseTopicPrimary Index - for accessI 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  ...
214 Aug 2013 @ 06:56 PDTTeradata StudioReplySQL results in Studio 14.2 don't match results from SQL Assistant 13.10Sorry 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...
110 Jul 2013 @ 07:30 PDTTeradata StudioTopicSQL results in Studio 14.2 don't match results from SQL Assistant 13.10When 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...