How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
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 various reporting tools in the market?
What are the functions involved in shared information architecture?
What do you mean by teradata sql assistant?
Explain amp in teradata?
What is the difference between correlated sub queries and inner queries?
What are the primary characteristics of the Teradata.
plz explain parlla distribution and subtable concept in teradata
What are the differences between TerdataV2R5 and V12 Versions please??
How is Teradata in current market?
In Teradata, what is the significance of UPSERT command?
What is bteq utility in teradata?