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
- 6577 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 the difference between global temporary tables and volatile temporary tables?
What is basic teradata query language?
What is FILLER command in Teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is use of compress in terdata?Explain?
What is node? How many nodes and amps used in your previous project?
What is the default join strategy in Teradata???
Which is more efficient group by or distinct to find duplicates?
What tools would you use for that?
What is the difference between fastload and multiload? Which one is faster?
what are the default access rights in the teradata?
How you will check the version of teradata?
Teradata 
