How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 5716 Views
- I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Probably, we can try splitting the query by using volatile tables and tuning the query.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the design features involved in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Explain teradata architecture in detail with a diagram.
What is difference between user and database in teradata?
Explain the types of join supports by teradata?
Can we collect statistics on multiple columns?
List the logical and conditional operators that are used with teradata along with their meanings?
Describe the set operators in teradata.
What are some primary characteristics of teradata?
What are some commonly used bteq scripts?
What's the difference between timestamp (0) and timestamp (6)?
What happens when a node suffers a downfall?
Explain teradata architecture?
how do you manage the production space. what are the proactive methods you can take ?
What is meant by a node?
