#DateForumTypeThreadPost
508 Sep 2016 @ 04:28 PDTDatabaseReplyCollect Stats with insert statementSTATS are not automatically refreshed, you need a third statement. When you create a table with no data and stats, the stats will be defined as per the original table with zero stats.
410 Dec 2015 @ 07:11 PSTDatabaseReplyProduct Join in Teradata 15The below approach will improve the performance ... SELECT * FROM  table A WHERE (A.c, A.d) in  (SELECT  x, y FROM table b where  user1 = USER group by 1,2 ) UNION ALL ...
310 Dec 2015 @ 06:40 PSTDatabaseReplyLooking for View Definition in DBC tablewhen  QUALIFIED is used (in this case) ,Teradata replace * with fully qualified actual column names of base table. As a result you are viewing the column names in  view definition .
215 May 2015 @ 08:46 PDTGeneralReplydbc.indices ; dbc.indexconstraints ;Thanks !
115 May 2015 @ 04:20 PDTGeneralTopicdbc.indices ; dbc.indexconstraints ;trying to get the partition table names .Queried dbc.indices WHERE indextype ='Q' with databasename = 'XXXX' . Queried  dbc.indexconstraints where databasename = 'XXXX'...