#DateForumTypeThreadPost
803 Jun 2011 @ 07:00 PDTDatabaseReplyNeed help in Optimizing query to fix spool space issueI am no expert in Teradata, but I have a question: Why do you need RANK() OVER (PARTITION BY APLH. Acct_Id ORDER BY APLH.Acct_Prty_Loc_Eff_Dt DESC) K inside the inline view? You are not using...
722 Feb 2010 @ 01:42 PSTDatabaseReplyTeradata PerfomanceThe order of checking the columns for literals is different between the 2 scenarios.
622 Feb 2010 @ 01:40 PSTDatabaseReplyTeradata PerfomanceThe only thing I see is the way it is going after the WHERE clause (filter condition).with NOT EXISTS clause...4) We do an all-AMPs JOIN step from Table1 by way of an all-rows scan with a condition...
519 Feb 2010 @ 07:34 PSTDatabaseReplyTeradata PerfomanceCould it be just one time it happenned or you can repro this at will ?
419 Feb 2010 @ 07:18 PSTDatabaseTopicQuery troubleshootingHow can one start troubleshooting a query and subsequently provide a solution in Teradata.I am looking for best practices.1. How to identify.2. What to look for in terms of metrics (system & SQL le...
319 Feb 2010 @ 06:53 PSTDatabaseReplyHow to find blocksize of a able in teradata?Thanks for your reply.That's very good to know.
219 Feb 2010 @ 01:28 PSTDatabaseReplyHow to find blocksize of a able in teradata?Thanks for your valueable answer.Does TRUNCATE or similar command in Teradata has the same effect?What I mean is if given the 3 scenarios1. I create a table fresh with one columnOR2. I create a tab...
118 Feb 2010 @ 03:18 PSTDatabaseReplyHow to find blocksize of a able in teradata?I am a newbie in Teradata.Does it make any difference in initial size if a table is just created with one column VS multiple columns and does not contain any data?Thanks