#DateForumTypeThreadPost
620 Jul 2015 @ 05:52 PDTDatabaseReplyNeed help with taskHi Alkuin, I didn't catched your problem completly. In general erasing a flag and then setting it in some cases is inefficient and dangerous. So I would concentrate on solution 2. Additional I...
520 Jul 2015 @ 05:36 PDTDatabaseReplyThe degradation in performance of query due to Substr functionHi Sachins, In this case I always try to debug the query with splitting it into volatile tables. The substr of the where moves to the creation of the volatile table, if possible. The substr of the...
417 Dec 2013 @ 03:18 PSTData ModelingReplyErwin report template Hi Raja, Under normal circumstances Entity/Attributes of logical design and Tablename/Column Names of physical design are the same. Only if you have some unusual characters in logical design like...
305 Dec 2013 @ 09:35 PSTGeneralReplyMVC Toolsee http://forums.teradata.com/forum/database/mvc-generated-out-of-v14-00-statistics for an idea BR Roland
205 Dec 2013 @ 07:24 PSTDatabaseReplyMVC generated out of V14.00 statisticsUnfortunately version lacks of two facts: * Biased values are truncated to 26 Characters in the "SHOW STATISTICS VALUES COLUMNSHOW STATISTICS VALUES COLUMN" * Script fails when column i...
105 Dec 2013 @ 05:34 PSTDatabaseTopicMVC generated out of V14.00 statisticsThe "SHOW STATISTICS VALUES COLUMN col ON db.tab; " shows the Biased values of the statistics. In my opinion this is exactly a very good list for multi value compression. The following ...