How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 5704 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 is node? How many nodes and amps used in your previous project?
Can we collect statistics on table level?
What are the joins in teradata and how many types of joins are there in teradata?
What is meant by a Channel Driver?
What is a node in teradata?
What are the things to be considered while creating secondary index?
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
List the logical and conditional operators that are used with teradata along with their meanings?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
How do you load Multiple files to a table by using fastload scripts?
Discuss the advantages of using partitioned primary index in a query?
Explain Teradata performance tuning and optimization?
Teradata 
