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
- 4554 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
What are the updated features of teradata?
What happens in a conflict? How do you handle that?
What are the various reporting tools in the market?
What are the design features involved in teradata?
What is the purpose of joins in teradata?
What is smp and mpp platforms?
Explain amp in teradata?
How to view every column and the columns contained in indexes in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Highlight the need for Performance Tuning.
What is the primary index in teradata?
Discuss the advantages of using partitioned primary index in a query?
What do you mean by tpt in teradata?
What are normalization, first normal form, second normal form and third normal form?
What are tpump utility limitations?
