Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 6712 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is basic teradata query language?
What is a three-tier data warehouse?
Difference between multiload and tpump?
What is the meaning of Caching in Teradata?
What is meant by Teradata Gateway?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is the difference between teradata and oracle?
if collect stats but it show low confidence why?
How many sessions of MAX is PE capable of handling at a particular time?
Can you connect multiload from ab initio?
What is teradata and why it is used?
Explain teradata utilities?
Explain the types of join supports by teradata?
What are the frequently used data types in teradata?
Write a program to show the parser component used in teradata?
