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
- 4629 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
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is the multi-insert?
What are the string manipulation operators and functions associated with teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is teradata? Also, list out some of the primary characteristics of teradata.
Difference between star and snowflake schemas?
Explain the parallel data extension in teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What's the difference between timestamp (0) and timestamp (6)?
How many tables can you join in v2r5?
How to select first n records in teradata?
Explain parsing engine in teradata?
What does sleep function does in fast load?
How do you do backup and recovery in teradata?
Which is faster fastload or multiload?
