If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
Answer / tdguy
In TD, explain plan is like a gift to every developer.
Confidence levels should be observed (low, high or no).
Check for the recommendations of statistics. Try to observe
the plan for any product joins or nested joins. Avoid
unnecessary joins. Use secondary index and join indees
appropriately. Try to repeat the steps in the explain plan
after tuning.
Is This Answer Correct ? | 7 Yes | 0 No |
What is the diffrence between Multiload & Fastload interms of Performance?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
which utitility can use for loading the data from non-teradata to teradata ?
Find 2 highest sal from each dept who have completed 5 year in org
What are the advantages of teradata?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What are the various indexes in teradata? Why are they preferred?
What are the design features involved in teradata?
write lock is compatiable with which type of lock?
what is amp plz explanation
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load