Interested to Buy Any Domain ? << Click Here >> for more details...
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
- 1 Answers
- 5049 Views
- Teradata, I also Faced
- E-Mail Answers
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 do you mean by INMOD Routines and OUTMODE Routines ?
Can you load multiple data files for same target table using fastload?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is a pseudo key? What is its use???
Explain the teradata primary index mechanics in detail with a diagram.
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are default access rights in teradata? What explicit right can be given to a user?
Explain the parallel data extension in teradata?
How is MLOAD Client System restarted after execution?
Where is teradata rdbms used?
Why do you get spool space errors? How do trouble-shoot them?
Explain vproc in teradata?
Teradata 
