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
- 4633 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 |
Can any one plz provide the teradata interview questions?
Difference between star and snowflake schemas?
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
what is use of fload loading into set table?
In Teradata, how do we Generate Sequence?
What is the function of parser component in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
What is the use of upsert command in teradata?
What is the difference between SI and JI?
Can we collect statistics on multiple columns?
How to find duplicates in a table?
What are the different table types that are supported by teradata?
Teradata 
