#DateForumTypeThreadPost
715 Dec 2014 @ 02:46 PSTDatabaseTopicCold Tables and MVC probabilityHi, i've written a view that reads from the heatmap view (and function) and gets you the list of the cold tables (Teradata 14.10) so you can find a list of possible candidates to compress! ...
629 Jan 2014 @ 11:47 PSTDatabaseReplyRANGE in INTEGER data fieldsAs I stated in the object of the thread, the datatype is INTEGER. Thank you for the insight of WIDTH_BUCKET and for the RANGE_N solution :) I wasn't sure about using RANGE_N without the invol...
527 Jan 2014 @ 05:38 PSTDatabaseReplyRANGE in INTEGER data fields CASE WHEN ampcputime between '0' and '999' then '0' WHEN ampcputime between '1000' and '1999' then '1' WHEN ampcputime be...
427 Jan 2014 @ 01:46 PSTDatabaseTopicRANGE in INTEGER data fields hi, i've got this table with the field ampcputime, which is a integer and used the following text in a query WHEN ampcputime between '0' and '999'...
327 Jan 2014 @ 01:43 PSTViewpointReplyDCSDBI solved this by working with the scripts in /opt/teradata, by changing the interval of purging to test it, then the system was upgraded to 14.10 without the relevantly additional data (100+GB) and...
213 Jun 2013 @ 07:16 PDTViewpointReplyDCSDBthe version of viewpoint is 13.12 and the 'systems' defined in Teradata Systems still remain the same, with the same names (they haven't changed a bit). The data i would like to cleanup...
113 Jun 2013 @ 04:18 PDTViewpointTopicDCSDBone of the viewpoint databases, 'dcsdb' holds all the data of the DCS in it, but mine in particular has a problem: the data retention is set to 6 months, but the database contains 400+ GB ...