#DateForumTypeThreadPost
801 Nov 2012 @ 10:39 PDTDatabaseTopicExplain plans differ when object (view) names are fully qualified and when they are notDoes the optimizer treat a query differently when the object names in the query are fully qualified vs. when they are not fully qualified ? I came across a query which gives one explain plan when ...
714 Jun 2010 @ 03:44 PDTDatabaseTopicHow do these queries execute?There are three SQL statements (a, b & c) below, each of which performs a left join. Can anyone please explain how the execution of these statements differs from the other? a) select c.c_name, a...
608 Jun 2010 @ 09:39 PDTDatabaseTopicProblem with DBQLogTbl dataAccording to my understanding, the value returned by subtracting StartTime from FirstRespTime should be equal to AMPCpuTime. But this doesnt seem to work. Can anyone please help me understand how a...
521 May 2010 @ 03:32 PDTDatabaseTopicWanna practically try out performance management...but how?I want to practise the performance management on my DemoTDat. How do I setup an environment which gives me enough scope to apply and test various performance management techniques? Is there some to...
420 Mar 2010 @ 11:18 PDTTrainingTopicWhat qualities should a TD-DBA possess?Could anyone please enlist and explain what all qualities should one possess, in order to prove to be an excellent Teradata DBA?
320 Mar 2010 @ 10:45 PDTDatabaseReplyAlternative to count(*) in Teradata@dnoeth: I would like to know why in TD13, count(*) runs much faster than before. Thanks.
210 Mar 2010 @ 09:03 PSTDatabaseReplyStored procedures and macros - Perm spaceThank you!
109 Mar 2010 @ 12:41 PSTDatabaseTopicStored procedures and macros - Perm spaceMacros dont use perm space Stored procedure requires perm space Why?