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
- 4456 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 uses of bynets in multi-node systems?
Differentiate database data and data warehouse data?
Explain the term 'database' related to relational database management system?
How to Extract data from multiple legacy systems?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is logical data model?
What is the primary index in teradata?
What are the functions performed by bynet?
What is meant by a Clique?
Explain PDE.
if collect stats but it show low confidence why?
How is MLOAD Teradata Server restarted after execution?
Did you write stored procedures in teradata?
What is partitioned primary index (ppi)?
