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 |
How does hashing happens in teradata?
Where is teradata rdbms used?
What are the components used in smp and massively parallel processing (mpp) machines?
what is the difference between primary index and secondary index?.
what is the difference between filter and router transmissions
What are the different table types supported by teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the difference between union and union all in teradata?
any one answer me how they can analyzing the project using data ware housing?
What are the available primary index types in teradata.
Why is the case expression used in teradata?
In Teradata, how do we Generate Sequence?