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
- 4487 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 is the difference between filter and router transmissions
What are the components used in smp and massively parallel processing (mpp) machines?
Describe primary index in teradata?
What do you mean by fastexport in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
What is the use of virtual processor connectivity in teradata?
How to run a query in teradata?
What is real time and near real time data warehousing?
What do you mean by tpt in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are the 5 phases in a multiload utility?
Why AMP & PE are called Vprocs?
Teradata 
