How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 5912 Views
- I also Faced
- E-Mail Answers
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 |
What are some primary characteristics of teradata?
What is the process to restart the multiload if it fails?
Explain amp in teradata?
Define views in teradata with syntax.
What is the purpose of upsert command?
Explain the meaning of Amp?
What are the available primary index types?
On which column will you take primary index???
what is amp plz explanation
How to load specific no.of records using bteq, or fastload,or multiload
Difference between star and snowflake schemas?
How does hashing happens in teradata?
Teradata 
