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
- 6726 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 EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
How can bottlenecks be identified?
Highlight the differences between Primary Key and Primary Index.
How to run a query in teradata?
What is the purpose of upsert command?
what are the file sizes in your project?
what is identity columns in teradata
why varchar takes 2 extra bytes?
What is called partitioned primary index (ppi)?
how can we analyze the locks ?
What's the difference between timestamp (0) and timestamp (6)?
How do you Generate sequence at the time of Display?
Teradata 
