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 |
What are the multiload utility limitations?
Explain teradata utilities. What is multiload, fast load, tpump?
How do you Generate Sequence in Teradata?
What is meant by a Virtual Disk?
Explain the term 'tables' related to relational database management system?
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
What is FILLER command in Teradata?
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
in teradata level primary in table level allows duplicates why?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How do you design aggregate tables using teradata?