#DateForumTypeThreadPost
715 Jul 2012 @ 07:55 PDTDatabaseTopicCollect Stats Multi-Column Hi,   Is 2nd statement redundant?   COLLECT STATISTICS column (dept,emp_no) on Test.Employee; COLLECT STATISTICS column (emp_no) on Test.Employee;   Do...
609 May 2012 @ 08:30 PDTDatabaseReplyDerived Table vs View Thanks very much Ulrich. I think your suggestion using "WITH" clause works in my case.   I'm just wondering why a name "Derived table" given - to me it just ...
508 May 2012 @ 04:29 PDTDatabaseTopicDerived Table vs View Hi,   If I create a view (call it B ) and use that in another SQL (call it A), would that work different from using a derived table?   I'm evaluating this for perfo...
411 Nov 2011 @ 02:44 PSTThird Party SoftwareReplyMissing records within Teradata from Informatica Teradata's default transactio mode rolls back entire transaction to last commit point whenever a sql statement fails. This is unlike ANSI transcation mode, which only fails the current state...
313 Oct 2011 @ 10:55 PDTDatabaseTopicObject dependency Hi,   How to get "View vs Table dependency" from dictionary tables by simple querying them? Query needs to list the table names  used by a View. It is possible in Ora...
213 Oct 2011 @ 10:54 PDTDatabaseTopicObject dependency Hi,   How to get "View vs Table dependency" from dictionary tables by simple querying them? Query needs to list the table names  used by a View. It is possible in Ora...
131 Jul 2011 @ 09:15 PDTToolsReplyTPT_ISSUEHi, We experienced the same issue couple of days ago. I verified that files and paths that are passed as arguments to the commands are all valid. We are invoking the command as below (I've mo...