#DateForumTypeThreadPost
911 Jun 2009 @ 11:37 PDTDatabaseReplyStats on non index columnPrakhar, may I refer you to an article by Carrie Ballinger on the Teradata Developer Network: The reason for collecting single column and multi-column stats where appropriate is to provide the opti...
811 Jun 2009 @ 10:52 PDTDatabaseReplyAdd days to a date columnWhat is the MAX(Dealer_Date) on the table and does the field allow NULL values?
715 May 2009 @ 09:50 PDTAnalyticsReplyProblem in finding the latest recordI believe in your first query you need to include A.INSERT_TS in your GROUP BY statement.
615 May 2009 @ 09:30 PDTToolsReplyHow to find a primary key in teradata tables?Primary Keys can be enforced with by unique indexes or by using a UNIQUE or PRIMARY KEY constraint on the table. The first goal of your Primary Index is to identify the best access path to the data...
515 May 2009 @ 09:23 PDTDatabaseReplyAdvantage of not Collecting the statsFor what it is worth, in my current environment I am only running a collect stats processing once a week on the weekends. Sure, there are environments where you may not have such a luxury. And as t...
414 May 2009 @ 08:34 PDTDatabaseReplyAdvantage of not Collecting the statsAs I understand the stats collection provides the rows per value for the intervals in the table as well as the min and max values of the column. This helps the optimizer determine the cardinality t...
314 May 2009 @ 08:24 PDTDatabaseReplysuggest ways to clean up DBC.The DBQL, resusage, and accesslog tables can be purged (or data relocated to another database) to satisfy your retention periods. It is also a best practice to use roles to keep the number of rows ...
214 May 2009 @ 08:19 PDTDatabaseReplyTuningCouple ideas:1) What if you add a DATE column to the table for the Effective Start (or Effective End) that convert the values to DATE data types that you can in turn use to partition the table. 2) ...
114 May 2009 @ 06:27 PDTUDAReplyTeradata Default date format Issue.Have you tried using a format clause on your SELECT to return it in the format desired? SELECT CAST(CURRENT_TIMESTAMP(0) AS TIMESTAMP(0) FORMAT 'YYYY-MM-DDBHH:MI:SS');

Pages