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
- 5060 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 are the enhanced features in teradata v2r5 and v2r6?
How will you solve the problem that occurs during update?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What are the available primary index types?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
In Teradata, how do we Generate Sequence?
how can we analyze the locks ?
How can we load single row of data into teradata database. please give me the process.
How to identify ppi columns?
What is the Maximum number of volatile tables that can be created?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the functions of a teradata dba?
Teradata 
