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
- 6615 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 the steps involved after the disk manager passes the request?
Highlight all the modes that are present under Confidence Level.
Which is faster fastload or multiload?
in teradata level primary in table level allows duplicates why?
What are the different design perspectives used in teradata?
What is Join Index in TD and How it works?
What are some commonly used bteq scripts?
What is the use of fallback?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Increasing no of amps will increase performance. Is this true?
While creating table my dba has fallback or no fallback in his ddl. What is that?
On which column will you take primary index???
Teradata 
