A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
- 1 Answers
- 3797 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 |
What are aggregate tables? How do you design them using teradata?
If RDBMS is halted what will you do ?
How do you verify a complicated sql?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
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. Rajesh my email-id: rajeshmss87@gmail.com
What is a node in teradata?
How can we load single row of data into teradata database. please give me the process.
which option is used to restart the fast load script?
what is meant by Hot amp?
If the script is aborted. why it is aborted and how can you identify ?
What is differnce between Error code and Error Level in Bteq
What is teradata? Also, list out some of the primary characteristics of teradata.
Teradata 
