#DateForumTypeThreadPost
614 Nov 2009 @ 11:44 PSTUDATopicNumeric Overflow errorHi,while firing the below sql, I am getting 'Numeric Overflow Occured during computation'Select A ,B ,C ,D ,E ,sum(F) AS G ,sum(H) AS I from dbname.tblname WHER...
505 Aug 2009 @ 11:58 PDTDatabaseReplyTeradata compressionLet us consider 2 tables; both the tables have 2 column names in common, but after compression, one table yields a significant difference in these columns sizes whereas the other does not. Can anyo...
422 Jul 2009 @ 01:53 PDTDatabaseReplyTeradata compressionThanks for the response, is there any kind of calculation that has to be done to determine the maximum number of columns that can be compressed in a table so as to not affect the performance to a g...
320 Jul 2009 @ 11:20 PDTDatabaseTopicTeradata compressionHi,If I want to compress columns on an table which has an associated view, will there be any impact(s) on the view after compressing the corresponding table?Also, are there any disadvantages or per...
220 Jul 2009 @ 08:30 PDTDatabaseTopicTeradata compressionHi, If I want to compress columns on an table which has an associated view, will there be any impact(s) on the view after compressing the corresponding table? Also, are there any disadvantage...
115 Jul 2009 @ 05:25 PDTDatabaseTopicQuery hangsHi,I am running a set of SQLs via a unix-batch job; the batch job hangs when executing an sql without even updating the log or throwing any error; I checked the spool, and found it to be good enoug...