How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 6165 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 two examples of an OLTP environment?
Mention a few of the ETL tools that come under Teradata.
What is the difference between fastload and multiload?
What is teradata? Also, list out some of the primary characteristics of teradata.
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the syntax for case when statement?
What do high confidence, low confidence and no confidence mean in explain plan?
What's the syntax of sub string?
What are the things to be considered while creating secondary index?
What are some primary characteristics of teradata?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
Teradata 
