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
- 4556 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 you connect multiload from ab initio?
What is the syntax for case when statement?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
Explain the term 'foreign key' related to relational database management system?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
Which is faster fastload or multiload?
How many tables can you join in v2r5?
Highlight all the modes that are present under Confidence Level.
What are the components provided on node?
Can any one plz provide the teradata interview questions?
what is identity column in TD?
What are the enhanced features in teradata v2r5 and v2r6?
Teradata 
