How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Probably, we can try splitting the query by using volatile tables and tuning the query.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / tdguy
Use execution plan and try to analyze the execution steps.
Try to tune the query. Use secondary index or join index
appropriately, if necessary.
Is This Answer Correct ? | 2 Yes | 0 No |
Describe the between keyword in teradata?
What is meant by MATCHTAG in multiload utility?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain fastload in teradata?
What is the difference between global temporary tables and volatile temporary tables?
What are the primary characteristics of the Teradata.
Aborted in Phase 2 data acquistion completed in fastload?
Explain the term 'primary key' related to relational database management system?
why should we go Teradata over Oracle,what is the main differences?
What are the available primary index types?
What is node? How many nodes and amps used in your previous project?
What are the uses of client software involved in teradata?