how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
- 2 Answers
- 5627 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gowthami
hIIIIIII.........
BY using indexes and collect statistics we can increase the
query performance
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How will you solve the problem that occurs during update?
Write a program to show the parser component used in teradata?
How is MLOAD Client System restarted after execution?
What is dimensional modeling?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
what are the uses of fact table and dimension table in banking project?
What is the use of fallback?
In BTEQ, how are the session-mode parameters being set?
Highlight the advantages of PPI(Partition Primary Index).
Explain fastload in teradata?
What are the main components of teradata system?
What are different table types used in teradata?
What does sleep function does in fast load?
When tpump is used instead of multiload?
How is MLOAD Teradata Server restarted after execution?
