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
- 4528 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain teradata architecture?
Difference between star and snowflake schemas?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is a node in teradata? Explain
Explain some differences between mpp and smp?
Can you connect multiload from ab initio?
What is the use of virtual processor connectivity in teradata?
What are differences between teradata and ansi session modes in teradata?
What is spool space?
What happens when a node suffers a downfall?
What exactly do you know about catching in teradata?
What is the use of teradata system software?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
How would you load a very large file in teradata in general?
What are the functions of a teradata dba?
