If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
- 1 Answers
- 4246 Views
- Teradata, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Difference between stored procedure and macro?
Differentiate database data and data warehouse data?
What are types of partition primary index (ppi) in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
What is a node in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the functions involved in shared information architecture?
What is meant by a Virtual Disk?
In general, how do you optimze any sql in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is database exceptions in teradata?
What are the available primary index types in teradata.
What are the enhanced features in teradata v2r5 and v2r6?
What are the functions of a teradata dba?
What is the difference between union and union all in teradata?
