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 use of PI(primary index) AND SI(secondary index)
Did you write stored procedures in teradata?
what is the default character set in teradata,,?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the frequently used data types in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
what are the file sizes in your project?
What do you mean by fastexport in teradata?
Explain fallback in teradata?
What is a node in teradata? Explain
Increasing no of amps will increase performance. Is this true?