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
- 6621 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 |
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
How many codd's rules are satisfied by teradata database?
Explain the new features of teradata?
Explain BYNET.
What is stored procedure in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What can be achieved by using the teradata rdbms?
What is a pseudo key? What is its use???
How to run the Teradata jobs in unix environment ???
What are the various indexes in teradata? Why are they preferred?
What are the design features involved in teradata?
Teradata 
