Interested to Buy Any Domain ? << Click Here >> for more details...
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
- 1 Answers
- 4561 Views
- I also Faced
- E-Mail Answers
Answer / tdguy
As a developer, some steps(below) can be suggested.
1. look at the explain plan. check for the join types.
product joins and nested joins consume more time.
2. check for the confidence levels.
3. collect stats
4. use si, ji appropriately.
5. repeat the steps after tuning.
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain some differences between mpp and smp?
What is meant by a Parsing Engine?
What does sleep function does in fast load?
What is the use of upsert command in teradata?
What do you mean by teradata sql assistant?
What is meant by MATCHTAG in multiload utility?
What are teradata utilities?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com
What is the command in bteq to check for session settings ?
How do you verify a complicated sql?
What tools would you use for that?
Teradata 
