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
- 6714 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 |
How you will check the version of teradata?
What are the available primary index types?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is the default join strategy in Teradata???
what is sysdba and sysdbc ? which has high priority ?
What are differences between teradata and ansi session modes in teradata?
Does SDLC changes when you use Teradata instead of Oracle?
What's the difference between timestamp (0) and timestamp (6)?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What do you mean by tpt in teradata?
Which is faster fastload or multiload?
what is use of fload loading into set table?
Teradata 
