A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
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 |
How can we load single row of data into teradata database. please give me the process.
What is the difference between correlated sub queries and inner queries?
why varchar takes 2 extra bytes?
Highlight the limitations of TPUMP Utility.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
Explain the term 'row' related to relational database management system?
What is the difference between teradata and basic rdbms?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
can we join volatile table with general table an global temporary table with general table ?
What is the use of stored procedures in teradata?
which utitility can use for loading the data from non-teradata to teradata ?